Latest Success Metrics For Actual NCP-DB Exam 2025 Realistic Dumps [Q41-Q66]

Share

Latest Success Metrics For Actual NCP-DB Exam 2025 Realistic Dumps

Updated NCP-DB Dumps Questions For Nutanix Exam


Nutanix NCP-DB Exam Syllabus Topics:

TopicDetails
Topic 1
  • Administer an NDB Environment: While focusing on the administration of an NDB environment, this topic focuses on managing NDB profiles, applying procedural concepts, and managing networks in NDB. Lastly, the topic explains sub-topics of managing access controls in NDB and identifying how to use NDB APIs and CLI.
Topic 2
  • Describe NDB Concepts: It defines database and NDB terminology. The topic also explains benefits and features of NDB.
Topic 3
  • Monitor Alerts and Storage Usage Within an NDB Implementation: It is all about monitoring alerts and management of storage usage.
Topic 4
  • Deploy and Configure an NDB Solution: This topic discusses how to deploy, configure, and NDB Instance.

 

NEW QUESTION # 41
Refer to the exhibit.

An administrator, whose accounts are shown in the exhibit, is trying to add a new database admin as a local user to NDB, but is unable to complete the task.
What is most likely the cause of the issue?

  • A. The administrator is logged in with the Database Admin account.
  • B. An email address is required for the Super Admin account.
  • C. Only users in the domain admins group can create local users.
  • D. The administrator is logged in with the Super Admin account.

Answer: A

Explanation:
Based on the exhibit, the administrator is logged in with the Database Admin account ([email protected]), which does not have the permission to create local users on NDB. Only the Super Admin account (bsmith) has this permission, as indicated by the User type column. Therefore, the administrator needs to log out and log in again with the Super Admin account to add a new database admin as a local user to NDB. References: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, Nutanix Database Automation User Guide.


NEW QUESTION # 42
An administrator is trying to register a database server VM with NDB.
Which file types will prevent the registration from being successful if located in the C:\ drive?

  • A. Backup
  • B. Page
  • C. Database
  • D. System

Answer: B

Explanation:
Page files are temporary files that Windows uses to store data that does not fit in the physical memory. Page files can interfere with the registration of a database server VM with NDB, as they can cause errors or performance issues. Therefore, page files shouldbe located in a separate drive or partition from the C:\ drive, where the NDB agent and other files are installed. System, database, and backup files do not prevent the registration of a database server VM with NDB, as long as they are not corrupted or incompatible with the NDB requirements. References:
* Nutanix Database Management & Automation Training Course, Module 2: Deploying and Configuring an NDB Solution, Lesson 2: Configuring an NDB Instance, Slide 13: Registering Database Server VMs
* Nutanix Certified Professional - Database Automation (NCP-DB) 5 Exam, Section 4: Operate and Maintain an NDB Environment, Objective 4.1: Apply procedural concepts to register database server VMs and databases


NEW QUESTION # 43
A new web application performs up to 200 concurrent connections to a PostgreSQL database. An administrator needs to configure the system to provision those DB servers.
Which action would easily help the administrator achieving this goal?

  • A. Create a new Database Parameters profile.
  • B. Edit the API equivalent shell script to apply the setting.
  • C. Provision a PostqreSQL HA Instance.
  • D. Use Post Create Command when provisioning the DB.

Answer: C

Explanation:
A new web application with up to 200 concurrent connections to a PostgreSQL database requires a robust and scalable configuration. Provisioning a PostgreSQL HA (High Availability) instance in NDB is the most effective action to achieve this goal. An HA instance leverages replication (e.g., streaming replication) to distribute load and ensure availability, accommodating high concurrency by allowing multiple nodes to handle traffic. This approach simplifies configuration compared to manual scripting or parameter adjustments.
* Option A (Use Post Create Command when provisioning the DB) is incorrect because post-create commands are for custom scripts, not optimal for handling concurrent connections.
* Option B (Create a new Database Parameters profile) is incorrect because while it can tune settings, it's less efficient than HA for scaling concurrency.
* Option C (Edit the API equivalent shell script) is incorrect as it's a manual and error-prone method compared to HA provisioning.
* Option D is correct because a PostgreSQL HA instance natively supports high concurrency and availability.
Note: The typo "PostqreSQL" is assumed to mean "PostgreSQL."
References
* Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Database Engines, Section:
Provisioning HA Instances
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 4: Manage Database Engines


NEW QUESTION # 44
An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:
* Two database server VMS including the primary replica on a local site
* A third database server VM on a remote site
How many IP addresses will the network at each site require?

  • A. Cluster VIP end I Listener IP on the local site
    1 Cluster VIP and 1 Listener IP on the remote site
    2 IPs in the local site and 1 on the remote site for the database server nodes
  • B. 2 Cluster VIP and 1 listener IP on the local site
  • C. 1 Cluster VIP and 1 listener IP on the remote site
    2 IPs in the local site and 1 on the remote site for the database server nodes
    1 Cluster VIP on the local site
    1 Cluster VIP and 1 Listener IP on the remote site
    2 IPs in the local site and 1 on the remote site for the database server nodes
  • D. I Cluster VIP end I Listener IP on the local site
    1 Listener IP on the local site
    2 IPs in the local site and I on the remote site for the database server nodes

Answer: A

Explanation:
The correct answer is D. When setting up a 3-node MSSQL Server AG with two database server VMs on a local site and a third database server VM on a remote site, the network at each site will require the following IP addresses:
* 1 Cluster VIP and 1 Listener IP on the local site123.
* 1 Cluster VIP and 1 Listener IP on the remote site123.
* 2 IPs in the local site and 1 on the remote site for the database server nodes123.
This configuration ensures that each node in the cluster has a unique IP address, and each cluster and listener also has a unique IP address. This is necessary for the proper functioning of the cluster and to ensure that all nodes can communicate with each other and with clients123.


NEW QUESTION # 45
Exhibit.

An administrator just created the ndb_test user as shown in the exhibit. Which two tasks can this user perform? (Choose two.)

  • A. Network Profiles
  • B. NDB Configuration
  • C. Access Control
  • D. Clones

Answer: B,D

Explanation:
The exhibit shows the NDB user management interface with a newly created user named "ndb_test" assigned the "Database Infrastructure Admin" role and sourced as a "Local User." In NDB, the "Database Infrastructure Admin" role grants specific permissions, allowing the user to manage database-related tasks such as creating, managing, and deleting clones, as well as performing configuration tasks within the NDB environment (e.g., updating settings or managing database servers). However, this role does not extend to higher-level administrative functions like Access Control or Network Profiles, which are reserved for roles with broader administrative privileges (e.g., System Administrator).
* Option A (Access Control) is incorrect because managing user access and roles requires a higher privilege level, such as System Administrator, not Database Infrastructure Admin.
* Option B (Network Profiles) is incorrect because configuring network profiles is an administrative task outside the Database Infrastructure Admin scope.
* Option C (Clones) is correct as the Database Infrastructure Admin role includes permissions to create and manage clones using Time Machine.
* Option D (NDB Configuration) is correct as this role allows configuration of database-related settings within NDB, such as registering VMs or adjusting database parameters.
Thus, the "ndb_test" user can perform clone management and NDB configuration tasks.
References
* Nutanix Database Service (NDB) User Guide, Chapter 6: Administering an NDB Environment, Section: User Roles and Permissions
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 6: Administer an NDB Environment


NEW QUESTION # 46
Refer to the exhibit.

An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.
Which database engine was being deployed during this operation?

  • A. Microsoft SQL
  • B. MySQL
  • C. PostgreSQL
  • D. Oracle

Answer: B

Explanation:
The error message in the exhibit indicates that the operation failed during the "Create and Register Database Server VMs" step because "Provisioning of all the observers simultaneously took more than two hours." This type of error is associated with MySQL, as it involves observers which are a part of MySQL Group Replication, used for ensuring high availability1. The other options are not related to the error message, as they do not use observers or Group Replication for clustering. References:
* 1: Nutanix Database Automation (NCP-DB) course, Module 5: Database High Availability, Lesson 5.2:
MySQL Group Replication, slide 7


NEW QUESTION # 47
Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?

  • A. Third-party backups vendors can continue to backup the binary logs from the binary log location. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get purged.
  • B. Third-party backups vendors can continue to backup the archived logs from the database log destination. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up
  • C. If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be supported, but snapshot-based recovery of the databases is supported.
  • D. If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported, but snapshot-based recovery of the databases is not supported.

Answer: B

Explanation:
NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and 3rd- party managed. In the NDB-managed mode, NDB takes full control of the log backups and stores them in the Cerebro log location. In the 3rd-party managed mode, NDB allows the use of external backup tools to backup the logs from the database log destination. However, NDB still needs to capture the logs for its own operations, such as point-in-time recovery, clone refresh, and log catch-up. Therefore, NDB will periodically scan the database log destination and copy the logs to the Cerebro log location. This process requires that the log catch-up begins before the logs get backed up by the 3rd-party tool, otherwise NDB will miss some logs and the operations will fail. If the 3rd-party tool grants exclusive access to the logs, then NDB will not be able to capture them at all, and the operations will not be supported. References:
* Nutanix Database Management & Automation (NDMA) course, Module 5, Lesson 5.2 - Log Backup Management
* Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Log Backup Management


NEW QUESTION # 48
An administrator configures VM Host Affinity for database server VMs on a Nutanix AHV-powered cluster, intending to optimize HA by ensuring that VMs are placed on separate hosts. After a host failure, the administrator notices that database VMs are clustered on a single remaining host, risking another outage.
How could the administrator avoid this scenario in future host failures?

  • A. Set anti-affinity rules to spread VMs across multiple nodes dynamically.
  • B. Increase the number of affinity zones within the cluster
  • C. Assign additional backup VMs within the same host to maintain service.
  • D. Configure automatic host failover in Prism Central.

Answer: A

Explanation:
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) v6.5 Blueprint, Section 3: Configure an NDB Environment


NEW QUESTION # 49
Which Time Machine feature allows developers to automate the data refresh for their clones?

  • A. update
  • B. Manual Backup
  • C. Log Catchup
  • D. Schedule

Answer: D

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, the Schedule feature of the Time Machine allows developers to automate the data refresh for their clones1. This feature eliminates the time-consuming, complex process of database clone/refresh, allowing admins to create database clones
/refresh to any point in time in just a few minutes1. Please refer to the official Nutanix documentation and training materials for more detailed information2.


NEW QUESTION # 50
A legal team wants to audit a quarter end (July 31st) banking transaction event and asks the administrator to create a SQL database from the timeframe.
What action should the administrator perform within Era?

  • A. Provision a database, restore the backup from Ju)' 31st, and Recover the database to bring the database up.
  • B. Provision a database and attach the July 31st backup from Time Machine.
  • C. Create a clone from July 31st snapshot in Time Machine.
  • D. Restore a backup from July 31st, Recover the database to bring the database up.

Answer: C

Explanation:
Nutanix Era enables you to clone your source databases (running on Nutanix clusters) and refresh the database clones by using snapshots or transaction logs1. Era uses storage-efficient and time-efficient Nutanix snapshots, thus lowering the cost of managing multiple copies of your databases1. In this case, the administrator should create a clone from the July 31st snapshot in Time Machine to provide the legal team with the specific banking transaction event data they need for their audit1.


NEW QUESTION # 51
What must be completed within NDB before patching a Linux OS?

  • A. Configure the repository.
  • B. Update the database.
  • C. Update the software profile version.
  • D. Configure database high availability.

Answer: A

Explanation:
Before patching a Linux OS on a database server VM provisioned using NDB, you must configure the repository for the OS updates. This can be done by creating a Repository Profile in NDB and specifying the URL, username, and password for the repository. The Repository Profile can be applied to one or more database server VMs during the provisioning process or later. By configuring the repository, you ensure that NDB can access and download the latest OS patches from a trusted source. References: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, Nutanix Database Automation User Guide.


NEW QUESTION # 52
What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?

  • A. 0
  • B. 1
  • C. 2
  • D. 3

Answer: D

Explanation:
The minimum frequency configurable for the NDB Log Catch-up operation is 15 minutes. This setting determines how frequently the log catch-up process runs, which is crucial for maintaining data integrity and ensuring up-to-date database states.References:Nutanix Database Automation documentation, focusing on log management and catch-up operation settings.


NEW QUESTION # 53
An administrator is asked to refresh a database everyday at 9:30PM with data from as close to the refresh time as possible.
What is the best way achieve this requirement?

  • A. Schedule an SLA policy that performs a snapshot at 99M and log catchup for every 15 min.
  • B. Schedule an SLA policy to perform snapshot everyday at 9PM.
  • C. Schedule an SLA policy to perform snapshot everyday at 9.30PM.
  • D. Schedule e log catchup everyday at 9:30PM.

Answer: C

Explanation:
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.


NEW QUESTION # 54
Refer to the exhibit.

An administrator is receiving critical NDB email alerts regarding storage for the DBA database, which is a member of a database group.
How would the administrator remediate the issue within NDB?

  • A. From the Alerts page, select the alert, choose Set Status to Resolved, and Scale the storage via the Resolve Now dialogue box.
  • B. From Prism Central, add additional storage to the VM, then expand the log storage via the database tools.
  • C. From the Database Summary page for the DBA database, use the Scale option to grow the storage accordingly.
  • D. From the Databases page, select the Database group and Scale the storage from the Database Actions menu.

Answer: C

Explanation:
The administrator can remediate the issue of critical storage alerts by scaling up the storage directly from the Database Summary page for that specific DBA database. This action allows for an increase in storage capacity to alleviate space constraints and prevent future critical alerts related to storage space1. The other options are not correct, as they either involve scaling the entire database group, which may not be necessary or desired, or require additional steps outside of NDB, which may not be feasible or efficient. References:
* 1: Nutanix Database Automation (NCP-DB) course, Module 2: Database Provisioning, Lesson 2.4:
Database Scaling, slide 5


NEW QUESTION # 55
An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.
How should the administrator define the Frequency and retention on the SLA?

  • A. * Continuous log retention (days): 5
    * Weekly snapshot retention (weeks): 1
  • B. * Continuous log retention (days): 7
    * Daily snapshot retention (days): 5
  • C. * Daily snapshot retention (days): 7
    * Continuous log retention (days): 5
  • D. * Weekly snapshot retention (weeks): 1
    * Continuous log retention (days): 7

Answer: C

Explanation:
The correct answer is D because it meets the requirements of maintaining five days of time-travel capability to any second and an additional seven days of discrete recovery at a daily interval. Continuous log retention allows the administrator to restore the database to any point in time within the specified number of days, while snapshot retention allows the administrator to restore the database to a specific point in time at a fixed interval. Therefore, by setting the daily snapshot retention to 7 days, the administrator can ensure that there is a discrete recovery point for each day of the week. By setting the continuous log retention to 5 days, the administrator can ensure that there is a time-travel capability to any second within the last five days. The other options do not meet the requirements because they either have less than five days of continuous log retention or less than seven days of snapshot retention. References: Nutanix Database Management & Automation (NDMA) course, Nutanix Certified Professional - Database Automation (NCP-DB) certification, Nutanix NCP-DB Certification Exam Syllabus and Study Guide, Nutanix Certified Professional - Database Automation (NCP-DB) datasheet


NEW QUESTION # 56
In order to configure and begin taking advantage of the Data Access Management feature of Time Machine, which action should an administrator take first?

  • A. Take an application consistent snapshot of the source database.
  • B. Ensure that the source database has been provisioned on the remote Nutanix cluster.
  • C. Enable NDB multi-cluster and register required Nutanix cluster(s).
  • D. Enable NDB HA to protect the metadata associated with the configuration.

Answer: C

Explanation:
To configure and begin taking advantage of the Data Access Management feature of Time Machine, the administrator must first enable NDB multi-cluster and register the required Nutanix cluster(s). Data Access Management allows controlled access to data (e.g., snapshots, clones) across multiple clusters, requiring a multi-cluster setup. This involves enabling multi-cluster support in NDB and registering remote clusters to facilitate data replication and access policies.
Other actions are prerequisites or subsequent steps:
* A. Enable NDB HA to protect the metadata associated with the configuration: HA is beneficial but not the first step for Data Access Management.
* C. Take an application consistent snapshot of the source database: This is a later step after multi- cluster setup.
* D. Ensure that the source database has been provisioned on the remote Nutanix cluster:
Provisioning follows multi-cluster registration.
Thus, the verified answer is B, establishing the multi-cluster foundation.
Official Nutanix Database Automation References
* Nutanix Database Management & Automation (NDMA) course, Module 5: Data Protection and Recovery, Lesson 5.3: Configuring Data Access Management.
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section
5: Protect Databases Using NDB, Objective 5.3: Configure Data Access (applicable to v6.10).
* Nutanix NDB Administration Guide: "Data Access Management Setup" section.


NEW QUESTION # 57
An administrator needs to perform LCM upgrades on an AHV cluster registered with NDB. The cluster hosts NDB-provisioned database server VMs that are part of a database server cluster.
What should the administrator do to allow the DB Server VMs to stay available while the cluster is being upgraded?

  • A. Remove Nutanix Cluster
  • B. Unset VM-Host Affinity
  • C. Update Nutanix Cluster
  • D. Set VM-Host Affinity

Answer: D

Explanation:
The correct answer is B because setting VM-Host affinity ensures that the DB Server VMs are not migrated to another host during the LCM upgrade process. This way, the DB Server VMs can continue to serve the database requests without interruption. Option A is incorrect because updating the Nutanix cluster does not prevent the DB Server VMs from being moved to another host. Option C is incorrect because removing the Nutanix cluster from NDB will make the DB Server VMs unmanaged by NDB and lose thebenefits of NDB features. Option D is incorrect because unsetting VM-Host affinity will allow the DB Server VMs to be migrated to another host during the LCM upgrade process, which may cause downtime or performance degradation.
References: The following sources provide more information about the LCM upgrades and VM-Host affinity in NDB:
* Nutanix Database Management & Automation (NDMA) course, Module 6: Administering an NDB Environment, Lesson 6.3: Performing NDB Software Upgrades
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section
6 - Administer an NDB Environment
* Nutanix Database Service (NDB) User Guide, Chapter 8: Administering an NDB Environment, Section
8.3: Performing NDB Software Upgrades
* Nutanix Support & Insights, Your guide to the Upgrades, LCM Design
* Nutanix Life Cycle Manager Guide, Chapter 3: Upgrading Software and Firmware, Section 3.2:
Preparing for an Upgrade, VM-Host Affinity


NEW QUESTION # 58
A development team has requested that an administrator provide them a copy of the production Finance database. The business requires that any financial data is masked before going into development.
How should the administrator create a clone with masked data for the development environment?

  • A. 1. Create a masking script on the source DB VM, Dev VM or SW Profile VM.
    2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.
  • B. From the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.
  • C. From the Time Machine, create a clone and paste the masking commands in the post-clone field of the Pre-Post Commands section.
  • D. 1. Create a script to mask the data.
    2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.

Answer: A

Explanation:
According to the Nutanix Database Automation (NCP-DB) course, the Pre-Post Commands section allows the administrator to specify custom scripts that can be executed before or after the clone operation1. The masking script can be created on any of the VMs that have access to the source database, such as the source DB VM, the Dev VM, or the SW Profile VM2. The script should contain the commands to mask the sensitive data in the Finance database, such as replacing the real values with dummy values or encrypting the data2. The administrator can then create the clone from the Time Machine and define the post-clone option with the full path and name of the masking script1. This will ensure that the script is executed after the clone is created, and the data is masked before it is available for the development team1. The other options are not correct, as they either use the wrong field (pre-clone instead of post-clone), or do not specify where to create or store the masking script. References:
* 1: Nutanix Database Automation (NCP-DB) course, Module 4: Database Cloning, Lesson 4.4: Pre-Post Commands, slide 5
* 2: Nutanix Database Automation (NCP-DB) course, Module 4: Database Cloning, Lesson 4.4: Pre-Post Commands, slide 7


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

  • A. 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.
  • B. Create a new Software Profile version using the CU executable and publish that version.
  • C. Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
  • D. Create a new Software Profile using the CU executable and publish that profile.

Answer: 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.
References: 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


NEW QUESTION # 60
A vCenter instance which manages multiple clusters including a Nutanix cluster hosting NDB service crashed. After deploying a dedicated new vCenter server, the administrator needs to update vCenter setting within NDB.
Which action should be performed?

  • A. Wait 60 minutes and Prism Central will automatically sync NDB.
  • B. Click the Getting Started page and perform the configuration wizard.
  • C. Update cluster settings from the NDB administration page.
  • D. Open the maintenance page in NDB and configure the cluster settings.

Answer: C

Explanation:
When a vCenter instance managing multiple clusters, including a Nutanix cluster hosting the NDB service, crashes and a new dedicated vCenter server is deployed, the administrator must update the vCenter settings within NDB to re-establish connectivity and management. The correct action is to navigate to the NDB Administration page, where cluster and vCenter configurations can be updated. This page allows the administrator to re-register the new vCenter instance, ensuring NDB can continue to manage the clusters and database VMs effectively. This approach avoids unnecessary reconfiguration wizards or waiting for automatic syncs.
* Option A (Click the Getting Started page and perform the configuration wizard) is incorrect because the Getting Started wizard is for initial setup, not post-crash vCenter updates.
* Option B (Update cluster settings from the NDB administration page) is correct as it provides the specific interface to modify vCenter settings after a crash.
* Option C (Open the maintenance page in NDB and configure the cluster settings) is incorrect because the maintenance page is for service operations, not vCenter reconfiguration.
* Option D (Wait 60 minutes and Prism Central will automatically sync NDB) is incorrect because Prism Central does not automatically sync vCenter settings in NDB; manual updates are required.
This ensures seamless integration with the new vCenter instance.
References
* Nutanix Database Service (NDB) User Guide, Chapter 6: Administering an NDB Environment, Section: Updating vCenter Settings
* Nutanix Support & Insights, Knowledge Base Article: "Reconfiguring vCenter in NDB After Failure"
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 6: Administer an NDB Environment


NEW QUESTION # 61
A developer requests a new development database environment. The Era administrator identifies that there are insufficient resources on the development cluster.
Which two profiles should the administrator adjust to get the copy to fit within the resources available?
(Choose two.)

  • A. Sofware
  • B. Database Parameters
  • C. Compute
  • D. Network

Answer: B,C

Explanation:
In the context of Nutanix Database Automation (NCP-DB), when there are insufficient resources on a development cluster, the administrator can adjust the Compute and Database Parameters profiles to make the copy fit within the available resources1. The Compute profile includes settings related to CPU and memory resources, which can be adjusted to fit within the available resources. The Database Parameters profile includes settings that control the behavior and resource usage of the database, which can also be adjusted to optimize resource usage1.


NEW QUESTION # 62
An administrator needs to add a stretched VLAN across two clusters in NDB Which two prerequisites should be met prior to completing this action? (Choose two.)

  • A. VLAN must be IPAM.
  • B. Both clusters must be registered in NDB.
  • C. Nutanix Cluster Management must be enabled.
  • D. VLAN must be static.

Answer: B,D

Explanation:
A stretched VLAN is a virtual network that spans across multiple Nutanix clusters and allows the communication between VMs on different clusters using the same subnet. A stretched VLAN can be used to provide high availability and load balancing for NDB components, such as HAProxy VMs, that require a virtual IP address (VIP) to beaccessible from any cluster. To add a stretched VLAN across two clusters in NDB, the administrator needs to meet two prerequisites: the VLAN must be static and both clusters must be registered in NDB. A static VLAN is a VLAN that is manually created and configured by the administrator, as opposed to an IPAM VLAN that is automatically created and managed by NDB. A static VLAN can be added to a stretched VLAN in NDB, while an IPAM VLAN cannot. Both clusters must be registered in NDB before adding a stretched VLAN, as NDB needs to have the information and access to the clusters and their networks.
The administrator can register the clusters in NDB using the Prism Element details, agent network configuration, and storage container information. The other option, Nutanix Cluster Management, is not a prerequisite for adding a stretched VLAN in NDB. Nutanix Cluster Management is a feature that allows the administrator to manage multiple Nutanix clusters from a single NDB UI, such as creating or deleting clusters, adding or removing nodes, or performing cluster operations. Nutanix Cluster Management is not required for adding a stretched VLAN, as the VLANs are created and configured in Prism Element, not in NDB. References:
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Section 2 - Deploy and Configure an NDB Solution, Objective 2.3: Configure NDB High Availability
* Nutanix Database Management & Automation (NDMA) Course, Module 3: Nutanix Database Service (NDB) Installation and Configuration, Lesson 3.3: Configuring NDB High Availability, Topic: NDB HA Architecture and Components
* Nutanix Database Service High Availability Deployment Overview, Section: HAProxy VMs and Stretched VLANs
* [Configuring a Virtual NIC to Operate in Access or Trunk Mode - Nutanix], Section: Creating a vNIC in Access or Trunk Mode


NEW QUESTION # 63
An administrator is looking to provision a relational database management system (RDBMS) in an HA instance. Which two database engines are supported with NDB? (Choose two.)

  • A. MariaDB
  • B. PostgreSGL
  • C. MongoDB
  • D. Oracle

Answer: B,D

Explanation:
Nutanix Database Service (NDB) supports high availability (HA) instances for certain relational database management systems (RDBMS). Among the listed options, NDB natively supports Oracle and PostgreSQL for HA configurations, enabling features like replication and failover. These databases are well-integrated with NDB's Time Machine and HA frameworks.
* Option A (MongoDB) is incorrect because MongoDB is a NoSQL database, not an RDBMS, and is not supported for HA instances in NDB.
* Option B (MariaDB) is incorrect because, while MariaDB is an RDBMS, it is not currently supported for HA instances in NDB v6.10.
* Option C (Oracle) is correct as NDB supports Oracle in HA mode with features like Data Guard integration.
* Option D (PostgreSQL) is correct as NDB supports PostgreSQL HA with streaming replication.
Note: The typo "PostgreSGL" in the question is assumed to mean "PostgreSQL" based on context.
References
* Nutanix Database Service (NDB) User Guide, Chapter 4: Managing Database Engines, Section:
Supported RDBMS for HA
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 4: Manage Database Engines


NEW QUESTION # 64
An administrator needs to reset the NDB GUI password.
What should the administrator perform from the SSH session?

  • A. sudo passwd admin
  • B. 1.Enter the era CLl
    2.Execute: security password reset
  • C. sudo passwd era
  • D. 1. Enter the era-server CLl
    2. Execute: security password reset

Answer: D

Explanation:
To reset the NDB GUI password in Nutanix Database Service (NDB), an administrator must access the system through an SSH session and use the appropriate command-line interface (CLI) tools provided by NDB. The correct process involves entering the era-server CLI, which is the specific CLI environment for managing NDB-related configurations, including security settings like password resets. Once in the era-server CLI, the administrator executes the security password reset command to initiate the password reset process for the NDB GUI. This method ensures that the reset is performed within the NDB-managed environment securely and aligns with Nutanix's recommended administrative procedures.
* Option A is correct because it specifies the era-server CLI and the exact command security password reset, which are consistent with NDB's administrative tools for managing GUI access credentials.
* Option B (sudo passwd era) is incorrect because era is not a system user account in the context of NDB's Linux-based control plane; this command pertains to standard Linux user management, not NDB-specific GUI password resets.
* Option C (sudo passwd admin) is also incorrect as admin refers to a generic user that may not correspond to the NDB GUI account, and this approach bypasses NDB's internal security mechanisms.
* Option D is incorrect due to a typo (era CLI instead of era-server CLI), which renders it imprecise despite the intent being similar to Option A.
This process assumes the administrator has SSH access to the NDB control plane VM and the necessary privileges to execute these commands.
References
* Nutanix Database Service (NDB) User Guide, Section: Administering an NDB Environment, Subsection: Managing Access Controls and Password Resets
* Nutanix Support & Insights, Knowledge Base Article: "Resetting NDB GUI Password via CLI"
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 6: Administer an NDB Environment


NEW QUESTION # 65

An administrator is attempting to take a manual snapshot of a database in ND8 on an AHV cluster. There are multiple Nutanix clusters in this environment and the administrator would like to replicate the snapshot to one of the remote clusters. When attempting to take the snapshot, only a single cluster appears, as shown in the exhibit.
What is the most likely reason that only a single cluster is shown?

  • A. NDB Multi-cluster has not been enabled.
  • B. The remote clusters are running ESXi.
  • C. The snapshot will be too big to replicate to a remote cluster.
  • D. The remote clusters have an older version of AOS installed.

Answer: A

Explanation:
The exhibit shows the "Create Snapshot" interface in NDB, where the administrator can select Nutanix clusters where the snapshot should be made available. However, only a single cluster appears despite multiple clusters in the environment. The most likely reason is that NDB Multi-cluster has not been enabled. Multi- cluster support in NDB requires explicit configuration to enable snapshot replication and data availability across remote clusters (e.g., via Prism Central and network profiles). Without this, NDB restricts snapshot operations to the local cluster where the database resides.
Other options are less likely:
* A. The remote clusters are running ESXi: NDB supports ESXi clusters, so this alone wouldn't limit visibility unless multi-cluster is disabled.
* B. The snapshot will be too big to replicate to a remote cluster: Size is a consideration during replication, but it doesn't prevent cluster visibility in the UI.
* D. The remote clusters have an older version of AOS installed: Version compatibility might affect replication, but it wouldn't hide clusters from the list unless multi-cluster setup is incomplete.
Thus, the verified answer is C, pointing to the need for multi-cluster configuration.
Official Nutanix Database Automation References
* Nutanix Database Management & Automation (NDMA) course, Module 4: High Availability and Disaster Recovery, Lesson 4.2: Configuring Multi-Cluster HA.
* Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section
4: Troubleshoot NDB Solutions, Objective 4.3: Configure HA Across Clusters (applicable to v6.10).
* Nutanix NDB Administration Guide: "Enabling Multi-Cluster Snapshot Replication" section.


NEW QUESTION # 66
......

Full NCP-DB Practice Test and 253 Unique Questions, Get it Now!: https://www.examprepaway.com/Nutanix/braindumps.NCP-DB.ete.file.html

Best Value Available Preparation Guide for NCP-DB Exam: https://drive.google.com/open?id=1YM6oetqoIDO1iB2OtlxLi5JlBcLnVFW2