ExamGecko
Search Search Login
Home Home / Nutanix / NCS-Core
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

An administrator needs to make sure an RF3 cluster can survive a failure of two complete racks without negatively affecting performance. The current cluster configuration consists of the following: * 30 All Flash Nodes: distributed 10 nodes per rack across three 42U racks * Each node is configured with 20TB usable storage all flash (Cluster Total 600TB Usable) * Current cluster utilization is 500TB storage * Storage containers have Erasure Coding enabled Which configuration changes should be made to make sure the cluster meets the requirements?
An administrator is monitoring the Nutanix v5.15-based AOS cluster performance logs and notices that a SQL server VM is greatly exceeding its intended maximum IOPS. The administrator has confirmed that a QoS policy was previously created for the group of VMs this server is a member of. What are two reasons that this VM would exceed its maximum configured IOPS from the QoS Policy? (Choose two.)
An administrator is planning to deploy a Nutanix cluster to support a few high-performance VMs. This deployment will have the following considerations: * Individual VMs will likely generate network throughputs in the range of 90-100Mbps * Due to the configuration of the VMs, it is unlikely that a node will host more than one or two of them at a time * Individual VMs will communicate with only a few (one or two) remote hosts at a time * Multicast will not be used in the environment * The hosts are connected via two 1GbE network connections How should the administrator configure the network bonds to meet this requirement while maintaining the simplest switch configuration?
Which two files should be downloaded to deploy Foundation VM on VMware ESXI or AHV Hypervisors? (Choose two.)
An administrator is deploying an application using Nutanix Volumes. After configuring the volume group and connecting the guest's iSCSI initiator to the volume group, they begin performance testing. The administrator learns that performance on the virtual disk attached to the iSCSI initiator is far less than that of a virtual disk connected directly to the VM. Which situation is causing this condition?
During which part of the Knowledge Transfer does the customer learn about Nutanix basics and their environment at a high level?
A consultant has finished imaging all assigned clusters and is ready to close out the engagement Which action is part of the Closeout Checklist?
An administrator deploys Exchange on a Nutanix cluster. The administrator creates two containers with RF2 configuration: * One container for Exchange * One container for the other VMs The Exchange VM is experiencing I/O performance issues. Which changes to Storage Optimization should be used on the Exchange container to enhance I/O performance?
An administrator needs to replace an aging SAN and move to a hyper-converged infrastructure. The existing environment consists of the following hosts that are connected to the SAN: * 5xAIX hosts * 3x Hyper-V hosts * 9xESXi hosts * 2x physical SQL Clusters (Windows Server 2012R2 hosts) After deploying a Nutanix AHV cluster, which two actions should the administrator take to meet the requirements? (Choose two.)
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?

Question 104 - NCS-Core 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: B

Explanation:

In the scenario where SQL queries are running slower post-migration, creating multiple TempDB data files is a recognized best practice for optimizing SQL Server performance, especially when dealing with high transaction rates or complex queries. This approach helps in distributing the I/O load across multiple files and drives, reducing the contention and wait times associated with TempDB, which is a common bottleneck in SQL Server environments. Enabling autogrowth ensures that these files can dynamically grow as needed, which helps in handling unexpected increases in database activity without manual intervention.

Reference: Nutanix Best Practices for SQL Server, SQL Server performance tuning guidelines.

Show Answer
asked 23/09/2024
Coropcianu Mihai
36 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