NCP-DB Exam Dumps - Nutanix Certified Professional (NCP) Questions and Answers

According to the Nutanix Database Automation (NCP-DB) course, a Software Profile is a template that defines the configuration of the database engine, such as the version, edition, features, and parameters1. It also specifies the disk layout for the database installation, such as the size, type, and mount point of each disk1. However, the System Page File disk is omitted from the Software Profile, as it is automatically created by the NDB service based on the memory size of the database server VM1. The other options are included in the Software Profile, as they are essential for the database operation and performance1. References:

1: Nutanix Database Automation (NCP-DB) course, Module 2: Database Provisioning, Lesson 2.3: Software Profiles, slide 5

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.

When an administrator cannot proceed with the first step of the wizard to provision a new Oracle single instance database in NDB, the most likely reason is that a software profile for Oracle is missing. NDB requires a software profile (which defines the database version, patches, and configuration) to provision a database instance. Without a profile created from a reference VM or uploaded manually, the wizard cannot proceed, as it relies on this profile to configure the instance correctly.

Option A (Time Machine is not configured) is incorrect because Time Machine is optional for backups and not required for initial provisioning.

Option B (Software profile is missing) is correct as it is a mandatory prerequisite for provisioning any database instance.

Option C (No remote clusters are configured) is incorrect because remote clusters are relevant for multi-cluster setups, not single instance provisioning.

Option D (A snapshot must be taken on the original DB) is incorrect because snapshots are for protection, not a prerequisite for provisioning.

The administrator must create or import a software profile to resolve this issue.

References

Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Software Profiles, Section: Provisioning Databases

Nutanix Support & Insights, Knowledge Base Article: "Troubleshooting Provisioning Failures in NDB"

Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Blueprint, Section 4: Manage Database Software Profiles

Comprehensive and Detailed 100 to 150 words of Explanation From Nutanix Database Management & Automation (NDMA) topics:

NDB cluster registration must account for storage containers associated with resources that need to be available during cross-cluster operations. Although the NDB control-plane VM and database provisioning operations use the same NDB container in this scenario, NutanixManagementShare is a separate Nutanix-managed service container. Its corresponding remote-container relationship must therefore be represented through storage mapping. Mapping the NDB container to default-container is unnecessary because the NDB server and provisioning storage are already consolidated. Removing SCSI disks from the NDB VM would damage the appliance configuration, while an attached CD-ROM does not justify altering the required storage mapping. This differs from the existing questions, which ask when mapping is required because the NDB server and provisioning containers are separate. Therefore, option A is correct. Nutanix cluster-registration documentation

During MySQL HA provisioning, NDB creates the database or schema identified by the Database Name supplied in the provisioning workflow. In MySQL terminology, CREATE DATABASE and CREATE SCHEMA are equivalent, so using the intended default schema as the database name gives developers the required schema as part of the managed deployment. A post-create script could create additional objects, but it is unnecessary for the initial default schema and adds avoidable custom automation. The provisioning workflow does not require uploading a SQL file, and a software profile packages database software and operating-system binaries rather than application schemas. Therefore, the default schema should be defined as the database name. This keeps schema creation within NDB’s declarative provisioning workflow and makes the resulting database manageable as part of the MySQL HA instance. Nutanix uses the Database Name field for this purpose.

Nutanix Database Service provides REST APIs for automating database lifecycle operations, including provisioning, cloning, registration, patching, refreshing, and deprovisioning. A CI/CD pipeline can call these APIs programmatically to request a database, monitor the resulting operation, and retrieve its status without requiring an administrator to use the NDB console. Maintenance Windows schedule maintenance activities, while Time Machine provides snapshot and transaction-log-based data protection. A Network Profile supplies networking configuration but does not provide an automation interface. Therefore, the REST API is the appropriate capability for integrating database provisioning with tools such as Jenkins, GitHub Actions, GitLab CI, or other orchestration platforms. The official NDB API reference documents the endpoints and request structures available for this programmatic integration.

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. References: Nutanix Database Management & Automation (NDMA), page 29; Nutanix Support & Insights, section “Log Catch-up”

When an administrator is creating a Windows Domain profile in Era, the SQL Service Startup Account is an optional field that can be skipped and provided during the provisioning process. This account is used to start the SQL Server service when the server starts up. If this field is not provided during the creation of the Windows Domain profile, it can be provided later during the provisioning process1.

For an existing PostgreSQL database server managed by NDB, additional databases are added by updating the applicable database server parameters through the NDB graphical interface. The Database Parameters Profile represents PostgreSQL instance-level configuration and allows NDB to apply the supported database definition and configuration consistently. Creating additional Time Machines would protect separate database entities but would not create the databases themselves. A Software Profile contains the operating-system and PostgreSQL binaries used for provisioning database server VMs; replacing it is unnecessary for adding databases to an existing instance. A post-provisioning script is also not the standard managed workflow because it would bypass the profile-based configuration maintained by NDB. Therefore, option B is correct: the administrator should modify the Database Parameters Profile for the existing PostgreSQL server. Nutanix PostgreSQL Database Parameters Profile documentation