Nutanix NCP-DB-6.5 Practice Exams
Last updated on Oct 08,2026- Exam Code: NCP-DB-6.5
- Exam Name: Nutanix Certified Professional - Database Automation (NCP-DB) v6.5
- Certification Provider: Nutanix
- Latest update: Oct 08,2026
Question #131
An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.
Which restore method is supported?
- A . Disk-based restore via NDB GUI
- B . Disk-based restore via NDB CLI
- C . Copy-based restore via NDB GUI
- D . Copy-based restore via NDB CLI
Correct Answer: C
C
Explanation:
For restoring a database provisioned on Storage Spaces, especially when virtual disks are shared among multiple databases, the supported method is a copy-based restore via the NDB GUI. This method allows for a precise and controlled restoration process suitable for shared storage environments.
Reference: Nutanix Database Automation documentation, specifically in the section on database restoration methods and storage spaces.
C
Explanation:
For restoring a database provisioned on Storage Spaces, especially when virtual disks are shared among multiple databases, the supported method is a copy-based restore via the NDB GUI. This method allows for a precise and controlled restoration process suitable for shared storage environments.
Reference: Nutanix Database Automation documentation, specifically in the section on database restoration methods and storage spaces.
Question #132
When performing a SQL Server Restore Source Database operation, what is a valid reason an
administrator would choose the Restore
Location as New Location?
- A . The log files are needed to petform the point in time restore.
- B . The administrator wants to restore to a new location and have Era apply Nutanix best practices.
- C . The administrator wants to keep the original schema in place.
- D . The database files are on a disk with other database files and the administrator wants to get the database restored as quickly as possible.
Correct Answer: B
B
Explanation:
When performing a SQL Server Restore Source Database operation in Nutanix Database Automation (NCP-DB), an administrator might choose the Restore Location as New Location if they want to restore to a new location and have Era apply Nutanix best practices1. This is because Nutanix Era automates and simplifies database management, allowing the administrator to manage databases at scale, and it applies Nutanix best practices during the restore process1. This ensures optimal performance and reliability of the restored database1.
B
Explanation:
When performing a SQL Server Restore Source Database operation in Nutanix Database Automation (NCP-DB), an administrator might choose the Restore Location as New Location if they want to restore to a new location and have Era apply Nutanix best practices1. This is because Nutanix Era automates and simplifies database management, allowing the administrator to manage databases at scale, and it applies Nutanix best practices during the restore process1. This ensures optimal performance and reliability of the restored database1.
Question #133
Which response shows two ways to upgrade an NDB Server?
- A . Out-of-Place Upgrade and In-place Upgrade
- B . One-click Upgrade and In-place Upgrade Auto
- C . Upgrade and Manual Upgrade
- D . One-click Upgrade and Offline Upgrade
Correct Answer: D
D
Explanation:
There are two ways to upgrade an NDB Server: one-click upgrade and offline upgrade. One-click upgrade is the recommended method, as it automatically downloads and installs the latest NDB software version from the Nutanix portal. Offline upgrade is an alternative method, which requires you to manually download the NDB software bundle and upload it to the NDB Server VM. Both methods require you to have a valid Nutanix account and an internet connection.
Reference: Nutanix Certified Professional – Database Automation (NCP-DB), Section 6 – Administer an NDB Environment
Database (NCP-DB) Exam Blueprint Guide – Nutanix, Page 10, Objective 6.2
Nutanix Database Management & Automation (NDMA) course, Module 6, Lesson 6.1 – NDB Software Upgrade
D
Explanation:
There are two ways to upgrade an NDB Server: one-click upgrade and offline upgrade. One-click upgrade is the recommended method, as it automatically downloads and installs the latest NDB software version from the Nutanix portal. Offline upgrade is an alternative method, which requires you to manually download the NDB software bundle and upload it to the NDB Server VM. Both methods require you to have a valid Nutanix account and an internet connection.
Reference: Nutanix Certified Professional – Database Automation (NCP-DB), Section 6 – Administer an NDB Environment
Database (NCP-DB) Exam Blueprint Guide – Nutanix, Page 10, Objective 6.2
Nutanix Database Management & Automation (NDMA) course, Module 6, Lesson 6.1 – NDB Software Upgrade
Question #134
How can Era be config90ured to send alert notifications to email recipients?
- A . From Administration select Era Service then go to Era service name and setup email notification,
- B . From Administration, select access control then add a user end setup email notification.
- C . From Administration, select Ere Service then go to configure notification widget and then click update to update SMTP server configuration
- D . From Administration select access control, select SMTP and then click update to update SMTP sewer configuration.
Correct Answer: C
C
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to configure Era to send alert notifications to email recipients, you need to go to the Administration section, select Era Service, then go to the configure notification widget. From there, you can update the SMTP server configuration1. This allows Era to use the SMTP server to send alert notifications to the specified email recipients1.
C
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to configure Era to send alert notifications to email recipients, you need to go to the Administration section, select Era Service, then go to the configure notification widget. From there, you can update the SMTP server configuration1. This allows Era to use the SMTP server to send alert notifications to the specified email recipients1.
Question #135
How is a software profile created?
- A . In the Ere IJI select Profiles Software, and then a template VM.
- B . In the Ere IJI select Profiles Software, and then a database engine, OS version, and database version,
- C . Create a software profile from a registered Database Server VM.
- D . Clone e software profile provided by Era and modify as needed.
Correct Answer: B
B
Explanation:
Nutanix Database Automation (NCP-DB) simplifies database provisioning using predefined profiles customized to your environment. Software profiles, which are templates of the OS and database engine, allow you to maintain consistent software versions1. You then use additional profiles to customize that deployment1.
B
Explanation:
Nutanix Database Automation (NCP-DB) simplifies database provisioning using predefined profiles customized to your environment. Software profiles, which are templates of the OS and database engine, allow you to maintain consistent software versions1. You then use additional profiles to customize that deployment1.
Question #136
An online retail application requires data to be synchronized between multiple SQL Server databases.
This provides clearer reporting from multiple databases at the Same time for consistency at the end of each business day.
What is the best way to fulfill this requirement?
- A . Have all the databases present in the same DBVM and register databases in Era.
- B . Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.
- C . Have all the databases present in the same DBVM and register databases in Era with One Database with One Time Machine.
- D . Have all the databases in the same Availability Group and register databases in Era.
Correct Answer: B
B
Explanation:
Nutanix Era enables you to clone your source databases and refresh the database clones by using snapshots or transaction logs1. For an online retail application that requires data to be synchronized between multiple SQL Server databases, having all the databases present in the same Database Virtual Machine (DBVM) and registering them in Era with Multiple Databases as a Group with one Time Machine would be the most efficient way to fulfill this requirement1. This approach allows for clearer reporting from multiple databases at the same time for consistency at the end of each business day1.
B
Explanation:
Nutanix Era enables you to clone your source databases and refresh the database clones by using snapshots or transaction logs1. For an online retail application that requires data to be synchronized between multiple SQL Server databases, having all the databases present in the same Database Virtual Machine (DBVM) and registering them in Era with Multiple Databases as a Group with one Time Machine would be the most efficient way to fulfill this requirement1. This approach allows for clearer reporting from multiple databases at the same time for consistency at the end of each business day1.
Question #137
Why are ports 3205 and 3260 important when working with Era?
- A . These ports facilitate SMB connections
- B . These ports facilitate iSCSI connections
- C . These ports facilitate NFS connections
- D . These ports facilitate CIFS connections
Correct Answer: B
B
Explanation:
Ports 3205 and 3260 are important when working with Era because they must be open on the Era server and all Controller VMs (CVMs) to facilitate iSCSI connections1. Specifically, port 3205 is used for iSCSI redirection2. Please be careful of routing iSCSI traffic, as it could impact performance2.
B
Explanation:
Ports 3205 and 3260 are important when working with Era because they must be open on the Era server and all Controller VMs (CVMs) to facilitate iSCSI connections1. Specifically, port 3205 is used for iSCSI redirection2. Please be careful of routing iSCSI traffic, as it could impact performance2.
Question #138
An administrator needs to migrate a large 1/0-intensive database that doesn’t support multi-disk layout.
How should the storage be provisioned with Era to support the database while optimizing performance?
- A . Volume Group
- B . Volume Group with Load Balancing
- C . Storage Spaces
- D . vDisk based provisioning
Correct Answer: A
A
Explanation:
In Nutanix Era, a Volume Group is the recommended storage provisioning method for a large I/O-intensive database that doesn’t support a multi-disk layout1. A Volume Group in Nutanix Era is a collection of disks that can be managed as a single entity, providing a way to aggregate the storage capacity of multiple disks into a larger storage unit1. This allows for better performance optimization as it enables the database to leverage the combined I/O capabilities of all the disks in the group1. It’s important to note that while other options like Load Balancing, Storage Spaces, and vDisk based provisioning can also be used in certain scenarios, a Volume Group is specifically designed for situations where a single, high-performance storage unit is required1.
A
Explanation:
In Nutanix Era, a Volume Group is the recommended storage provisioning method for a large I/O-intensive database that doesn’t support a multi-disk layout1. A Volume Group in Nutanix Era is a collection of disks that can be managed as a single entity, providing a way to aggregate the storage capacity of multiple disks into a larger storage unit1. This allows for better performance optimization as it enables the database to leverage the combined I/O capabilities of all the disks in the group1. It’s important to note that while other options like Load Balancing, Storage Spaces, and vDisk based provisioning can also be used in certain scenarios, a Volume Group is specifically designed for situations where a single, high-performance storage unit is required1.
Question #139
An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.
How should the administrator define the Frequency and retention on the SLA?
- A . • Continuous log retention (days): 7
• Daily snapshot retention (days): 5 - B . • Continuous log retention (days): 5
• Weekly snapshot retention (weeks): 1 - C . • Weekly snapshot retention (weeks): 1
• Continuous log retention (days): 7 - D . • Daily snapshot retention (days): 7
• Continuous log retention (days): 5
Correct Answer: D
D
Explanation:
The correct answer is D because it meets the requirements of maintaining five days of time-travel capability to any second and an additional seven days of discrete recovery at a daily interval. Continuous log retention allows the administrator to restore the database to any point in time within the specified number of days, while snapshot retention allows the administrator to restore the database to a specific point in time at a fixed interval. Therefore, by setting the daily snapshot retention to 7 days, the administrator can ensure that there is a discrete recovery point for each day of the week. By setting the continuous log retention to 5 days, the administrator can ensure that there is a time-travel capability to any second within the last five days. The other options do not meet the requirements because they either have less than five days of continuous log retention or less than seven days of snapshot retention.
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 Certified Professional – Database Automation (NCP-DB) datasheet
D
Explanation:
The correct answer is D because it meets the requirements of maintaining five days of time-travel capability to any second and an additional seven days of discrete recovery at a daily interval. Continuous log retention allows the administrator to restore the database to any point in time within the specified number of days, while snapshot retention allows the administrator to restore the database to a specific point in time at a fixed interval. Therefore, by setting the daily snapshot retention to 7 days, the administrator can ensure that there is a discrete recovery point for each day of the week. By setting the continuous log retention to 5 days, the administrator can ensure that there is a time-travel capability to any second within the last five days. The other options do not meet the requirements because they either have less than five days of continuous log retention or less than seven days of snapshot retention.
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 Certified Professional – Database Automation (NCP-DB) datasheet
Question #140
Create the clone from the Time Machine and define the post-clone option with the full pathname of the masking script.
D. From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.
Correct Answer: B
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 operation1. 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 VM2. 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 data2. 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 script1. 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 team1. 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.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 4: Database Cloning, Lesson 4.4: Pre-Post Commands, slide 5
2: Nutanix Database Automation (NCP-DB) course, Module 4: Database Cloning, Lesson 4.4: Pre-Post Commands, slide 7
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 operation1. 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 VM2. 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 data2. 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 script1. 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 team1. 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.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 4: Database Cloning, Lesson 4.4: Pre-Post Commands, slide 5
2: Nutanix Database Automation (NCP-DB) course, Module 4: Database Cloning, Lesson 4.4: Pre-Post Commands, slide 7