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:
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?
Correct Answer: B
Explanation/Reference: 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
