New Nutanix NCP-DB Dumps & Questions Updated on 2025 [Q38-Q52]

NEW QUESTION 38
An administrator needs to add multiple databases to an existing PostgreSQL instance.
How should the administrator satisfy this requirement?

Modify parameter profile using ncli.

Modify parameter profile using the GUI.

Modify parameter profile using post script.

Modify parameter profile using NDB CLI.

NEW QUESTION 39
What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?

It is patched last and is restored to its original state.

It becomes a read-only member during the patching process.

It is skipped during the patching process to ensure no downtime.

It is patched first and then becomes a secondary member.

NEW QUESTION 40
An administrator originally configured the storage for an Oracle database running on Nutanix NDB using ASMLib. The administrator would like to scale the size of the database.
What should the administrator do to most efficiently increase the size of the database?

Leverage the scaling ability built into NDB to resize existing vDisks.

Extend the size by adding new vDisks.

Create a new. larger database and migrate.

Mount an iSCSI LUN and extend the database onto the new LUN.

NEW QUESTION 41
An administrator would like to leverage the Oracle restore feature within NDB for a RAC database.
Prior to the restoration operation, what must the administrator do?

Ensure the database is in a Down state.

Ensure the database is registered with NDB.

Ensure the database is in an Up state.

Ensure more than one node of the RAC is reachable.

NEW QUESTION 42
A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.
What type of profile would be used?

Software Profile Version

Network

Compute

Database Parameters

The database parameters profile is used to define the initialization variables for different types of database engines and workloads, such as OLTP and DW. The database parameters profile allows the database administrator to customize the configuration settings for each database engine, such as Oracle, SQL Server, PostgreSQL, and MySQL. The database parameters profile can also be applied to different database operations, such as provisioning, cloning, and patching. The database parameters profile helps to optimize the performance and functionality of the databases according to the specific requirements and best practices of each database engine and workload.
The software profile version is used to define the software version and edition for each database engine, such as Oracle 19c Enterprise Edition or SQL Server 2019 Standard Edition. The software profile version is required for provisioning new databases and patching existing databases. The software profile version helps to ensure the compatibility and compliance of the databases with the supported software versions and editions.
The network profile is used to define the network configuration and security settings for the database server VMs and the databases, such as the IP address, subnet mask, gateway, DNS, firewall rules, and SSL certificates. The network profile is required for registering new database server VMs and provisioning new databases. The network profile helps to ensure the connectivity and protection of the database server VMs and the databases within the network environment.
The compute profile is used to define the compute resources and storage policies for the database server VMs and the databases, such as the CPU, memory, disk size, disk type, compression, deduplication, and replication factor. The compute profile is required for provisioning new databases and cloning existing databases. The compute profile helps to ensure the availability and efficiency of the database server VMs and the databases within the Nutanix cluster.
References:
* Nutanix Database Management & Automation Training Course, Module 4: Nutanix Era Configuration, Lesson 4.1: Nutanix Era Configuration, slides 6-9.
* Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.1: Nutanix Era Operations, slides 5-8, 11-12, 15-16.

NEW QUESTION 43
In an Oracle upgrade scenario using Era. if the source database is on a nor-Nutanix platform, is it possible to upgrade it with an Era workflow?

Yes, it is possible to upgrade database instance on a non-Nutanix platform.

Yes, only if the nan-Nutanix platform is big-endian platform,

No, the database instaru:e must be Era managed to Be upgraded

Yes, only if the nori-Nutanix platform is little-endian platform.

NEW QUESTION 44
How can NDB updates be downloaded for a dark site?

Download the upgrade bundle from the Nutanix Support portal and manually upload it to the NDB server.

Go into the Administrator > Maintenance section in NDB and download the most recent version.

Change the network that NDB is hosted on so it has access to https://download.nutanix.com.

Download the upgrade bundle from the Nutanix support Portal and upload it to Prism Element > Images

NEW QUESTION 45
An administrator created an NDB managed VLAN called PGSQLVLAN40 After deploying PostgreSQL HA, it was noticed that the databases were able to communicate with everything on VLAN 40 only.
What can the administrator do to fix the current issue and going forward?

Use VLAN 1 for the PostgreSQL deployment.

Change the Default Gateway on the PostgreSQL servers and update NDB for VLAN PGSQLVLAN40.

Engage the networking team as this is a network related issue.

Delete the data base servers, VLAN name PGSQLVLAN40 and redeploy the same information under a different VLAN name.

The scenario describes a PostgreSQL HA deployment managed by NDB, where an NDB-managed VLAN (PGSQLVLAN40) restricts database communication to only within VLAN 40. This indicates a network isolation issue, likely due to VLAN segmentation or routing misconfiguration, preventing communication with external networks or other VLANs. Since NDB manages the VLAN and assigns it to the database VMs, the issue lies beyond NDB’s direct control and involves the underlying network infrastructure (e.g., switches, routers, or Prism Element network settings).
Here’s why the other options are insufficient:
* A. Use VLAN 1: VLAN 1 is typically a default VLAN and not recommended for production use due to security and isolation concerns. Changing to VLAN 1 does not address the root cause and could introduce further issues.
* B. Change the Default Gateway on the PostgreSQL servers and update NDB: While adjusting the default gateway might enable external communication, this is a workaround rather than a fix. NDB manages the network configuration, and manual changes could be overwritten or cause inconsistency.
The root issue (VLAN routing) remains unaddressed.
* D. Delete the database servers, VLAN name PGSQLVLAN40, and redeploy: This is overly disruptive and unnecessary, as recreating everything under a new VLAN name does not guarantee resolution unless the network configuration is corrected.
The best approach is to engage the networking team to investigate and resolve the issue, such as configuring inter-VLAN routing, updating firewall rules, or adjusting the default gateway at the network level. Going forward, the administrator should collaborate with the networking team during VLAN planning to ensure proper connectivity. Thus, the verified answer is C.
Official Nutanix Database Automation References
* Nutanix Database Management & Automation (NDMA) course, Module 4: Troubleshooting NDB, Lesson 4.1: Identifying and Resolving Network Issues.
* Nutanix Certified Professional – Database Automation (NCP-DB) v6.5 Knowledge Objectives, Section
4: Troubleshoot NDB Solutions, Objective 4.2: Resolve Network-Related Issues (applicable to v6.10).
* Nutanix NDB Administration Guide: “Networking Considerations for HA Deployments” section.

NEW QUESTION 46
An administrator is interested in using profiles to simplify the database provisioning process. The profile needs to include information related to the SQL service startup account, and the NDB worker service account.
Which profile would help the administrator accomplish this task?

Windows Domain

Network

Database Parameter

Software

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

Recovery Plans

Data Access Management

Data Protection

Service Level Agreements

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

NEW QUESTION 48
Where are two locations an administrator would find the size of a Source Database? (Choose two.)

On the Era Dashboard Database Summary Table under Source Database.

Under the Capacity widget on the Database Server VMS > List database summary page.

On the Databases > Sources table.

On the Profiles > Database Parameters list for the assigned DB Parameter Profile.

NEW QUESTION 49
A DBA team needs to release PostgreSQL HA instances using a dedicated subnet.
Which action is mandatory before creating the network profile?

The subnet in Prism Element must be iPAM configured.

The DB VMs must be registered first.

A VLAN must be added to NDB networks.

Configure Network Segmentation.

NEW QUESTION 50
What is the terminology used for registering an existing database with Era?

Greenfield Database

Brownfield Database

Cloned Database

Source Database

NEW QUESTION 51
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?

Assign additional backup VMs within the same host to maintain service.

Increase the number of affinity zones within the cluster

Configure automatic host failover in Prism Central.

Set anti-affinity rules to spread VMs across multiple nodes dynamically.

NEW QUESTION 52
An administrator needs to work with databases and time machines, but not database parameter profiles.
Which role satisfies this requirement?

Database Administrator (DBA)

super Administrator

Database Infrastructure Administrator

Infrastructure Administrator