Nutanix
NCM-MCI-5.20 · Question #72
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…
The correct answer is A. Redistribute existing data by creating additional database file and enable autogrowth. See the full explanation below for the reasoning.
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
How the community answered
(31 responses)- A84% (26)
- B10% (3)
- C3% (1)
- D3% (1)
Community Discussion
No community discussion yet for this question.