1. Home
  2. Discussions
  3. Nutanix
  4. NCM-MCI
  5. NCM-MCI-5.20 Discussions
  6. NCM-MCI-5.20 Exam Topic 1 Question 6 Discussion

Nutanix Certified Master - Multicloud Infrastructure (NCM-MCI) 5.20 NCM-MCI-5.20 Question # 6 Topic 1 Discussion

 Nutanix Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Nutanix Certified Master - Multicloud Infrastructure (NCM-MCI) 5.20 NCM-MCI-5.20 Question # 6 Topic 1 Discussion

NCM-MCI-5.20 Exam Topic 1 Question 6 Discussion:
Question #: 6
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?
A.

Redistribute existing data by creating additional database file and enable autogrowth

B.

Create multiple TempDB data files and enable autogrowth

C.

Create multiple SQL log files and disable autogrowth

D.

Redistribute existing data by creating additional database files and disable autogrowth

Get Premium NCM-MCI-5.20 Questions
Actual exam question for Nutanix NCM-MCI-5.20 exam by Thorne86570 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next