What should you do?

You have a data warehouse named DW1. All data files are located on drive E.

You expect queries that pivot hundreds of millions of rows for each report.

You need to modify the data files to minimize latency.

What should you do?
A . Add more data files to DW1 on drive
C . Add more data files to tempdb on drive
E . Remove data files from tempdb
F . Remove data files from DW1.

View Answer

Answer: B

Explanation:

The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code.

References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database