NCP-DB-6.10 Exam Questions Get Updated [2026] with Correct Answers [Q54-Q76]

Share

NCP-DB-6.10 Exam Questions Get Updated [2026] with Correct Answers

Practice NCP-DB-6.10 Questions With Certification guide Q&A from Training Expert Prep4King

NEW QUESTION # 54
An administrator manages an multi-cluster NDB instance with HA enabled. After failure, more than one API server VM is down. How should the administrator restore full functionality?

  • A. Manually distribute connections across remaining clusters.
  • B. Restart all database server VMs as NDB HA only tolerates single API server failure.
  • C. Call Nutanix support to reset all API server connections.
  • D. Ensure at least one API server VM is online; the rest will recover automatically.

Answer: D

Explanation:
In a multi-cluster NDB instance with HA enabled, the NDB architecture includes multiple API server VMs to ensure availability. If more than one API server VM is down after a failure, the administrator should ensure at least one API server VM is online. NDB's HA design tolerates multiple API server failures as long as one remains operational, and the remaining VMs will recover automatically through the HA failover mechanism. This leverages Nutanix's distributed architecture and self-healing capabilities to restore full functionality without manual intervention beyond ensuring one VM is running.


NEW QUESTION # 55
Which NDB HA control plane VM is upgraded first during an NDB upgrade?

  • A. NDB Agent VMs
  • B. Leader NDB API Server
  • C. NDB Server
  • D. Leader HAProxy

Answer: B

Explanation:
During an NDB upgrade, the upgrade process follows a specific order to maintain stability and HA. The Leader NDB API Server is upgraded first. This server coordinates API requests and ensures the control plane remains operational. Upgrading the leader first minimizes disruption, as subsequent components (e.g., other API servers, HAProxy) rely on its leadership role. Once the leader is upgraded, the remaining NDB HA control plane VMs (e.g., follower API servers, HAProxy) are updated in sequence.


NEW QUESTION # 56
A DBA team needs to release PostgreSQL HA instances using a dedicated subnet. Which action is mandatory before creating the network profile?

  • A. Configure Network Segmentation.
  • B. The DB VMs must be registered first.
  • C. A VLAN must be added to NDB networks.
  • D. The subnet in Prism Element must be iPAM configured.

Answer: C

Explanation:
To release PostgreSQL HA instances using a dedicated subnet in Nutanix Database Service (NDB), the administrator must create a network profile that defines the subnet and its associated VLAN. Before creating this network profile, it is mandatory to add a VLAN to the NDB Networks configuration. This VLAN ensures that the dedicated subnet is recognized and manageable within NDB, allowing the HA instances to be provisioned with isolated network connectivity. The VLAN must be configured in the NDB Networks page to be available for selection during network profile creation.


NEW QUESTION # 57
A developer with RBAC privileges in Era needs to refresh an existing DB Clone. What steps must the developer take to perform the refresh?

  • A. Navigate to Time Machines Select the appropriate Database Time Machine from the table end Refresh Clone from the Actions menu.
  • B. Navigate to Databases > Sources, Select the appropriate Database from the table and Refresh Clone from the Database Actions menu.
  • C. Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh
  • D. Navigate to Databases > Clones, Select the appropriate clone from the table, choose

Answer: C

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to refresh an existing DB Clone, a developer with RBAC privileges in Era needs to navigate to Databases > Clones. From there, they select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot, and then click Refresh. This process allows the developer to update the cloned database.


NEW QUESTION # 58
An administrator configures VM Host Affinity for database server VMs on a Nutanix AHV-powered cluster, intending to optimize HA by ensuring that VMs are placed on separate hosts. After a host failure, the administrator notices that database VMs are clustered on a single remaining host, risking another outage.
How could the administrator avoid this scenario in future host failures?

  • A. Assign additional backup VMs within the same host to maintain service.
  • B. Increase the number of affinity zones within the cluster
  • C. Set anti-affinity rules to spread VMs across multiple nodes dynamically.
  • D. Configure automatic host failover in Prism Central.

Answer: C

Explanation:
Configuring VM Host Affinity in a Nutanix AHV-powered cluster ensures that VMs are placed on specific hosts to optimize performance or HA. However, after a host failure, if database VMs cluster on a single remaining host, it indicates that the affinity rules alone are insufficient to maintain high availability (HA) during failover scenarios. To prevent this, the administrator should configure anti- affinity rules, which dynamically ensure that VMs (e.g., database server VMs) are spread across multiple hosts. Anti-affinity rules override default VM placement behavior during failover, reducing the risk of a single point of failure by keeping VMs separated even after a host outage.


NEW QUESTION # 59
A development team has requested that an administrator provide them a copy of the production Finance database. The business requires that any financial data is masked before going into development.
How should the administrator create a clone with masked data for the development environment?

  • A. From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.
  • B. 1. Create a script to mask the data.
    2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.
  • C. From the Time Machine, create a clone and paste the masking commands in the post-clone field of the Pre-Post Commands section.
  • D. 1. Create a masking script on the source DB VM, Dev VM or SW Profile VM.
    2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.

Answer: D

Explanation:
According to the Nutanix Database Automation (NCP-DB) course, the Pre-Post Commands section allows the administrator to specify custom scripts that can be executed before or after the clone operation. The masking script can be created on any of the VMs that have access to the source database, such as the source DB VM, the Dev VM, or the SW Profile VM. The script should contain the commands to mask the sensitive data in the Finance database, such as replacing the real values with dummy values or encrypting the data. The administrator can then create the clone from the Time Machine and define the post-clone option with the full path and name of the masking script. This will ensure that the script is executed after the clone is created, and the data is masked before it is available for the development team. The other options are not correct, as they either use the wrong field (pre-clone instead of post-clone), or do not specify where to create or store the masking script.


NEW QUESTION # 60
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)

  • A. Memory
  • B. Compute
  • C. Storage
  • D. Network

Answer: B,C

Explanation:
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance.


NEW QUESTION # 61
A new web application performs up to 200 concurrent connections to a PostgreSQL database. An administrator needs to configure the system to provision those DB servers. Which action would easily help the administrator achieving this goal?

  • A. Edit the API equivalent shell script to apply the setting.
  • B. Use Post Create Command when provisioning the DB.
  • C. Create a new Database Parameters profile.
  • D. Provision a PostqreSQL HA Instance.

Answer: D

Explanation:
A new web application with up to 200 concurrent connections to a PostgreSQL database requires a robust and scalable configuration. Provisioning a PostgreSQL HA (High Availability) instance in NDB is the most effective action to achieve this goal. An HA instance leverages replication (e.g., streaming replication) to distribute load and ensure availability, accommodating high concurrency by allowing multiple nodes to handle traffic. This approach simplifies configuration compared to manual scripting or parameter adjustments.


NEW QUESTION # 62
Refer to the exhibit. An administrator is attempting to take a manual snapshot of a database in ND8 on an AHV cluster. There are multiple Nutanix clusters in this environment and the administrator would like to replicate the snapshot to one of the remote clusters. When attempting to take the snapshot, only a single cluster appears, as shown in the exhibit.
What is the most likely reason that only a single cluster is shown?

  • A. NDB Multi-cluster has not been enabled.
  • B. The remote clusters have an older version of AOS installed.
  • C. The snapshot will be too big to replicate to a remote cluster.
  • D. The remote clusters are running ESXi.

Answer: A

Explanation:
The exhibit shows the "Create Snapshot" interface in NDB, where the administrator can select Nutanix clusters where the snapshot should be made available. However, only a single cluster appears despite multiple clusters in the environment. The most likely reason is that NDB Multi- cluster has not been enabled. Multi-cluster support in NDB requires explicit configuration to enable snapshot replication and data availability across remote clusters (e.g., via Prism Central and network profiles). Without this, NDB restricts snapshot operations to the local cluster where the database resides.


NEW QUESTION # 63
An NDB environment has been deployed with three Nutanix clusters. An administrator has been asked to create a Microsoft SQL Server software profile for each of these clusters. Which is a requirement to create the above-mentioned profiles?

  • A. Enable High Availability for the current NDB Service.
  • B. Compute profile must be created first on every cluster.
  • C. Each cluster must host a VM with the DB engine.
  • D. Enable Multi-cluster capabilities for NDB.

Answer: C

Explanation:
To create a Microsoft SQL Server software profile for each of the three Nutanix clusters in an NDB environment, a key requirement is that each cluster must host at least one VM with the Microsoft SQL Server database engine installed. NDB uses these VMs to discover, validate, and generate software profiles tailored to the specific SQL Server versions and configurations present on each cluster. This ensures that the profiles are compatible with the cluster's environment and can be used for provisioning or patching.


NEW QUESTION # 64
An administrator needs to provide the least-privilege access to a newly-hired engineer whose task is to add new VLANs or IP Pools in NDB.
Which role should the administrator select to complete this task?

  • A. Database Infrastructure Administrator
  • B. Database Administrator
  • C. Infrastructure Administrator
  • D. Super Administrator

Answer: C

Explanation:
An Infrastructure Administrator is a role in NDB that has the permission to manage network and storage resources, such as VLANs, IP Pools, and Storage Containers. This role is suitable for the engineer who needs to add new VLANs or IP Pools in NDB. The other roles have either more or less privileges than required for this task. A Database Administrator can manage databases and database server VMs, but not network and storage resources. A Super Administrator can manage all aspects of NDB, but this is more than the least-privilege access needed. A Database Infrastructure Administrator can manage both databases and network and storage resources, but this is also more than the least- privilege access needed.


NEW QUESTION # 65
An administrator is trying to register a database server VM with NDB. Which file types will prevent the registration from being successful if located in the C:\ drive?

  • A. Database
  • B. System
  • C. Page
  • D. Backup

Answer: C

Explanation:
Page files are temporary files that Windows uses to store data that does not fit in the physical memory. Page files can interfere with the registration of a database server VM with NDB, as they can cause errors or performance issues. Therefore, page files should be located in a separate drive or partition from the C:\ drive, where the NDB agent and other files are installed. System, database, and backup files do not prevent the registration of a database server VM with NDB, as long as they are not corrupted or incompatible with the NDB requirements.


NEW QUESTION # 66
An administrator wants to view the information for all the roles and the number of users assigned to each of them What role must a user belong to in order to view this information?

  • A. Database infrastructure administrator
  • B. Infrastructure administrator
  • C. Super Administrator
  • D. Database administrator

Answer: C

Explanation:
To view information about all roles and the number of users assigned to each in NDB, the user must belong to the Super Administrator role. This role provides full administrative privileges, including access to the "Users and Roles" section of the NDB GUI, where role assignments and user counts are visible. Lower-tier roles (e.g., Database Infrastructure Administrator, Database Administrator, Infrastructure Administrator) have limited scopes and cannot access this comprehensive role/user overview.


NEW QUESTION # 67
Why are NDB database clones significantly faster than traditional database cloning?

  • A. Distributed metadata lookup
  • B. Zero-copy snapshot technology in Nutanix AOS
  • C. Automatic I/O parameter tuning
  • D. GPU-accelerated data duplication

Answer: B

Explanation:
Cloning uses AOS zero-copy snapshots, meaning data is not actually duplicated; only changed blocks require additional storage.


NEW QUESTION # 68
Within NDB, an administrator needs to register a PostgreSQL database server VM with a database. Where should the database data and log files be located in order to successfully complete this task?

  • A. On the same disk as the operating system
  • B. On the same disk as the binary installation
  • C. On a separate mount point
  • D. On the same mount point

Answer: C

Explanation:
To register a PostgreSQL database server VM with a database on NDB, the database data and log files must be located on a separate mount point from the operating system and the binary installation.
This is because NDB uses the mount point as the identifier for the database server VM and the database. If the data and log files are on the same mount point as the operating system or the binary installation, NDB will not be able to recognize them as a valid database server VM or database. Therefore, the administrator should create a separate mount point for the data and log files and specify it during the registration process.


NEW QUESTION # 69
A user wants to apply the latest OS security patches on a Windows server.
How should the user accomplish this task?

  • A. Use update functionality directly on the VM
  • B. Update the database.
  • C. Reboot the system.
  • D. Create and apply a Maintenance Plan in NDB.

Answer: D

Explanation:
To apply the latest OS security patches on a Windows server managed by NDB, the user should create and apply a Maintenance Plan within the NDB interface. NDB provides a Maintenance Plan feature that allows administrators to schedule and automate OS patching for database server VMs, ensuring patches are applied in a controlled manner without disrupting database operations. This includes validating the patch process, rolling back if needed, and maintaining compliance with security standards. The plan can be configured to target the specific Windows server and include the latest security updates from Microsoft.


NEW QUESTION # 70
When provisioning an PostgreSQL HA Instance, what are the minimum and maximum number of DB server VMs that can be deployed in a cluster?

  • A. Min . Max 3
  • B. Min 3, Max 5
  • C. Min 2, Max 4
  • D. Min 2, Max 6

Answer: C

Explanation:
When provisioning a PostgreSQL HA Instance using NDB, the minimum and maximum number of DB server VMs that can be deployed in a cluster are 2 and 4, respectively. A PostgreSQL HA Instance is a database instance that provides high availability and fault tolerance for PostgreSQL databases using the Patroni framework. Patroni is a Python-based tool that manages PostgreSQL configuration and performs automatic failover and switchover operations. Patroni relies on a distributed consensus store, such as etcd, Consul, or ZooKeeper, to store and synchronize the cluster state and leader information. NDB supports etcd as the consensus store for PostgreSQL HA Instances. NDB allows the administrator to provision PostgreSQL HA Instances with different sizes and configurations, such as small, medium, large, or custom. The size of the PostgreSQL HA Instance determines the number of DB server VMs, the number of etcd nodes, the CPU, memory, and disk resources, and the replication factor of the database.
The minimum number of DB server VMs for a PostgreSQL HA Instance is 2, which corresponds to a small size instance. This configuration provides one leader and one follower DB server VM, and one etcd node. The maximum number of DB server VMs for a PostgreSQL HA Instance is 4, which corresponds to a large size instance. This configuration provides one leader and three follower DB server VMs, and three etcd nodes. The other options are not valid for a PostgreSQL HA Instance, as they either do not provide enough redundancy or exceed the supported limit of DB server VMs.


NEW QUESTION # 71
How long is the default continuous recovery for the Gold SLA in Era Time Machine?

  • A. 90 days
  • B. 30 days
  • C. 60 days
  • D. 15 days

Answer: B

Explanation:
The default continuous recovery for the Gold SLA in Era Time Machine is 30 days. This means that the system keeps a continuous recovery point for the last 30 days, allowing you to restore your database to any point within this period.


NEW QUESTION # 72
What is required to cre110ate a network profile in Era?

  • A. The network must be managed by Era.
  • B. The network must contain static IP addresses.
  • C. The network must provide IP address management.
  • D. The network must be added to Era.

Answer: D

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to create a network profile in Era, the network must be added to Era. This is because Era needs to have control over the network in order to manage the databases effectively. Once the network is added to Era, it can be used for various operations such as provisioning new databases, managing existing databases, and more.


NEW QUESTION # 73
How should a patch be downloaded to perform a One-Click Upgrade of an NDB Environment with access to the Internet?

  • A. Download the patch in the Administrator > Maintenance section of NDB.
  • B. Open Prism Central and deploy the current version of NDB from the Apps and Marketplace section.
  • C. Download the patch from the Nutanix Support Portal and upload via the NDB CLI.
  • D. Open Prism Element and use LCM to update the software.

Answer: A

Explanation:
For a One-Click Upgrade of an NDB environment with internet access, the patch should be downloaded directly within the NDB interface. The "Administrator > Maintenance" section of NDB provides an option to connect to the Nutanix download repository (e.g.,
https://download.nutanix.com) and download the latest patch or upgrade bundle automatically.
This streamlined process ensures compatibility and simplifies the upgrade workflow. The One- Click Upgrade feature then applies the downloaded patch to update NDB components efficiently.


NEW QUESTION # 74
What feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration?

  • A. Global Service Level Agreement
  • B. Data Access Management
  • C. Time Machine Cloud Orchestration
  • D. Global Data Protection

Answer: A

Explanation:
The Global Service Level Agreement (SLA) feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration. This feature provides a unified way to manage and enforce backup and replication policies across multiple clusters, ensuring consistent data protection and recovery across the entire environment.


NEW QUESTION # 75
A customer has NDB configured to create snapshots of their production databases every 4 hours.
A developer requires a copy of the current production data at 7:00am of each day. What is the most efficient way to meet this requirement?

  • A. Authorize the developer in RBAC to create clones as required.
  • B. Run a script which creates a clone from the latest snapshot at 7:00am.
  • C. Configure Time Machine to create a clone from a daily snapshot at 7:00am.
  • D. Configure a done with a daily Data Refresh Schedule at 7:00am.

Answer: C

Explanation:
Time Machine is a feature of Nutanix Era that allows you to create and manage snapshots of your databases. You can use Time Machine to create clones from any snapshot, either manually or automatically. You can also configure Time Machine to create clones from snapshots based on a schedule, such as daily, weekly, or monthly. This way, you can ensure that your clones are always up to date with the latest data from your production databases. In this scenario, the most efficient way to meet the developer's requirement is to configure Time Machine to create a clone from a daily snapshot at 7:00am. This will save the developer's time and effort, as well as reduce the storage consumption by using the existing snapshots.


NEW QUESTION # 76
......

Prepare Top Nutanix NCP-DB-6.10 Exam Audio Study Guide Practice Questions Edition: https://www.prep4king.com/NCP-DB-6.10-exam-prep-material.html

Free Nutanix NCP-DB-6.10 Test Practice Test Questions Exam Dumps: https://drive.google.com/open?id=1vYLTQxalpxs3emFbsWu_DuxprbhdsNQZ