Pass the Nutanix Certified Professional (NCP) NCP-DB Questions and answers with Dumpstech

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.

NDB executes complex lifecycle operations as workflows containing multiple subtasks. In the Operations dashboard, an administrator can open an operation and review each subtask’s name, status, start time, end time, and duration. If the overall operation fails, this task-level view identifies the precise workflow step that failed, allowing the administrator to investigate the relevant error instead of relying on one generic timeout code. The dashboard does not automatically capture all network traffic, create an external support case, or guarantee an automatic database rollback. Depending on the failed operation, remediation or rollback may require a separate supported procedure. Nutanix’s official instructions for viewing operation logs confirm that detailed subtask information is available for monitoring and troubleshooting operations.

When an Oracle database is upgraded using Era, the type of upgrade category is an “In-place upgrade”. This method involves upgrading the database software within the same Oracle home as the existing database. The AutoUpgrade utility is used to automate the upgrade process, both before starting upgrades, during upgrade deployments, and during post-upgrade checks and configuration migration1. This method is preferred due to its simplicity and efficiency1.

 Nutanix Era provides a unified database operating model that delivers simplicity, performance, availability, and security across private and public clouds1. It standardizes your Oracle database ecosystem by mass patching the databases with one-click simplicity2. This includes the following features:

Automated Patching: Era patching can be automated using REST API/CLI for scheduled patching many Oracle servers in a fleet patching scenario1. This allows for the standardization of your Oracle database ecosystem by mass patching the databases with one-click simplicity2.

Automatic Rollback: Era patching for Oracle databases has automatic rollback if any of the steps in the patching workflow fails1. This ensures that your databases remain secure and functional even if an issue arises during the patching process1.

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.

In NDB, database groups are used to manage multiple Microsoft SQL Server databases collectively, enabling centralized administration and protection policies. The statement "Databases within a database group can share multiple Time Machine configurations" is true. A Time Machine in NDB manages snapshots and log backups for recovery, and a database group can be associated with multiple Time Machine configurations to support different retention policies or recovery point objectives (RPOs) for the databases within the group. This flexibility allows tailored data protection strategies.

Other options are incorrect:

A. Microsoft recommends 35 databases within a single database group: There is no specific Microsoft recommendation for this limit; NDB imposes its own constraints based on performance and resource usage.

C. NDB supports one database group per database server VM or database server cluster: NDB allows multiple database groups per server or cluster, depending on configuration.

D. Databases within a database group must be all of the same size: NDB does not enforce uniform database sizes within a group.

Thus, the verified answer is B, reflecting NDB’s Time Machine flexibility.

Official Nutanix Database Automation References

Nutanix Database Management & Automation (NDMA) course, Module 3: Managing Database Instances, Lesson 3.6: Managing Database Groups.

Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Knowledge Objectives, Section 3: Manage NDB Solutions, Objective 3.5: Configure Database Groups (applicable to v7.5).

Nutanix NDB Administration Guide: "Database Groups and Time Machine Configurations" section.

The Global Service Level Agreement (SLA) feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration1. This feature provides a unified way to manage and enforce backup and replication policies across multiple clusters, ensuring consistent data protection and recovery across the entire environment1.

PostgreSQL max_connections is an engine-level initialization parameter that controls the maximum number of concurrent sessions accepted by the database server. NDB manages settings of this type through a Database Parameters Profile. The administrator can create or customize a PostgreSQL parameters profile, set the required connection limit, and select that profile during provisioning so the new instance starts with the approved production configuration. A Network Profile controls VLAN and address allocation, not database session limits. A Software Profile contains the operating-system and PostgreSQL software image used to create the server. A Windows Domain Profile contains Active Directory and Windows service-account information and is not applicable to this Linux-based PostgreSQL setting. Therefore, option D is correct. The parameter should also be sized according to available memory and workload requirements. Official Nutanix PostgreSQL profile documentation

================

Configuring VM Host Affinity in a Nutanix AHV-powered cluster ensures that VMs are placed on specific hosts to optimize performance or HA. However, after a host failure, if database VMs cluster on a single remaining host, it indicates that the affinity rules alone are insufficient to maintain high availability (HA) during failover scenarios. To prevent this, the administrator should configure anti-affinity rules, which dynamically ensure that VMs (e.g., database server VMs) are spread across multiple hosts. Anti-affinity rules override default VM placement behavior during failover, reducing the risk of a single point of failure by keeping VMs separated even after a host outage.

Option A (Assign additional backup VMs on the same host) is incorrect because placing backups on the same host increases risk rather than mitigating it.

Option B (Increase affinity zones) is incorrect as "affinity zones" is not a standard Nutanix term in this context, and it does not address dynamic VM separation.

Option C (Configure automatic host failover in Prism Central) is incorrect because while failover is managed by AHV, it does not inherently prevent VMs from clustering without specific rules.

Option D is correct as anti-affinity rules proactively distribute VMs, enhancing HA in failure scenarios.

This approach leverages Nutanix AHV’s VM placement policies to ensure resilience.

References

Nutanix Database Service (NDB) User Guide, Chapter 3: Configuring an NDB Environment, Section: Configuring VM Affinity and Anti-Affinity

Nutanix AHV Administration Guide, Section: VM High Availability and Placement Rules

Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Blueprint, Section 3: Configure an NDB Environment

In Nutanix Database Service (NDB), patching Oracle database engines requires the "Update" button to be available on the database server VM’s management interface. If this button is missing, it typically indicates a configuration issue preventing NDB from performing the patching operation. The most common and critical reason is that the operating system (OS) credentials for the database server VM have not been set or registered with NDB. These credentials are necessary for NDB to authenticate and execute patching tasks on the VM, such as accessing the Oracle software and applying updates via a software profile.

Option A is correct because missing OS credentials prevent NDB from establishing the required connection to the VM, disabling the Update button.

Option B (Database parameters are missing) is incorrect because while database parameters are important for configuration, they do not directly control the visibility of the Update button for patching.

Option C (Oracle DB engines cannot be patched) is incorrect as NDB explicitly supports patching Oracle databases when properly configured.

Option D (Software profile is not published) is incorrect because an unpublished software profile might limit availability to users, but the Update button’s presence relies on VM connectivity, not profile publication status.

To resolve this, the administrator must register valid OS credentials for the VM in NDB, enabling the patching functionality.

References

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

Nutanix Support & Insights, Knowledge Base Article: "Troubleshooting Missing Update Button in NDB"

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