NCP-DB Exam Results

To apply patches to Microsoft SQL Server databases in an NDB environment, the administrator should follow a structured process:

Create a new software profile version: Download the latest cumulative update (CU) or patch from Microsoft and use it to create a new version of the existing SQL Server Software Profile in NDB. This ensures the patch is integrated into NDB’s management framework.

Publish the updated software profile: Promote the new version to "Published" status, making it available for use across the environment.

Apply the update: Navigate to the "Database VM Menu" for each database server, select the updated software profile, and apply the patch. This automates the patching process while maintaining database consistency and allowing rollback if needed.

Other options are incorrect or incomplete:

A. Create a Maintenance window schedule and associate the SQL server with that maintenance window in the Database VM Menu: Maintenance windows manage downtime, not patch application for databases.

B. Apply the patch to the database VM then create a new software profile using that updated VM as the source: This manual approach bypasses NDB’s structured patching and lacks version control.

C. Apply the patch to the database VM, then create a new software profile version using that updated database VM as the source, publish the updated software profile then apply that patch under the database VM Menu for each database server: This is overly complex and risky, as manually patching a VM first can lead to inconsistencies.

Thus, the verified answer is D, aligning with NDB’s best practices for database patching.

Official Nutanix Database Automation References

Nutanix Database Management & Automation (NDMA) course, Module 6: Maintenance and Patching, Lesson 6.2: Patching SQL Server Databases.

Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Knowledge Objectives, Section 6: Optimize NDB Solutions, Objective 6.3: Manage Maintenance Plans (applicable to v7.5).

Nutanix NDB Administration Guide: "Patching Microsoft SQL Server" section.

NDB’s one-click patching workflow tracks patch actions and the corresponding database-server state in the NDB control plane. If an administrator patches the operating system manually outside NDB, those changes bypass the managed workflow, so NDB metadata is not updated. The VM is not automatically rolled back, and NDB does not automatically refresh it from a Software Profile. Instead, the difference between the server’s actual configuration and NDB’s recorded state can affect later lifecycle operations and produce unexpected behavior. Nutanix explicitly warns administrators to avoid manual patching outside NDB for this reason and states that the metadata will not update. Therefore, option D is correct. The candidate file’s supplied answer C states the opposite of the official One-Click Patching guidance and has been corrected. Nutanix One-Click Patching documentation

According to the Nutanix Database Automation (NCP-DB) learning documents, to create a network profile in Era, the network must be added to Era1. This is because Era needs to have control over the network in order to manage the databases effectively1. Once the network is added to Era, it can be used for various operations such as provisioning new databases, managing existing databases, and more1.

In Nutanix Database Automation (NCP-DB), when an administrator logs into Era and sees a message “Update Available” on the Status of the Software Profile Version, it indicates that a newer version of the software profile is available1. The administrator should manually update the software profile to the latest version12. This process ensures that the database VM is running the most recent and compatible version of the software12.