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 #21
Where would an administrator find the total space being used by all Era clones for a specific database?
- A . Under the Cloning widget on the Databases > Clones database summary page.
- B . Under the Capacity widget on the Database Server VMS > List database summary page.
- C . On the Era Dashboard Database Summary Table under Clones.
- D . On the Database > Overview dashboard.
Correct Answer: A
A
Explanation:
Nutanix Era leverages the Nutanix time-efficient snapshots to create the clones1. These database clones are highly space-efficient, consuming near-zero bytes by having only the further writes constituting to its size1. Therefore, an administrator would find the total space being used by all Era clones for a specific database under the Cloning widget on the Databases > Clones database summary page. The other options do not specifically provide information about the total space used by all Era clones for a specific database. Therefore, the correct answer is A. Under the Cloning widget on the Databases > Clones database summary page.
A
Explanation:
Nutanix Era leverages the Nutanix time-efficient snapshots to create the clones1. These database clones are highly space-efficient, consuming near-zero bytes by having only the further writes constituting to its size1. Therefore, an administrator would find the total space being used by all Era clones for a specific database under the Cloning widget on the Databases > Clones database summary page. The other options do not specifically provide information about the total space used by all Era clones for a specific database. Therefore, the correct answer is A. Under the Cloning widget on the Databases > Clones database summary page.
Question #22
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 Administrator
- B . Super Administrator
- C . Database Infrastructure Administrator
- D . Infrastructure Administrator
Correct Answer: D
D
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.
Reference: Nutanix Support & Insights, section “NDB Roles and Permissions”
D
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.
Reference: Nutanix Support & Insights, section “NDB Roles and Permissions”
Question #23
Within the NDB GUI, an administrator needs to set the shortest schedule interval possible for a database log catch up.
Which value, in minutes, will satisfy this requirement?
- A . 5
- B . 10
- C . 15
- D . 30
Correct Answer: C
C
Explanation:
The NDB GUI allows an administrator to set the schedule interval for a database log catch up, which is the process of collecting transaction logs periodically from the source databases and storing them in the time machine. The shortest possible value for this interval is 15 minutes, as per the NDB documentation1. This means that the NDB time machine will capture the database logs every 15 minutes and use them for backup, restore, clone, and refresh operations.
Reference: Nutanix Database Management & Automation (NDMA), page 29; Nutanix Support & Insights, section “Log Catch-up”
C
Explanation:
The NDB GUI allows an administrator to set the schedule interval for a database log catch up, which is the process of collecting transaction logs periodically from the source databases and storing them in the time machine. The shortest possible value for this interval is 15 minutes, as per the NDB documentation1. This means that the NDB time machine will capture the database logs every 15 minutes and use them for backup, restore, clone, and refresh operations.
Reference: Nutanix Database Management & Automation (NDMA), page 29; Nutanix Support & Insights, section “Log Catch-up”
Question #24
An administrator needs to protect a database with a Point In Time Recovery (PITR) SLA that provides a minimum of seven days of log recovery.
What is the minimum Default SLA that meets this requirement?
- A . DEFAULT_008 GOLD SLA
- B . DEFAULT_008 BRONZE SLA
- C . DEFAULT_008 SILVER SLA
- D . DEFAULT_008 BRASS SLA
Correct Answer: C
C
Explanation:
Nutanix Era (NDB) utilizes DEFAULT_008 SLAs with varying frequencies for snapshots and log backups to achieve different recovery point objectives (RPOs). Here’s how they compare: DEFAULT_008 GOLD SLA: Typically has frequent log backups (e.g., every 15 minutes) and snapshots every few hours. This is designed for critical databases with very low RPOs.
DEFAULT_008 SILVER SLA: Offers a balance between protection and resource usage. Log backups might occur every hour with snapshots less frequently. This SLA is often suitable for databases requiring a good RPO without being overly resource-intensive.
DEFAULT_008 BRONZE SLA: Has less frequent log backups (e.g., every few hours) and less frequent snapshots. This is used for databases with less stringent RPO requirements.
DEFAULT_008 BRASS SLA: This has infrequent log backups and is usually considered the least protective SLA with the longest potential RPO Reasoning:
Since the requirement is to have at least a 7-day log recovery period, any SLA with more frequent log backups than daily is excessive. The DEFAULT_008 SILVER SLA, with its hourly log backups, easily satisfies this requirement, offering the ability to restore to a point in time within the last hour of the past seven days.
Reference: Nutanix Era User Guide/SLA
Management: https://portal.nutanix.com/page/documents/details?targetId=Nutanix-NDB-User-Guide-v2_5:top-sla-management-c.html]
C
Explanation:
Nutanix Era (NDB) utilizes DEFAULT_008 SLAs with varying frequencies for snapshots and log backups to achieve different recovery point objectives (RPOs). Here’s how they compare: DEFAULT_008 GOLD SLA: Typically has frequent log backups (e.g., every 15 minutes) and snapshots every few hours. This is designed for critical databases with very low RPOs.
DEFAULT_008 SILVER SLA: Offers a balance between protection and resource usage. Log backups might occur every hour with snapshots less frequently. This SLA is often suitable for databases requiring a good RPO without being overly resource-intensive.
DEFAULT_008 BRONZE SLA: Has less frequent log backups (e.g., every few hours) and less frequent snapshots. This is used for databases with less stringent RPO requirements.
DEFAULT_008 BRASS SLA: This has infrequent log backups and is usually considered the least protective SLA with the longest potential RPO Reasoning:
Since the requirement is to have at least a 7-day log recovery period, any SLA with more frequent log backups than daily is excessive. The DEFAULT_008 SILVER SLA, with its hourly log backups, easily satisfies this requirement, offering the ability to restore to a point in time within the last hour of the past seven days.
Reference: Nutanix Era User Guide/SLA
Management: https://portal.nutanix.com/page/documents/details?targetId=Nutanix-NDB-User-Guide-v2_5:top-sla-management-c.html]
Question #25
An administrator needs to patch an Oracle Database Server VM and must ensure Grid home is allocated sufficient storage space.
At a minimum, how much space must be available for Grid home prior to completing this task?
- A . 5GB
- B . 10GB
- C . 15GB
- D . 20 GB
Correct Answer: B
B
Explanation:
When patching an Oracle Database Server VM, it’s important to ensure that there is sufficient storage space allocated for the Grid home. A minimum of 10GB space is required for this purpose to accommodate the patching process without storage constraints.
Reference: Nutanix Database Automation documentation, particularly in the sections discussing Oracle database server VM management and patching requirements.
B
Explanation:
When patching an Oracle Database Server VM, it’s important to ensure that there is sufficient storage space allocated for the Grid home. A minimum of 10GB space is required for this purpose to accommodate the patching process without storage constraints.
Reference: Nutanix Database Automation documentation, particularly in the sections discussing Oracle database server VM management and patching requirements.
Question #26
An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore time and minimize data loss.
What option should the administrator do to achieve this objective?
- A . Perform Restore Source Database by selecting Restore time just before the database crash.
- B . Perform Restore Source Database by selecting most recent and include Tail log Backup
- C . Perform Restore Source Database by selecting the available snapshot.
- D . Perform Restore Source Database by selecting the current time.
Correct Answer: B
B
Explanation:
Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup. In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup12. The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss. By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered12. This approach aligns with the Nutanix Era’s capabilities and best practices for database recovery12.
B
Explanation:
Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup. In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup12. The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss. By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered12. This approach aligns with the Nutanix Era’s capabilities and best practices for database recovery12.
Question #27
An administrator needs the ability to clone a source database to a point in time.
What is the lowest log frequency in minutes that can be configured in the Era IJI for log catchup operation?
- A . 30
- B . 60
- C . 5
- D . 15
Correct Answer: C
C
Explanation:
The log frequency in the Era IJI for log catchup operation can be configured to as low as 5 minutes. This allows the system to capture changes to the database at a high frequency, enabling more precise point-in-time recovery options. However, it’s important to note that a higher frequency of log catchup operations can lead to increased system load. Therefore, the optimal frequency may vary depending on the specific requirements and capabilities of your system12. Please refer to the Nutanix Database Automation (NCP-DB) Learning documents for more detailed information.
C
Explanation:
The log frequency in the Era IJI for log catchup operation can be configured to as low as 5 minutes. This allows the system to capture changes to the database at a high frequency, enabling more precise point-in-time recovery options. However, it’s important to note that a higher frequency of log catchup operations can lead to increased system load. Therefore, the optimal frequency may vary depending on the specific requirements and capabilities of your system12. Please refer to the Nutanix Database Automation (NCP-DB) Learning documents for more detailed information.
Question #28
What is used to temporarily store the transaction logs of the source database before they are copied to the log?
- A . Database Agent
- B . NDB Drive
- C . Time Machine
- D . NDB Profiles
Correct Answer: A
A
Explanation:
The Database Agent is used to temporarily store the transaction logs of the source database before they are copied to the log. This is a critical component for ensuring data consistency and recovery in database operations.
Reference: Nutanix Database Automation documentation, focusing on database agents and their roles in transaction log management.
A
Explanation:
The Database Agent is used to temporarily store the transaction logs of the source database before they are copied to the log. This is a critical component for ensuring data consistency and recovery in database operations.
Reference: Nutanix Database Automation documentation, focusing on database agents and their roles in transaction log management.
Question #29
What is required to create an NDB Software Profile Version for PostgreSQL?
- A . Database server VM registered with NDB
- B . Patch file for the installed databases
- C . Installer package for database software
- D . Preconfigured OS image from Prism Element
Correct Answer: C
C
Explanation:
To create an NDB Software Profile Version for PostgreSQL, it is required to have an installer package for the database software. This package forms the basis of the software profile, enabling the deployment and management of PostgreSQL instances.
Reference: Nutanix Database Automation documentation, particularly in the area of software profile creation and management for PostgreSQL.
C
Explanation:
To create an NDB Software Profile Version for PostgreSQL, it is required to have an installer package for the database software. This package forms the basis of the software profile, enabling the deployment and management of PostgreSQL instances.
Reference: Nutanix Database Automation documentation, particularly in the area of software profile creation and management for PostgreSQL.
Question #30
An administrator would like to provide a group of users the ability to add a new VLAN or IP Pool in Era.
What minimum role should the administrator assign to this group?
- A . Super Admin
- B . Database Admin
- C . Infrastructure administrator
- D . Database Infrastructure Admin
Correct Answer: C
C
Explanation:
In Nutanix Era, the ability to add a new VLAN or IP Pool is typically associated with the role of an Infrastructure Administrator12. This role has the necessary permissions to manage network configurations, including the creation of VLANs and IP Pools12. It’s important to note that the exact permissions may vary depending on the specific configuration and policies of your organization12.
C
Explanation:
In Nutanix Era, the ability to add a new VLAN or IP Pool is typically associated with the role of an Infrastructure Administrator12. This role has the necessary permissions to manage network configurations, including the creation of VLANs and IP Pools12. It’s important to note that the exact permissions may vary depending on the specific configuration and policies of your organization12.