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 nee

d to minimize write contention on the transaction log when data is being loaded to the database.

Solution: You add more data files to

DB1

.

Does this meet the goal?

A. Yes

B. No

Explanation:

There is no performance gain, in terms of log

throughput, from multiple log files. SQL Server does not write log records in parallel to multiple log files.

Instead you should place the log file on a separate drive.

References:

https://www.red-gate.com/simple-talk/sql/database-administration/optimizi

ng-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