Nutanix Exam NCM-MCI5.15 Topic 1 Question 37 Discussion

Actual exam question for Nutanix's NCM-MCI5.15 exam

Question #: 37
Topic #: 1

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?

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

Show Suggested Answer

Suggested Answer: A

by Erinn at May 29, 2022, 05:05 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!