Nutanix
NCM-MCI-5.20 · Question #154
Refer to the exhibit. A Microsoft SQL 2016 deployment is shown in the exhibit. The administrator receives user reports that database queries take too long to return. Which optimization should be…
The correct answer is C. TempDB, and Logs disk Separate the Database. TempDB, and Logs onto their own disks. See the full explanation below for the reasoning.
Question
Refer to the exhibit. A Microsoft SQL 2016 deployment is shown in the exhibit. The administrator receives user reports that database queries take too long to return. Which optimization should be made to this configuration to improve performance?
Exhibit
Options
- ACombine both of the OS and SQL Binaries disks
- BAdd a second SCSI controller for the Database.
- CTempDB, and Logs disk Separate the Database. TempDB, and Logs onto their own disks
- DConfigure the VM to use a PCI disk controller
How the community answered
(44 responses)- A7% (3)
- B11% (5)
- C80% (35)
- D2% (1)
Community Discussion
No community discussion yet for this question.