Free NCP-DB-6.5 Exam Braindumps (page: 7)

Page 7 of 38

What is required to create an NDB Software Profile?

  1. Installer package for database software
  2. Database server VM registered with NDB
  3. Patch file for the installed databases
  4. OS image registered with Prism Element

Answer(s): A

Explanation:

An NDB Software Profile is a template of the OS and database engine that you can use to provision or clone database server VMs using NDB. To create a software profile, you need to upload an installer package for the database software that you want to use, such as SQL Server or Oracle. The installer package must be compatible with the OS image that you have registered with Prism Element. You do not need a database server VM registered with NDB, a patch file for the installed databases, or an OS image registered with Prism Element to create a software profile. Those are required for other tasks, such as creating a software profile version, registering a database server VM, or provisioning a database server VM.


Reference:

Nutanix Benefit 8: Integrated Self-service Database Management, Nutanix Support & Insights, section "NDB Software"



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?

  1. Create a new Software Profile with PostgreSQL 13.8.
  2. Create a maintenance window and add this PostgreSQL server 13.8 to the queue.
  3. Create a new Database Parameters profile for PostgreSQL server 13.8.
  4. 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



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?

  1. Create a Compute Profile and apply it to the VMs during provisioning.
  2. Update the VMs after provisioning and enter the changes to the vCPU cores.
  3. After provisioning the VMs. update the DEFAULT_OOB_COMPUTE Profile.
  4. 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.



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

  1. 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.
  2. Create a new Software Profile version using the CU executable and publish that version.
  3. Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
  4. 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



Page 7 of 38



Post your Comments and Discuss Nutanix NCP-DB-6.5 exam with other Community members:

Wael Edward commented on September 01, 2024
Just Passed using this dump in Egypt All Question except 4 were from this dump But not all the answers were correct
Anonymous
upvote