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 #11
Which two options can NDB leverage to refresh a database clone? (Choose two.)
- A . Cerebro logs
- B . Snapshots
- C . Transaction logs
- D . Templates
Correct Answer: B, C
B, C
Explanation:
NDB can leverage snapshots and transaction logs to refresh a database clone to the latest state of the source database. Snapshots are point-in-time copies of the database that are stored on the Nutanix cluster. Transaction logs are records of the changes made to the database after the snapshot was taken. NDB can use either snapshots or transaction logs, or a combination of both, to refresh a database clone. Cerebro logs and templates are not used for refreshing database clones. Cerebro logs are used for log catch-up operations, which are different from refresh operations. Templates are used for provisioning new databases, not for refreshing existing ones.
Reference: Nutanix Database Management & Automation (NDMA) course, Module 4, Lesson 4.3 – Refreshing Clones
Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Clone Database Management
B, C
Explanation:
NDB can leverage snapshots and transaction logs to refresh a database clone to the latest state of the source database. Snapshots are point-in-time copies of the database that are stored on the Nutanix cluster. Transaction logs are records of the changes made to the database after the snapshot was taken. NDB can use either snapshots or transaction logs, or a combination of both, to refresh a database clone. Cerebro logs and templates are not used for refreshing database clones. Cerebro logs are used for log catch-up operations, which are different from refresh operations. Templates are used for provisioning new databases, not for refreshing existing ones.
Reference: Nutanix Database Management & Automation (NDMA) course, Module 4, Lesson 4.3 – Refreshing Clones
Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Clone Database Management
Question #12
An administrator would like to replicate database snapshots to remote Nutanix clusters.
What should the administrator do to manage Time Machine data availability across all registered Nutanix clusters in NDB?
- A . Add Data Access to each Nutanix cluster and assign a DAM policy.
- B . Update the cluster’s Data Access & select the remote cluster.
- C . Update the SLA on the Time Machine & schedule the remote replication.
- D . Select the snapshots & replicate them to each Nutanix cluster.
Correct Answer: A
A
Explanation:
To replicate database snapshots to remote Nutanix clusters, the administrator needs to add Data Access to each Nutanix cluster and assign a Data Availability Management (DAM) policy. Data Access is a feature of NDB that enables cross-cluster data mobility and protection. A DAM policy defines the replication frequency, retention period, and priority of the database snapshots across the clusters. By adding Data Access to each Nutanix cluster and assigning a DAM policy, the administrator can manage the Time Machine data availability across all registered Nutanix clusters in NDB.
Reference: Nutanix Support & Insights, section “NDB Data Access”
A
Explanation:
To replicate database snapshots to remote Nutanix clusters, the administrator needs to add Data Access to each Nutanix cluster and assign a Data Availability Management (DAM) policy. Data Access is a feature of NDB that enables cross-cluster data mobility and protection. A DAM policy defines the replication frequency, retention period, and priority of the database snapshots across the clusters. By adding Data Access to each Nutanix cluster and assigning a DAM policy, the administrator can manage the Time Machine data availability across all registered Nutanix clusters in NDB.
Reference: Nutanix Support & Insights, section “NDB Data Access”
Question #13
Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)
- A . NTP, DNS servers, gateway, and subnet mask must be available and visible to Ere,
- B . One static IP address must be available and changed using CLI after VM deployment.
- C . A storage container must be available es a prerequisite.
- D . An SMTP server and details must be provided for notifications.
Correct Answer: A, B
A, B
Explanation:
Option A: Nutanix Era requires network prerequisites like NTP, DNS servers, gateway, and subnet mask to be available and visible. These are essential for the proper functioning of the Era instance1. Option B: One static IP address must be available and can be changed using CLI after VM deployment. This is necessary for the Era VM to communicate with other components in the network1.
Option C: While a storage container is necessary for Nutanix infrastructure, it is not a network prerequisite specifically for deploying an Era instance.
Option D: An SMTP server and details are typically used for sending notifications, but they are not a network prerequisite for deploying an Era instance. They are more related to the operational aspect post-deployment.
A, B
Explanation:
Option A: Nutanix Era requires network prerequisites like NTP, DNS servers, gateway, and subnet mask to be available and visible. These are essential for the proper functioning of the Era instance1. Option B: One static IP address must be available and can be changed using CLI after VM deployment. This is necessary for the Era VM to communicate with other components in the network1.
Option C: While a storage container is necessary for Nutanix infrastructure, it is not a network prerequisite specifically for deploying an Era instance.
Option D: An SMTP server and details are typically used for sending notifications, but they are not a network prerequisite for deploying an Era instance. They are more related to the operational aspect post-deployment.
Question #14
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)
- A . Era does not require native Oracle Utility OpatchAuto to create the patch profile,
- B . Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario,
- C . Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails.
- D . Era Oracle fleet patching can be rolled back if issues ere encountered after successful patching.
Correct Answer: B, C
B, C
Explanation:
Nutanix Era provides a unified database operating model that delivers simplicity, performance, availability, and security across private and public clouds1. It standardizes your Oracle database ecosystem by mass patching the databases with one-click simplicity2. This includes the following features:
Automated Patching: Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario1. This allows for the standardization of your Oracle database ecosystem by mass patching the databases with one-click simplicity2.
Automatic Rollback: Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails1. This ensures that your databases remain secure and functional even if an issue arises during the patching process1.
B, C
Explanation:
Nutanix Era provides a unified database operating model that delivers simplicity, performance, availability, and security across private and public clouds1. It standardizes your Oracle database ecosystem by mass patching the databases with one-click simplicity2. This includes the following features:
Automated Patching: Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario1. This allows for the standardization of your Oracle database ecosystem by mass patching the databases with one-click simplicity2.
Automatic Rollback: Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails1. This ensures that your databases remain secure and functional even if an issue arises during the patching process1.
Question #15
An administrator has received a request to clone a source production database to an existing development server.
Which two actions must be taken to complete this task?
- A . The development server must be registered by Era in order to receive the clone.
- B . The development server must be registered by Era and authorized to host clones from the Time Machine.
- C . The development server must be authorized for the database Time Machine.
- D . The development server must have the IP and credentials provided during cloning.
Correct Answer: A D
A D
Explanation:
According to the Nutanix Database Automation (NCP-DB) Learning documents12, to clone a source production database to an existing development server, the following actions must be taken:
A) The development server must be registered by Era in order to receive the clone1. This is because Nutanix Era is a database management tool that manages the lifecycle of databases and their copies. Registering the development server with Era allows it to manage the database on that server.
D) The development server must have the IP and credentials provided during cloning2. This is necessary for Era to access the development server and perform the cloning operation. The IP address and credentials are used to establish a connection to the development server. Without these details, Era would not be able to access the server and perform the cloning operation.
A D
Explanation:
According to the Nutanix Database Automation (NCP-DB) Learning documents12, to clone a source production database to an existing development server, the following actions must be taken:
A) The development server must be registered by Era in order to receive the clone1. This is because Nutanix Era is a database management tool that manages the lifecycle of databases and their copies. Registering the development server with Era allows it to manage the database on that server.
D) The development server must have the IP and credentials provided during cloning2. This is necessary for Era to access the development server and perform the cloning operation. The IP address and credentials are used to establish a connection to the development server. Without these details, Era would not be able to access the server and perform the cloning operation.
Question #16
What does an NDB compute profile contain?
- A . vCPUs, cores per vCPU, and the amount of memory for the database server VM.
- B . Windows domain name (FQDN), domain user, and password.
- C . VLAN that the new database server VM will use.
- D . An image of the database and operating system generated from the registered database server VM.
Correct Answer: A
A
Explanation:
An NDB compute profile defines the CPU and memory resources for the database server VMs that are provisioned using NDB. It does not include any information about the network, domain, or software of the database server VMs. Those are specified in separate profiles, such as network profile, domain profile, and software profile.
Reference: Nutanix Support & Insights, section “NDB Compute”
A
Explanation:
An NDB compute profile defines the CPU and memory resources for the database server VMs that are provisioned using NDB. It does not include any information about the network, domain, or software of the database server VMs. Those are specified in separate profiles, such as network profile, domain profile, and software profile.
Reference: Nutanix Support & Insights, section “NDB Compute”
Question #17
An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?
- A . Create a new Software Profile with PostgreSQL 13.8.
- B . Create a maintenance window and add this PostgreSQL server 13.8 to the queue.
- C . Create a new Database Parameters profile for PostgreSQL server 13.8.
- D . Create a Software Profile Version with PostgreSQL 13.8.
Correct Answer: D
D
Explanation:
NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Section 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) Certification Details, Objective 4.1: Perform Database Patching
Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) User Guide, Section 4.4: Patch PostgreSQL Database Software
D
Explanation:
NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Section 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) Certification Details, Objective 4.1: Perform Database Patching
Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) User Guide, Section 4.4: Patch PostgreSQL Database Software
Question #17
An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?
- A . Create a new Software Profile with PostgreSQL 13.8.
- B . Create a maintenance window and add this PostgreSQL server 13.8 to the queue.
- C . Create a new Database Parameters profile for PostgreSQL server 13.8.
- D . Create a Software Profile Version with PostgreSQL 13.8.
Correct Answer: D
D
Explanation:
NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Section 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) Certification Details, Objective 4.1: Perform Database Patching
Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) User Guide, Section 4.4: Patch PostgreSQL Database Software
D
Explanation:
NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Section 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) Certification Details, Objective 4.1: Perform Database Patching
Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) User Guide, Section 4.4: Patch PostgreSQL Database Software
Question #19
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)
- A . Memory
- B . Compute
- C . Network
- D . Storage
Correct Answer: B, D
B, D
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 profile1. 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 performance23.
B, D
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 profile1. 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 performance23.
Question #20
A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes.
The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?
- A . Restore the 10:42pm snapshot.
- B . Restore using point in time till 10:41pm.
- C . Restore using point in time till 10:42pm.
- D . Restore the 10:30pm snapshot.
Correct Answer: C
C
Explanation:
The optimal path to restore the table back with minimum data loss is to use the point in time restore feature of NDB, which allows the administrator to restore the database to a specific point in time based on the available snapshots and logs1. By restoring using point in time till 10:42pm, the administrator can recover the table just before it was dropped by the user, and minimize the data loss to the least possible amount1. The other options are not optimal, as they either involve restoring an older snapshot, which may result in more data loss, or restoring a non-existent snapshot, which is not possible.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 6: Database Recovery, Lesson 6.2: Point in Time Restore, slide 5
C
Explanation:
The optimal path to restore the table back with minimum data loss is to use the point in time restore feature of NDB, which allows the administrator to restore the database to a specific point in time based on the available snapshots and logs1. By restoring using point in time till 10:42pm, the administrator can recover the table just before it was dropped by the user, and minimize the data loss to the least possible amount1. The other options are not optimal, as they either involve restoring an older snapshot, which may result in more data loss, or restoring a non-existent snapshot, which is not possible.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 6: Database Recovery, Lesson 6.2: Point in Time Restore, slide 5