Implementing a SQL Data Warehouse — Question 66

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?

Answer options

• A. Add more data files to DW1 on drive E.
• B. Add more data files to tempdb on drive E.
• C. Remove data files from tempdb
• D. Remove data files from DW1.

Correct answer: B

Explanation

The correct answer is B because adding more data files to tempdb allows SQL Server to distribute the workload more effectively, reducing contention and improving performance for large queries. Options A and D would not directly address latency issues related to query processing, and option C may hinder performance by removing resources that could help manage temporary data operations.