Nutanix NCP-DB-6.5 Practice Exams
Last updated on Oct 06,2026- Exam Code: NCP-DB-6.5
- Exam Name: Nutanix Certified Professional - Database Automation (NCP-DB) v6.5
- Certification Provider: Nutanix
- Latest update: Oct 06,2026
Question #111
When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.
What is the easiest way for the administrator to accomplish this task?
- A . Create a Compute Profile and apply it to the VMs during provisioning.
- B . Update the VMs after provisioning and enter the changes to the vCPU cores.
- C . After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.
- D . Create a Windows Domain Profile that will synchronize the configurations.
Correct Answer: A
A
Explanation:
A Compute Profile is a template that defines the CPU, memory, and disk resources for a database server VM. By creating a Compute Profile with the desired number of cores per vCPU, the administrator can easily apply it to multiple VMs during provisioning, ensuring consistent and optimal performance. This also saves time and effort compared to updating the VMs individually or modifying the default profile after provisioning.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, How-to setup number of cores per CPU in a virtual machine.
A
Explanation:
A Compute Profile is a template that defines the CPU, memory, and disk resources for a database server VM. By creating a Compute Profile with the desired number of cores per vCPU, the administrator can easily apply it to multiple VMs during provisioning, ensuring consistent and optimal performance. This also saves time and effort compared to updating the VMs individually or modifying the default profile after provisioning.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, How-to setup number of cores per CPU in a virtual machine.
Question #112
An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?
- A . Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.
- B . Create a new Software Profile version using the CU executable and publish that version.
- C . Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
- D . Create a new Software Profile using the CU executable and publish that profile.
Correct Answer: C
C
Explanation:
The correct answer is C because it follows the recommended procedure for applying a CU to a SQL
Server Software Profile in NDB. By applying the patch to the profile VM, the administrator ensures that the CU is compatible with the existing Software Profile settings and configuration. By creating a new Software Profile version, the administrator preserves the previous version of the Software Profile for rollback purposes and allows the new version to be tested and published. Option A is incorrect because it deletes the existing Software Profile, which may cause data loss and prevent rollback. Option B is incorrect because it does not apply the patch to the profile VM, which may result in errors or inconsistencies in the Software Profile. Option D is incorrect because it creates a new Software Profile instead of a new version, which may cause confusion and duplication.
Reference: The following sources provide more information about the Software Profile management and patching in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 5: Patching Databases Using
NDB, Lesson 5.2: Creating and Modifying Software Profiles
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 4 – Operate and Maintain an NDB Environment
Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.2:
Creating and Modifying Software Profiles
Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.3:
Testing and Publishing Database Patches
C
Explanation:
The correct answer is C because it follows the recommended procedure for applying a CU to a SQL
Server Software Profile in NDB. By applying the patch to the profile VM, the administrator ensures that the CU is compatible with the existing Software Profile settings and configuration. By creating a new Software Profile version, the administrator preserves the previous version of the Software Profile for rollback purposes and allows the new version to be tested and published. Option A is incorrect because it deletes the existing Software Profile, which may cause data loss and prevent rollback. Option B is incorrect because it does not apply the patch to the profile VM, which may result in errors or inconsistencies in the Software Profile. Option D is incorrect because it creates a new Software Profile instead of a new version, which may cause confusion and duplication.
Reference: The following sources provide more information about the Software Profile management and patching in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 5: Patching Databases Using
NDB, Lesson 5.2: Creating and Modifying Software Profiles
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 4 – Operate and Maintain an NDB Environment
Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.2:
Creating and Modifying Software Profiles
Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.3:
Testing and Publishing Database Patches
Question #113
In NDB, which two Time Machine options are available when creating a database clone? (Choose two.)
- A . Point in time
- B . Restore point
- C . Backup
- D . Snapshot
Correct Answer: A, D
A, D
Explanation:
The correct answer is A and D because these are the two Time Machine options that are available when creating a database clone in NDB. Point in time allows the user to specify a date and time to create a clone from a specific point in the database history. Snapshot allows the user to select a previously taken snapshot to create a clone from a consistent state of the database.
Option B is incorrect because Restore point is not a Time Machine option, but a feature that allows the user to restore a source database to a previous point in time.
Option C is incorrect because Backup is not a Time Machine option, but a feature that allows the user to backup a database to a remote location.
Reference: The following sources provide more information about the Time Machine options and cloning features in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using Time Machine, Lesson 4.2: Cloning Databases
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 5 – Protect NDB-managed Databases Using Time Machine
Nutanix Database Service (NDB) User Guide, Chapter 6: Protecting Databases Using Time Machine,
Section 6.2: Cloning Databases
[Nutanix Support & Insights], NDB Time Machine Under the Hood
A, D
Explanation:
The correct answer is A and D because these are the two Time Machine options that are available when creating a database clone in NDB. Point in time allows the user to specify a date and time to create a clone from a specific point in the database history. Snapshot allows the user to select a previously taken snapshot to create a clone from a consistent state of the database.
Option B is incorrect because Restore point is not a Time Machine option, but a feature that allows the user to restore a source database to a previous point in time.
Option C is incorrect because Backup is not a Time Machine option, but a feature that allows the user to backup a database to a remote location.
Reference: The following sources provide more information about the Time Machine options and cloning features in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using Time Machine, Lesson 4.2: Cloning Databases
Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 5 – Protect NDB-managed Databases Using Time Machine
Nutanix Database Service (NDB) User Guide, Chapter 6: Protecting Databases Using Time Machine,
Section 6.2: Cloning Databases
[Nutanix Support & Insights], NDB Time Machine Under the Hood
Question #114
Which NDB feature collects logs and snapshots from databases?
- A . Database Restore
- B . Time Machine
- C . SLA
- D . One-click Patching
Correct Answer: B
B
Explanation:
The correct answer is B because the Time Machine feature of NDB collects logs and snapshots from databases and stores them in a distributed file system. The Time Machine enables the administrator to protect, clone, and restore databases using the SLA policies and the NDB UI or API. The Time Machine also manages the replication of database snapshots in an NDB multicluster environment. The other options are not correct because they describe different features or functions of NDB. Option A is not correct because Database Restore is an operation that uses the Time Machine to restore a source database or a clone to a previous point in time. Option C is not correct because SLA is a policy that defines the frequency and retention of database snapshots and logs. Option D is not correct because One-click Patching is a feature that allows the administrator to test, publish, and apply database patches using the NDB UI or API.
Reference: Nutanix Database Management & Automation (NDMA) course, Nutanix Certified Professional – Database Automation (NCP-DB) certification, Nutanix NCP-DB Certification Exam Syllabus and Study Guide, Nutanix Support & Insights
B
Explanation:
The correct answer is B because the Time Machine feature of NDB collects logs and snapshots from databases and stores them in a distributed file system. The Time Machine enables the administrator to protect, clone, and restore databases using the SLA policies and the NDB UI or API. The Time Machine also manages the replication of database snapshots in an NDB multicluster environment. The other options are not correct because they describe different features or functions of NDB. Option A is not correct because Database Restore is an operation that uses the Time Machine to restore a source database or a clone to a previous point in time. Option C is not correct because SLA is a policy that defines the frequency and retention of database snapshots and logs. Option D is not correct because One-click Patching is a feature that allows the administrator to test, publish, and apply database patches using the NDB UI or API.
Reference: Nutanix Database Management & Automation (NDMA) course, Nutanix Certified Professional – Database Automation (NCP-DB) certification, Nutanix NCP-DB Certification Exam Syllabus and Study Guide, Nutanix Support & Insights
Question #115
An administrator has applied an Oracle security patch to a database server VM registered in Era.
How do you make this change available to other existing database instances?
- A . Register the VM as a have’ database server VM and then create a software profile using this newly registered VIVI.
- B . Create a n.. software profile version from the patched VM.
- C . Merge the changes into an existing software profile.
- D . Create a new software profile in Era from the patched VM.
Correct Answer: D
D
Explanation:
Nutanix Database Service (NDB) uses software profiles for database patching to keep your databases secure and optimized1. When a new database is provisioned, it will be on your current environment’s database version to maintain consistency and stop version sprawl1. Therefore, after an administrator has applied an Oracle security patch to a database server VM registered in Era, the change can be made available to other existing database instances by creating a new software profile in Era from the patched VM1.
D
Explanation:
Nutanix Database Service (NDB) uses software profiles for database patching to keep your databases secure and optimized1. When a new database is provisioned, it will be on your current environment’s database version to maintain consistency and stop version sprawl1. Therefore, after an administrator has applied an Oracle security patch to a database server VM registered in Era, the change can be made available to other existing database instances by creating a new software profile in Era from the patched VM1.
Question #116
An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance.
Which step should the administrator take before applying the patch?
- A . Create a new software profile.
- B . Put the database instance into maintenance mode.
- C . Go to the Software Profile Version widget and click update.
- D . Migrate a new software profile.
Correct Answer: A
A
Explanation:
Nutanix Database Service (NDB) supports automated minor version upgrades for PostgreSQL1. Before applying the patch, the administrator should create a new software profile2. This is because the software profile contains the database engine binaries and other software required to run the database engine2. Therefore, to apply a minor version upgrade, a new software profile with the updated binaries needs to be created2. Once the new software profile is created, it can be used to patch the PostgreSQL database2.
A
Explanation:
Nutanix Database Service (NDB) supports automated minor version upgrades for PostgreSQL1. Before applying the patch, the administrator should create a new software profile2. This is because the software profile contains the database engine binaries and other software required to run the database engine2. Therefore, to apply a minor version upgrade, a new software profile with the updated binaries needs to be created2. Once the new software profile is created, it can be used to patch the PostgreSQL database2.
Question #117
How long is the default continuous recovery for the Gold SLA in Era Time Machine?
- A . 30 days
- B . 15 days
- C . 60 days
- D . 90 days
Correct Answer: A
A
Explanation:
The default continuous recovery for the Gold SLA in Era Time Machine is 30 days1. 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 period1.
A
Explanation:
The default continuous recovery for the Gold SLA in Era Time Machine is 30 days1. 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 period1.
Question #118
An administrator needs to add a stretched VLAN across two clusters in NDB
Which two prerequisites should be met prior to completing this action? (Choose two.)
- A . VLAN must be IPAM.
- B . VLAN must be static.
- C . Both clusters must be registered in NDB.
- D . Nutanix Cluster Management must be enabled.
Correct Answer: B, C
B, C
Explanation:
A stretched VLAN is a virtual network that spans across multiple Nutanix clusters and allows the communication between VMs on different clusters using the same subnet. A stretched VLAN can be used to provide high availability and load balancing for NDB components, such as HAProxy VMs, that require a virtual IP address (VIP) to be accessible from any cluster. To add a stretched VLAN across two clusters in NDB, the administrator needs to meet two prerequisites: the VLAN must be static and both clusters must be registered in NDB. A static VLAN is a VLAN that is manually created and configured by the administrator, as opposed to an IPAM VLAN that is automatically created and managed by NDB. A static VLAN can be added to a stretched VLAN in NDB, while an IPAM VLAN cannot. Both clusters must be registered in NDB before adding a stretched VLAN, as NDB needs to have the information and access to the clusters and their networks. The administrator can register the clusters in NDB using the Prism Element details, agent network configuration, and storage container information. The other option, Nutanix Cluster Management, is not a prerequisite for adding a stretched VLAN in NDB. Nutanix Cluster Management is a feature that allows the administrator to manage multiple Nutanix clusters from a single NDB UI, such as creating or deleting clusters, adding or removing nodes, or performing cluster operations. Nutanix Cluster Management is not required for adding a stretched VLAN, as the VLANs are created and configured in Prism Element, not in NDB.
Reference: Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Section 2 – Deploy and Configure an NDB Solution, Objective 2.3: Configure NDB High Availability Nutanix Database Management & Automation (NDMA) Course, Module 3: Nutanix Database Service (NDB) Installation and Configuration, Lesson 3.3: Configuring NDB High Availability, Topic: NDB HA Architecture and Components Nutanix Database Service High Availability Deployment Overview, Section: HAProxy VMs and Stretched VLANs [Configuring a Virtual NIC to Operate in Access or Trunk Mode – Nutanix], Section: Creating a vNIC in Access or Trunk Mode
B, C
Explanation:
A stretched VLAN is a virtual network that spans across multiple Nutanix clusters and allows the communication between VMs on different clusters using the same subnet. A stretched VLAN can be used to provide high availability and load balancing for NDB components, such as HAProxy VMs, that require a virtual IP address (VIP) to be accessible from any cluster. To add a stretched VLAN across two clusters in NDB, the administrator needs to meet two prerequisites: the VLAN must be static and both clusters must be registered in NDB. A static VLAN is a VLAN that is manually created and configured by the administrator, as opposed to an IPAM VLAN that is automatically created and managed by NDB. A static VLAN can be added to a stretched VLAN in NDB, while an IPAM VLAN cannot. Both clusters must be registered in NDB before adding a stretched VLAN, as NDB needs to have the information and access to the clusters and their networks. The administrator can register the clusters in NDB using the Prism Element details, agent network configuration, and storage container information. The other option, Nutanix Cluster Management, is not a prerequisite for adding a stretched VLAN in NDB. Nutanix Cluster Management is a feature that allows the administrator to manage multiple Nutanix clusters from a single NDB UI, such as creating or deleting clusters, adding or removing nodes, or performing cluster operations. Nutanix Cluster Management is not required for adding a stretched VLAN, as the VLANs are created and configured in Prism Element, not in NDB.
Reference: Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Section 2 – Deploy and Configure an NDB Solution, Objective 2.3: Configure NDB High Availability Nutanix Database Management & Automation (NDMA) Course, Module 3: Nutanix Database Service (NDB) Installation and Configuration, Lesson 3.3: Configuring NDB High Availability, Topic: NDB HA Architecture and Components Nutanix Database Service High Availability Deployment Overview, Section: HAProxy VMs and Stretched VLANs [Configuring a Virtual NIC to Operate in Access or Trunk Mode – Nutanix], Section: Creating a vNIC in Access or Trunk Mode
Question #119
Where should an administrator perform an upgrade within the Era management interface?
- A . Operations > Current Recent
- B . Profiles Software
- C . Alerts
- D . Administration > Maintenance
Correct Answer: D
D
Explanation:
In the Nutanix Era management interface, an administrator should perform an upgrade under the Administration > Maintenance section1. As part of the upgrade process, the Era server is upgraded first, followed by all the Era cluster agents and database server agents in parallel1. The Dashboard displays the current version and an option to upgrade the Era server to a latest version when a new version is available for upgrade1. This ensures that the Nutanix Era environment is always up-to-date with the latest features and security updates1.
D
Explanation:
In the Nutanix Era management interface, an administrator should perform an upgrade under the Administration > Maintenance section1. As part of the upgrade process, the Era server is upgraded first, followed by all the Era cluster agents and database server agents in parallel1. The Dashboard displays the current version and an option to upgrade the Era server to a latest version when a new version is available for upgrade1. This ensures that the Nutanix Era environment is always up-to-date with the latest features and security updates1.
Question #120
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 a separate mount point
- B . On the same mount point
- C . On the same disk as the binary installation
- D . On the same disk as the operating system
Correct Answer: A
A
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.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, [How to Allow Remote Access to PostgreSQL database], [5 Ways to Host PostgreSQL Databases], [Starting the Database Server].
A
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.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, [How to Allow Remote Access to PostgreSQL database], [5 Ways to Host PostgreSQL Databases], [Starting the Database Server].