Nutanix Certified Professional - Database Automation v6.10 NCP-DB Exam Questions

Answer : B, D

NDB allows creating and refreshing clones to a point in time using two primary methods:

B . Snapshots: NDB uses storage snapshots (e.g., via Nutanix Volumes or AHV) to capture the database state at a specific point. These snapshots can be used to create or refresh clones, providing a consistent recovery point.

D . Transaction logs: Transaction logs (e.g., PostgreSQL WAL, SQL Server logs) enable point-in-time recovery (PITR) by applying logs to a snapshot, allowing clones to be refreshed to a precise moment.

Other options are not supported for this purpose:

A . Full backups: Full backups are used for complete restores but are not optimized for frequent clone refreshes.

C . VM snapshots: VM-level snapshots (e.g., AHV snapshots) are not managed by NDB for database cloning, as they lack database consistency.

Thus, the verified answers are B and D, reflecting NDB's clone refresh capabilities.

Official Nutanix Database Automation Reference:

Nutanix Database Management & Automation (NDMA) course, Module 5: Data Protection and Recovery, Lesson 5.2: Managing Time Machines and Clones.

Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section 5: Protect Databases Using NDB, Objective 5.2: Manage Clones (applicable to v6.10).

Nutanix NDB Administration Guide: 'Clone Creation and Refresh' section.

Answer : B

When downloading a list of alerts from NDB, the available file format is csv (Comma-Separated Values). NDB provides this format to export alert data (e.g., alert ID, timestamp, severity, description) in a structured, machine-readable way that can be easily imported into spreadsheet applications like Microsoft Excel or analyzed programmatically. This aligns with NDB's focus on operational efficiency and data portability.

Other options are not supported:

A . xlsx: Excel's native format is not offered by NDB for alert exports.

C . xml: Not a supported format for alert downloads in NDB.

D . pdf: Used for reports, not alert list exports.

Thus, the verified answer is B, reflecting NDB's export capabilities.

Official Nutanix Database Automation Reference:

Nutanix Database Management & Automation (NDMA) course, Module 6: Monitoring and Alerts, Lesson 6.2: Managing Alerts.

Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section 6: Optimize NDB Solutions, Objective 6.2: Manage Alerts (applicable to v6.10).

Nutanix NDB Administration Guide: 'Exporting Alerts' section, specifying CSV format.

Answer : B

An administrator can configure a custom SSL certificate for Era through the Era User Interface (UI)1.This can be done by logging into the Nutanix Console and selecting SSL Certificates from the drop-down list inside the gear icon23.In the SSL Certificate dialog box, the administrator can click Replace Certificate, then select the Import Key and Certificate radio button23.This process ensures secure communication within the Nutanix Era environment4.

Answer : C

NDB Multi-Cluster is a feature that allows multiple Nutanix clusters to share a common NDB service for database management and automation. NDB service consists of two components: NDB Server and NDB Agent. NDB Server is the central component that provides the web UI, REST API, and database orchestration logic. NDB Agent is the component that runs on each Nutanix cluster and communicates with the NDB Server to perform database operations.

When NDB Multi-Cluster is enabled on Cluster A, it becomes the primary cluster that hosts the NDB Server VM. Cluster B, which is registered with NDB, becomes a secondary cluster that hosts only the NDB Agent VM. Therefore, Cluster A has both NDB Server and NDB Agent, while Cluster B has only NDB Agent. This configuration allows Cluster B to leverage the NDB service running on Cluster A for database management and automation.

Nutanix Database Automation (NCP-DB) Course Details, Section 3.1: NDB Multi-Cluster Overview

Nutanix Database Automation (NCP-DB) Certification Details, Objective 3.1: Configure NDB Multi-Cluster

Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 3.1: NDB Multi-Cluster Overview

Answer : A

In a Nutanix Era setup where Multi-Cluster is enabled and the Era Server storage container and Era provisioning container are different on the Era cluster, the administrator should configure a storage mapping between the Era server container and the remote container that is used for provisioning databases1.This is because Nutanix Era uses the storage container specified during the registration of the Nutanix cluster for provisioning databases1.Therefore, a storage mapping needs to be established between the Era server container and the remote container used for provisioning to ensure that the databases are provisioned correctly1.

Answer : B

In an NDB environment, the repository VM stores metadata and configuration data but is not a critical runtime component for service availability. If the team powers off the repository VM during maintenance, and it is neither the primary nor a synchronized copy node, the NDB service will continue to operate without interruption. NDB's high availability (HA) architecture, managed by HAProxy and other components, ensures redundancy and failover capabilities, allowing the system to rely on the primary and synchronized nodes. The repository VM's downtime only affects metadata access, which can be restored post-maintenance without impacting ongoing database operations.

Option A (The HAProxy VMs will failover instead) is incorrect because HAProxy failover is triggered by primary service node failures, not repository VM power-off.

Option B (There will be no service interruption) is correct as the HA design tolerates a non-primary, non-synchronized repository VM being offline.

Option C (Manual interaction will be required to restore service) is incorrect because no service restoration is needed during this scenario.

Option D (NDB services will fail over immediately) is incorrect because failover is not triggered by a non-critical repository VM power-off.

This reflects NDB's robust HA implementation.

Nutanix Database Service (NDB) User Guide, Chapter 3: Configuring an NDB Environment, Section: High Availability Architecture

Nutanix Support & Insights, Knowledge Base Article: 'Impact of Repository VM Maintenance in NDB'

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

Answer : B

Before registering a SQL Server Single Node Database Server VM with NDB, it is necessary that the login account provided for this task must be a member of the sysadmin role. This ensures the necessary permissions are in place for managing and administering the SQL Server instance. Reference:: Nutanix Database Automation documentation, under SQL Server database registration and permission requirements.