ExamGecko
Search Search Login
Home Home / Nutanix / NCM-MCI
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

An administrator needs to provide data integrity at the application level for a VM that is replicated to a secondary site. Which requirement will satisfy this task?
An Administrator expanded the disk capacity on a windows VM, but the VM operator saw no difference in its space. Which Addition task must the administrator take ?
An administrator has an existing Nutanix seven-node cluster running at RF2 that must be changed to have the following capabilities: • RF3 set for the cluster • Performance tier deduplication What is the minimum memory needed on the CVMs to allow for these capabilities?
An administrator needs to forecast infrastructure requirements for a new program and its associated applications. Prior to the projected start of the new program, all existing applications will be decommissioned. How should the administrator perform this task?
An administrator is managing two AHV and vSphere-Based Clusters. The administrator is able to install a Windows Guest OS from an ISO Image to VMWare VMs , but is unable to do the same activity with AHV VMs. What should the administrator do to successfully perform this action with AHV VMs?
Which statement best defines Replication factor 2 (RF2 ) ?
What are two types of Protection Domains that Nutanix Offers for data Protection? Choose Two
An application owner had reported that an AHV - based critical application VM is performing very slowly, after initial diagnostics is has been observed that the CPU utilization is significantly higher than normal. What two actions should the administrator take on this VM without shutting it down? choose two.
Which Component Allows you to pair sites for disaster Recovery Policy Creation Using Nutanix Leap?
Nutanix Support Asked an administrator to provide AHV logs to help solve a support request. Which task should be performed to provide log files to the support team?

Question 96 - NCM-MCI discussion

Report
Export

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
Answers
A.
Redistribute existing data by creating additional database file and enable autogrowth
B.
Create multiple TempDB data files and enable autogrowth
Answers
B.
Create multiple TempDB data files and enable autogrowth
C.
Create multiple SQL log files and disable autogrowth
Answers
C.
Create multiple SQL log files and disable autogrowth
D.
Redistribute existing data by creating additional database files and disable autogrowth
Answers
D.
Redistribute existing data by creating additional database files and disable autogrowth
Suggested answer: A
Show Answer
asked 23/09/2024
Yuwadee Srisathan
40 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms