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 #1
Which statement describes a user in Era with the Database Infrastructure Admin role?
- A . The user is able to manage software profiles, Network Profiles. database Instance parameter profiles and time machine SLA
- B . The user is able to manage software profiles, Network Profiles. database parameter profiles end Time Machine SLAs,
- C . The user is able to manage database profiles, Network Profiles, database Instance parameter profiles and time machine SLA
- D . The user is able to manage software profiles, database parameter profiles and SLAs
Correct Answer: B
B
Explanation:
The size of a database Time Machine in Nutanix Era is defined by the size of all snapshots and/or transaction logs maintained by Era1. The Time Machine leverages Nutanix’s efficient snapshot technology to capture the state of the database at different points in time1. These snapshots, along with transaction logs that record changes between snapshots, constitute the data maintained by the Time Machine1. Therefore, the size of the Time Machine is determined by the total size of these snapshots and transaction logs1.
B
Explanation:
The size of a database Time Machine in Nutanix Era is defined by the size of all snapshots and/or transaction logs maintained by Era1. The Time Machine leverages Nutanix’s efficient snapshot technology to capture the state of the database at different points in time1. These snapshots, along with transaction logs that record changes between snapshots, constitute the data maintained by the Time Machine1. Therefore, the size of the Time Machine is determined by the total size of these snapshots and transaction logs1.
Question #2
Mark the original patch profile as hidden.
Correct Answer: C D
Explanation:
To create a software profile version for a newly-released Oracle ISc patch, an administrator should follow these steps:
Download the required patch from MyOracle Support1. This is because Oracle patches are typically available from MyOracle Support, not Microsoft Support.
Apply the patch to the Oracle Home/Grid Home on a cloned VM of the gold image using OPatchAuto1. OPatchAuto is a utility provided by Oracle that automates the process of applying patches to a database.
Ensure success of patch application1. It’s important to verify that the patch has been applied successfully to avoid any issues down the line.
Create a new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era GUI1. This step is necessary to ensure that the new patch is included in the software profile.
Mark the original patch profile as hidden1. This step is optional but can be useful for keeping the software profile clean and organized.
Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.
Explanation:
To create a software profile version for a newly-released Oracle ISc patch, an administrator should follow these steps:
Download the required patch from MyOracle Support1. This is because Oracle patches are typically available from MyOracle Support, not Microsoft Support.
Apply the patch to the Oracle Home/Grid Home on a cloned VM of the gold image using OPatchAuto1. OPatchAuto is a utility provided by Oracle that automates the process of applying patches to a database.
Ensure success of patch application1. It’s important to verify that the patch has been applied successfully to avoid any issues down the line.
Create a new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era GUI1. This step is necessary to ensure that the new patch is included in the software profile.
Mark the original patch profile as hidden1. This step is optional but can be useful for keeping the software profile clean and organized.
Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.
Question #2
Mark the original patch profile as hidden.
Correct Answer: C D
Explanation:
To create a software profile version for a newly-released Oracle ISc patch, an administrator should follow these steps:
Download the required patch from MyOracle Support1. This is because Oracle patches are typically available from MyOracle Support, not Microsoft Support.
Apply the patch to the Oracle Home/Grid Home on a cloned VM of the gold image using OPatchAuto1. OPatchAuto is a utility provided by Oracle that automates the process of applying patches to a database.
Ensure success of patch application1. It’s important to verify that the patch has been applied successfully to avoid any issues down the line.
Create a new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era GUI1. This step is necessary to ensure that the new patch is included in the software profile.
Mark the original patch profile as hidden1. This step is optional but can be useful for keeping the software profile clean and organized.
Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.
Explanation:
To create a software profile version for a newly-released Oracle ISc patch, an administrator should follow these steps:
Download the required patch from MyOracle Support1. This is because Oracle patches are typically available from MyOracle Support, not Microsoft Support.
Apply the patch to the Oracle Home/Grid Home on a cloned VM of the gold image using OPatchAuto1. OPatchAuto is a utility provided by Oracle that automates the process of applying patches to a database.
Ensure success of patch application1. It’s important to verify that the patch has been applied successfully to avoid any issues down the line.
Create a new software profile version from the original software profile using the cloned VM where OPatchAuto was run successfully using Era GUI1. This step is necessary to ensure that the new patch is included in the software profile.
Mark the original patch profile as hidden1. This step is optional but can be useful for keeping the software profile clean and organized.
Please note that these answers are based on the information available as of my last update in 2021 and may need to be verified with the most recent Nutanix Database Automation (NCP-DB) documentation or resources.
Question #4
A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator’s options to complete the request?
- A . Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
Resolution: The Time Machine must be paused, then the database re-registered with a new Time Machine and a new clone created. - B . Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
Resolution: To complete the request the database must be re-registered in NDB, create a new Time Machine and create a new clone. - C . Cause: The Time Machine enters a Frozen state when the database is de-registered without removing the Time Machine.
Resolution: To complete the request the database must be re-registered in NDB, this thaws the Time Machine and it resumes operation so the clone can be refreshed. - D . Cause: The Time Machine enters a Frozen state after too many snapshot or log catchup failures.
Resolution: Remediate the snapshot or log catchup failures, this thaws the Time Machine, allowing normal operations to continue and the request can be completed.
Correct Answer: C
C
Explanation:
A Time Machine is a core construct of the copy data management service in NDB that captures and manages the data of a database to deliver a recovery point objective (RPO) SLA. A Time Machine can enter a Frozen state for various reasons, such as database de-registration, snapshot or log catchup failures, or manual intervention. When a Time Machine is in a Frozen state, it stops taking new snapshots and log backups, and cannot perform any clone, refresh, or restore operations. To resume the normal operation of a Time Machine, it must be thawed by resolving the root cause of the freeze. One of the common causes of a Time Machine freeze is when the database is de-registered from NDB without removing the Time Machine. This can happen when the administrator wants to move the database to a different NDB instance or cluster, or when the database is accidentally de-registered. In this case, the Time Machine becomes orphaned and frozen, and cannot be used for any operations. To complete the request to refresh a database clone from a new manual snapshot, the administrator must first re-register the database in NDB using the same database name and ID as before. This will automatically thaw the Time Machine and resume its operation. The administrator can then create a new manual snapshot from the Time Machine and use it to refresh the database clone. The other options are not correct, as they either require unnecessary steps or do not address the root cause of the freeze.
Reference: Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Section 5 – Protect NDB-managed Databases Using Time Machine, Objective 5.1: Create, delete, and modify SLA retention policies
Nutanix Database Management & Automation (NDMA) Course, Module 4: Nutanix Database Service
(NDB) Data Protection, Lesson 4.1: Data Protection Overview, Topic: Time Machine Concepts
Nutanix Support & Insights, TN-2101: Nutanix Database Service Time Machine Under the Hood,
Section: Time Machine States and Transitions
C
Explanation:
A Time Machine is a core construct of the copy data management service in NDB that captures and manages the data of a database to deliver a recovery point objective (RPO) SLA. A Time Machine can enter a Frozen state for various reasons, such as database de-registration, snapshot or log catchup failures, or manual intervention. When a Time Machine is in a Frozen state, it stops taking new snapshots and log backups, and cannot perform any clone, refresh, or restore operations. To resume the normal operation of a Time Machine, it must be thawed by resolving the root cause of the freeze. One of the common causes of a Time Machine freeze is when the database is de-registered from NDB without removing the Time Machine. This can happen when the administrator wants to move the database to a different NDB instance or cluster, or when the database is accidentally de-registered. In this case, the Time Machine becomes orphaned and frozen, and cannot be used for any operations. To complete the request to refresh a database clone from a new manual snapshot, the administrator must first re-register the database in NDB using the same database name and ID as before. This will automatically thaw the Time Machine and resume its operation. The administrator can then create a new manual snapshot from the Time Machine and use it to refresh the database clone. The other options are not correct, as they either require unnecessary steps or do not address the root cause of the freeze.
Reference: Nutanix Certified Professional – Database Automation (NCP-DB) v6.5, Section 5 – Protect NDB-managed Databases Using Time Machine, Objective 5.1: Create, delete, and modify SLA retention policies
Nutanix Database Management & Automation (NDMA) Course, Module 4: Nutanix Database Service
(NDB) Data Protection, Lesson 4.1: Data Protection Overview, Topic: Time Machine Concepts
Nutanix Support & Insights, TN-2101: Nutanix Database Service Time Machine Under the Hood,
Section: Time Machine States and Transitions
Question #5
What is the most efficient way to get information on REST APIs for a task in Era?
- A . Log into Ere VM end run to list ell the REST APIs.
- B . Navigate to Swagger REST in Era GI-II.
- C . Navigate to and look for the desired
- D . use API equivalent button in a workflow.
Correct Answer: D
D
Explanation:
. This is because it allows the database to be refreshed at the exact time specified (9:30 PM) with the most recent data. The other options either perform the snapshot before the desired time or do not specify when the snapshot would occur. Please note that the exact answer might depend on the specific database system and its capabilities. Always refer to the database’s documentation for the most accurate information.
D
Explanation:
. This is because it allows the database to be refreshed at the exact time specified (9:30 PM) with the most recent data. The other options either perform the snapshot before the desired time or do not specify when the snapshot would occur. Please note that the exact answer might depend on the specific database system and its capabilities. Always refer to the database’s documentation for the most accurate information.
Question #6
A developer requests a new development database environment. The Era administrator identifies that there are insufficient resources on the development cluster.
Which two profiles should the administrator adjust to get the copy to fit within the resources available? (Choose two.)
- A . Network
- B . Sofware
- C . Compute
- D . Database Parameters
Correct Answer: C, D
C, D
Explanation:
In the context of Nutanix Database Automation (NCP-DB), when there are insufficient resources on a development cluster, the administrator can adjust the Compute and Database Parameters profiles to make the copy fit within the available resources1. The Compute profile includes settings related to CPU and memory resources, which can be adjusted to fit within the available resources. The Database Parameters profile includes settings that control the behavior and resource usage of the database, which can also be adjusted to optimize resource usage1.
C, D
Explanation:
In the context of Nutanix Database Automation (NCP-DB), when there are insufficient resources on a development cluster, the administrator can adjust the Compute and Database Parameters profiles to make the copy fit within the available resources1. The Compute profile includes settings related to CPU and memory resources, which can be adjusted to fit within the available resources. The Database Parameters profile includes settings that control the behavior and resource usage of the database, which can also be adjusted to optimize resource usage1.
Question #7
What is the purpose of Data Access Management policies in NDB Multi-Cluster?
- A . To register multiple Nutanix clusters in NDB
- B . To perform snapshot operations on a single Nutanix cluster
- C . To manage time machine data availability across all registered Nutanix clusters in NDB
- D . To remove data accessibility of a time machine across all registered Nutanix clusters in NDB
Correct Answer: C
C
Explanation:
Data Access Management (DAM) policies are a feature of NDB Multi-Cluster that allows you to control the access and availability of time machine data across different Nutanix clusters. You can use DAM policies to specify which clusters can access the time machine data of a source database, and which clusters can replicate the time machine data for backup or disaster recovery purposes. DAM policies help you to optimize the storage and network resources, as well as ensure the security and compliance of your database workloads. The purpose of DAM policies is not to register multiple Nutanix clusters in NDB, as this is done by using the Add Cluster option in the NDB settings page. The purpose of DAM policies is also not to perform snapshot operations on a single Nutanix cluster, as this is done by using the Time Machine feature in the NDB dashboard. The purpose of DAM policies is also not to remove data accessibility of a time machine across all registered Nutanix clusters in NDB, as this is done by using the Delete option in the Time Machine page.
Reference: Nutanix Database Management & Automation Training Course, Module 6: Managing NDB Multi-Cluster, Lesson 2: Data Access Management Policies, Slide 3: Data Access Management Policies
Nutanix Certified Professional – Database Automation (NCP-DB) 5 Exam, Section 6: Administer an NDB Environment, Objective 6.5: Apply procedural concepts to create Data Access Management (DAM) policies
C
Explanation:
Data Access Management (DAM) policies are a feature of NDB Multi-Cluster that allows you to control the access and availability of time machine data across different Nutanix clusters. You can use DAM policies to specify which clusters can access the time machine data of a source database, and which clusters can replicate the time machine data for backup or disaster recovery purposes. DAM policies help you to optimize the storage and network resources, as well as ensure the security and compliance of your database workloads. The purpose of DAM policies is not to register multiple Nutanix clusters in NDB, as this is done by using the Add Cluster option in the NDB settings page. The purpose of DAM policies is also not to perform snapshot operations on a single Nutanix cluster, as this is done by using the Time Machine feature in the NDB dashboard. The purpose of DAM policies is also not to remove data accessibility of a time machine across all registered Nutanix clusters in NDB, as this is done by using the Delete option in the Time Machine page.
Reference: Nutanix Database Management & Automation Training Course, Module 6: Managing NDB Multi-Cluster, Lesson 2: Data Access Management Policies, Slide 3: Data Access Management Policies
Nutanix Certified Professional – Database Automation (NCP-DB) 5 Exam, Section 6: Administer an NDB Environment, Objective 6.5: Apply procedural concepts to create Data Access Management (DAM) policies
Question #8
An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day’s state.
Which two restore options could be used? (Choose two.)
- A . Most Recent Time Available
- B . Snapshot
- C . Tail Logs Backup
- D . Point in Time
Correct Answer: B, D
B, D
Explanation:
The correct answer is B and D because they are the two restore options that can be used to restore an Oracle database to the prior day’s state using Nutanix Era. A snapshot is a point-in-time copy of a database that is stored in the Era Time Machine, which is a distributed file system that collects logs and snapshots from databases. A point in time is a specific moment in time within the retention period of the SLA policy that is applied to the database. By using either of these options, the administrator can select the snapshot or the point in time that corresponds to the prior day’s state and restore the database from it. The other options are not correct because they are not restore options that are available in Nutanix Era. Option A is not correct because Most Recent Time Available is not a restore option, but a clone option that creates a clone of the database from the most recent snapshot or log backup. Option C is not correct because Tail Logs Backup is not a restore option, but a backup option that captures the transaction logs of the database that have not been backed up by the SLA policy.
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 Database Services: Database modernization with Era – Now available]
B, D
Explanation:
The correct answer is B and D because they are the two restore options that can be used to restore an Oracle database to the prior day’s state using Nutanix Era. A snapshot is a point-in-time copy of a database that is stored in the Era Time Machine, which is a distributed file system that collects logs and snapshots from databases. A point in time is a specific moment in time within the retention period of the SLA policy that is applied to the database. By using either of these options, the administrator can select the snapshot or the point in time that corresponds to the prior day’s state and restore the database from it. The other options are not correct because they are not restore options that are available in Nutanix Era. Option A is not correct because Most Recent Time Available is not a restore option, but a clone option that creates a clone of the database from the most recent snapshot or log backup. Option C is not correct because Tail Logs Backup is not a restore option, but a backup option that captures the transaction logs of the database that have not been backed up by the SLA policy.
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 Database Services: Database modernization with Era – Now available]
Question #9
An administrator needs to take multiple snapshots per day and retain them for one week.
How should the administrator define and schedule the SLA?
- A . • Daily snapshot retention: 7 days
• Daily snapshot at: 2 - B . • Weekly snapshot retention: 1 week
• Daily Snapshot at: 2 - C . • Weekly snapshot retention: 1 week
• Snapshots per Day: 2 - D . • Daily snapshot retention: 7 days
• Snapshots per Day: 2
Correct Answer: D
D
Explanation:
The correct answer is D because it matches the requirement of taking multiple snapshots per day and retaining them for one week. Option A is incorrect because it only takes one snapshot per day, which is not enough for the administrator’s need. Option B is incorrect because it only retains the snapshots for one week, which means the older snapshots will be deleted after seven days. Option C is incorrect because it only takes two snapshots per week, which is not frequent enough for the administrator’s need.
Reference: The following sources provide more information about the SLA retention policies and how to create and modify them in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases
Using Time Machine, Lesson 4.1: Creating and Modifying SLA Retention Policies
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.1: Creating and Modifying SLA Retention Policies
D
Explanation:
The correct answer is D because it matches the requirement of taking multiple snapshots per day and retaining them for one week. Option A is incorrect because it only takes one snapshot per day, which is not enough for the administrator’s need. Option B is incorrect because it only retains the snapshots for one week, which means the older snapshots will be deleted after seven days. Option C is incorrect because it only takes two snapshots per week, which is not frequent enough for the administrator’s need.
Reference: The following sources provide more information about the SLA retention policies and how to create and modify them in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases
Using Time Machine, Lesson 4.1: Creating and Modifying SLA Retention Policies
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.1: Creating and Modifying SLA Retention Policies
Question #10
What are two of the required steps to provision a new network in Clusters and extend it to Era? (Choose two.)
- A . Add a new.’ subnet to the correct VPC.
- B . Add the new subnet end VLAN in Network Configuration in PE.
- C . Add the new VLAN in Ere Networks.
- D . Add the new network in Era Multi-Clu5ter Management
Correct Answer: B, C
B, C
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to provision a new network in Clusters and extend it to Era, you need to:
B) Add the new subnet and VLAN in Network Configuration in PE1.
C. Add the new VLAN in Era Networks1.
These steps ensure that the new network is properly configured in both the Nutanix environment and Era, allowing for seamless communication and operation. Please refer to the official Nutanix documentation and training materials for more detailed information1.
B, C
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to provision a new network in Clusters and extend it to Era, you need to:
B) Add the new subnet and VLAN in Network Configuration in PE1.
C. Add the new VLAN in Era Networks1.
These steps ensure that the new network is properly configured in both the Nutanix environment and Era, allowing for seamless communication and operation. Please refer to the official Nutanix documentation and training materials for more detailed information1.