Exam 70-767 topic 1 question 42 discussion

Actual exam question from Microsoft's 70-767

Question #: 42
Topic #: 1

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?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
A data warehouse is too big to store on an SSD.
Instead you should place the log file on a separate drive.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/place-data-and-log-files-on-separate-drives?view=sql-server-2017

by Slava_bcd81 at Oct. 7, 2020, 11:01 a.m.

Comments

Submit Cancel

Hoglet

4 years, 6 months ago

We've had RAID arrays of SSDs for a while now.

upvoted 1 times

eggzamtaker

4 years, 5 months ago

Yes, but this test is from several years ago. So, we need to take that into consideration, too.

upvoted 1 times

...

Slava_bcd81

4 years, 8 months ago

I think the solution from the answer is applicable

upvoted 3 times

Lukis92

4 years, 7 months ago

I agree with you. The content doesn't say how huge is a data warehouse. I met in my career small data warehouses that were stored in SSD disks. Replacing disks to SSD might not be the perfect solution, but definitely minimize write contention on the transaction log comparing with SATA disks.

upvoted 2 times

...