Nutanix
NCM-MCI-5.20 · Question #72
NCM-MCI-5.20 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock NCM-MCI-5.20 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
After the migration, some SQL queries take longer to execute than prior to migration. The following SQL best practices were applied while creating the SQL VM on Nutanix: - 8 vDisks per SQL server VM - Database and Log files on separate vDisk - 2 TempDB database drives and 1 TempDB log drive What should the administrator to do improve the SQL Server performance?
Options
- ARedistribute existing data by creating additional database file and enable autogrowth
- BCreate multiple TempDB data files and enable autogrowth
- CCreate multiple SQL log files and disable autogrowth
- DRedistribute existing data by creating additional database files and disable autogrowth
Unlock NCM-MCI-5.20 to see the answer
You've previewed enough free NCM-MCI-5.20 questions. Unlock NCM-MCI-5.20 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.