Implementing a SQL Data Warehouse — Question 63

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You plan to deploy a Microsoft SQL server that will host a data warehouse named DB1.
The server will contain four SATA drives configured as a RAID 10 array.
You need to minimize write contention on the transaction log when data is being loaded to the database.
Solution: You replace the SATA disks with SSD disks.
Does this meet the goal?

Answer options

Correct answer: B

Explanation

Replacing SATA disks with SSD disks does not directly address the issue of write contention on the transaction log. While SSDs can improve overall performance, the contention issue is primarily related to how the transaction log is managed and configured, which may require other optimizations. Therefore, the solution does not meet the goal.