Note: This question is part of a series of questions that p
resent 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 configur
ed 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 configure the server to automatically delete the transaction logs nightly.
Does this meet the goal?
A. Yes
B.
No
Explanation:
You should place the log file on a separate drive.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/pol
icy-based-management/place-data-and-log-files-on-separate-drives?view=sql-server-2017