Valid 70-767 Dumps shared by ExamDiscuss.com for Helping Passing 70-767 Exam! ExamDiscuss.com now offer the newest 70-767 exam dumps, the ExamDiscuss.com 70-767 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-767 dumps with Test Engine here:
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 configure the server to automatically delete the transaction logs nightly. Does this meet the goal?
Correct Answer: B
Explanation/Reference: Explanation: You should place the log file on a separate drive. References: https://www.red-gate.com/simple-talk/sql/database-administration/optimizing-transaction-log-throughput/ https://docs.microsoft.com/en-us/sql/relational-databases/policy-based-management/place-data-and-log- files-on-separate-drives?view=sql-server-2017