NCP-DB Certification Exam Questions with AI Explanations

QUESTION: 26

An administrator needs to patch a PostgreSQL database server VM from version 13.4 to 13.8.
What is the first step within the NDB patching workflow to accomplish this task?

Create a new Software Profile with PostgreSQL 13.8.
Create a maintenance window and add this PostgreSQL server 13.8 to the queue.
Create a new Database Parameters profile for PostgreSQL server 13.8.
Create a Software Profile Version with PostgreSQL 13.8.

Answer(s): D

Explanation:

NDB supports patching for PostgreSQL database instances. Patching for PostgreSQL is validated on VMs provisioned by NDB (greenfield deployments). To patch PostgreSQL database server VMs, you must create a software profile version by uploading the PostgreSQL update file in NDB. You can then use the PostgreSQL update to patch other database server VMs or provision a new database server VM with the updated software profile. The first step in the NDB patching workflow is to create a software profile version with the desired PostgreSQL version.

Reference:

Nutanix Database Automation (NCP-DB) Course Details, Section 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) Certification Details, Objective 4.1: Perform Database Patching
Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 4.1: NDB Patching Overview Nutanix Database Automation (NCP-DB) User Guide, Section 4.4: Patch PostgreSQL Database Software

Reveal Solution Next Question

QUESTION: 27

When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.
What is the easiest way for the administrator to accomplish this task?

Create a Compute Profile and apply it to the VMs during provisioning.
Update the VMs after provisioning and enter the changes to the vCPU cores.
After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.
Create a Windows Domain Profile that will synchronize the configurations.

Answer(s): A

Explanation:

A Compute Profile is a template that defines the CPU, memory, and disk resources for a database server VM. By creating a Compute Profile with the desired number of cores per vCPU, the administrator can easily apply it to multiple VMs during provisioning, ensuring consistent and optimal performance. This also saves time and effort compared to updating the VMs individually or modifying the default profile after provisioning.

Reference:

Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, How-to setup number of cores per CPU in a virtual machine.

Reveal Solution Next Question

QUESTION: 28

An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?

Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.
Create a new Software Profile version using the CU executable and publish that version.
Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
Create a new Software Profile using the CU executable and publish that profile.

Answer(s): C

Explanation:

The correct answer is C because it follows the recommended procedure for applying a CU to a SQL

Server Software Profile in NDB. By applying the patch to the profile VM, the administrator ensures that the CU is compatible with the existing Software Profile settings and configuration. By creating a new Software Profile version, the administrator preserves the previous version of the Software Profile for rollback purposes and allows the new version to be tested and published. Option A is incorrect because it deletes the existing Software Profile, which may cause data loss and prevent rollback. Option B is incorrect because it does not apply the patch to the profile VM, which may result in errors or inconsistencies in the Software Profile. Option D is incorrect because it creates a new Software Profile instead of a new version, which may cause confusion and duplication.

Reference:

The following sources provide more information about the Software Profile management and patching in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 5: Patching Databases Using NDB, Lesson 5.2: Creating and Modifying Software Profiles Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 4 - Operate and Maintain an NDB Environment
Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.2:
Creating and Modifying Software Profiles
Nutanix Database Service (NDB) User Guide, Chapter 5: Patching Databases Using NDB, Section 5.3:
Testing and Publishing Database Patches

Reveal Solution Next Question

QUESTION: 29

An administrator created a database clone that is scheduled for removal on the last day of the month.
A request has been received to keep the clone for an additional 14 days. After selecting the desired clone, how should the administrator satisfy this task?

Update the Removal schedule to the desired date.
Update the Removal schedule to the end of the month.
Remove the Removal schedule, then add the desired removal schedule.
Select Update and modify the Removal schedule.

Answer(s): D

Explanation:

The Removal schedule is a feature of Nutanix Era that allows you to specify when a database clone will be automatically deleted. You can modify the Removal schedule of an existing clone by selecting the clone from the Clones page, clicking on the Update button, and changing the Removal schedule option to the desired date. This way, you can extend or shorten the lifespan of a clone as per your requirements. You do not need to remove the existing Removal schedule and add a new one, as this would be an unnecessary step. You also do not need to update the Removal schedule to the end of the month, as this would not meet the request of keeping the clone for an additional 14 days.

Reference:

Nutanix Database Management & Automation Training Course, Module 4: Protecting Databases Using Time Machine, Lesson 3: Cloning Databases, Slide 10: Clone Removal Schedule Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam, Section 5: Protect NDB- managed Databases Using Time Machine, Objective 5.3: Given business requirements, perform a database clone

Reveal Solution Next Question

QUESTION: 30

Which policies define Time Machine data availability across multiple registered clusters in NDB?

Recovery Plans
Data Access Management
Data Protection
Service Level Agreements

Answer(s): A

Explanation:

The recovery plans policy defines the Time Machine data availability across multiple registered clusters in NDB. The recovery plans policy allows the database administrator to specify the source and target clusters, the frequency and retention of the cross-cluster snapshots, and the network and compute profiles for the recovery operations. The recovery plans policy helps to ensure the disaster recovery and business continuity of the NDB-managed databases in case of a cluster failure or outage.
The data access management policy defines the access permissions and roles for the NDB users and groups. The data access management policy allows the database administrator to grant or revoke access to the NDB instance, the database server VMs, the databases, and the database operations. The data access management policy helps to ensure the security and compliance of the NDB- managed databases and users.
The data protection policy defines the backup and restore settings for the NDB-managed databases. The data protection policy allows the database administrator to specify the frequency, retention, and compression of the database snapshots, and the backup location and encryption for the database backups. The data protection policy helps to ensure the backup and recovery of the NDB-managed databases within the same cluster.
The service level agreements policy defines the performance and availability metrics for the NDB- managed databases. The service level agreements policy allows the database administrator to monitor and enforce the database uptime, latency, throughput, and IOPS. The service level agreements policy helps to ensure the quality of service and performance of the NDB-managed databases.

Reference:

Nutanix Database Management & Automation Training Course, Module 4: Nutanix Era Configuration, Lesson 4.1: Nutanix Era Configuration, slide 9.

Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.1: Nutanix Era Operations, slides 8, 12, 16, 20. Nutanix Database Management & Automation Training Course, Module 6: Nutanix Era Disaster Recovery, Lesson 6.1: Nutanix Era Disaster Recovery, slides 5-7.

Reveal Solution Next Question

Nutanix Certified Professional - Database Automation v6.5 NCP-DB Dumps in PDF

Free Nutanix NCP-DB Real Questions (page: 20)

QUESTION: 26

Explanation:

Reference:

QUESTION: 27

Explanation:

Reference:

QUESTION: 28

Explanation:

Reference:

QUESTION: 29

Explanation:

Reference:

QUESTION: 30

Explanation:

Reference: