Nutanix Certified Professional - Database Automation (NCP-DB v6.10)
Last Update Oct 15, 2025
Total Questions : 251
We are offering FREE NCP-DB Nutanix exam questions. All you do is to just go and sign up. Give your details, prepare NCP-DB free exam questions and then go for complete pool of Nutanix Certified Professional - Database Automation (NCP-DB v6.10) test questions that will help you more.
A database administrator wants to clone an SQL database that has Transparent Data Encryption (TDE) enabled.
Which two steps must be taken on the target server for this clone to be successful? (Choose two.)
What must be configured in Prism Element to allow the NDB server and CVMs to facilitate iSCSI connections?
An administrator needs to distribute NDB management plane components.
Which NDB HA VM needs to be deployed on the same L2 network?
An administrator tried to provision Nutanix Database Service (NDB) from Prism Central Marketplace and is getting the error shown in the exhibit.
Which action would have prevented this issue?
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 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 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 database is de-registered without removing the associated Time Machine. What is the status of the Time Machine?
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?
Within NDB, an administrator needs to register a PostgreSQL database server VM with a database.
Where should the database data and log files be located in order to successfully complete this task?
What is the first step to add Time Machine (TM) data access to a Nutanix cluster?
An administrator wants to test the provisioning capabilities after a new NDB deployment. Which database instance would be available to accomplish this task?
When trying to restore a database via Time Machine (TM), the option to restore data to a Point in Time is not available.
What should the administrator do to enable Point in Time Recovery?
What is the terminology used for registering an existing database with Era?
While adding Time Machine data access to a Nutanix cluster, when is a storage container mapping needed
Why would an administrator want to publish a software profile update for Microsoft SQL Server that is created in NDB?
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?
An administrator begins an SQL database clone deletion, but notices it fails almost immediately.
What could be the cause of this failure?
An administrator selected Bronze SLA for Era Time Machine during database registration.
Which two capabilities are supported by the Time Machine for this database? (Choose two,)
When an Oracle database is upgraded using Era, what is the type of upgrade category?
An administrator needs to remove the default administrative account in use for NDB operations.
What is the recommended role for the Prism Element user to register a Nutanix cluster?
What is required to create an NDB Software Profile Version for PostgreSQL?
What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?
What feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration?
A database administrator logged into their NDB dashboard notices the Savings over traditional cloning metric in the Data Usage widget.
What does this number represent?
Refer to the exhibit.
A request is received to provision a new Oracle SIHA DB & VM to test ASMLIB on OEL79 and Oracle 19c. When walking through the provisioning workflow, only ASMFD is available in the ASM Driver drop down.
What is necessary to provision the requested SIHA DB and DB VM with ASMLIB?
When the NDB upgrade includes updates to the out-of-the-box (OOB) software profiles, what happens to older OOB software profile versions when upgrading NDB?
A DBA executed a script which corrupted an Oracle DB managed by NDB. After few minutes, the NDB administrator has been asked to create a copy of the DB using the latest available snapshot.
Which actions should be taken?
An administrator needs to patch an Oracle Database Server VM and must ensure Grid home is allocated sufficient storage space.
At a minimum, how much space must be available for Grid home prior to completing this task?
When running the Linux prerequisites script, an administrator discovers that the only required argument is -t.
What does the -t argument specify?
An administrator needs to enable multi-cluster to setup NDB HA.
What should the administrator configure for the NDB Agent to satisfy this requirement?
What two reference resources are available for Nutanix Era APIs? (Choose two.)
What are two supported entities that metadata tags can be applied to? (Choose two.)
An administrator is creating a Windows Domain profile in Era.
Which optional field can be skipped and provided during the provisioning process?
An NDB administrator is looking to free up some space consumption in the container that NDB uses to manage a database landscape.
Where are two of the best locations within NDB that the administrator could view to see where the most storage is being consumed, in order to research for reclamation? (Choose two.)
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?
An NDB environment has been deployed with three Nutanix clusters. An administrator has been asked to create a Microsoft SQL Server software profile for each of these clusters.
Which is a requirement to create the above-mentioned profiles?
An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown below:
• SQLAGNI\EMR
• SQLAGN2\EMR
• SQLAGN3\DW
SQLAGN3\DW is running the Analytics service that needs real-time data.
How should the administrator register the database in Era?
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
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?
When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore
Location as New Location?
What are two status values that can be set within the Alerts Dashboard? (Choose two.)
An administrator is attempting to enable high availability (HA) for NDB across three Nutanix clusters located in separate data centers. If the network latency between two clusters exceeds 25ms RTT, what impact might this have on the NDB HA setup?
Within the NDB GUI, an administrator needs to set the shortest schedule interval possible for a database log catch up.
Which value, in minutes, will satisfy this requirement?
An administrator needs to register a SQL Server Single Node Database Server VM with NDB.
Which condition must exist prior to the administrator completing this task?
An administrator needs to restore a source database from a snapshot. The database shares the source volume with multiple other databases.
How does NDB handle this database restore operation?
An administrator needs to deploy a database resilient cluster engine across three clusters. Which database engine can be used for this scenario?
Nutanix NDB gives an administrator the ability to create highly-available database pairs with which two databases? (Choose two.)
An administrator has been tasked with OS and database patching in a Nutanix NDB environment. The administrator wishes to automate these activities.
What should the administrator configure to accomplish this task?
Which policies define Time Machine data availability across multiple registered clusters in NDB?
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)
An administrator has configured NDB HA across multiple Nutanix clusters.
Which failure scenario will require manual interaction for the recovery?
A user wants to apply the latest OS security patches on a Windows server.
How should the user accomplish this task?
An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are shared with multiple databases.
Which restore method is supported?
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?
A new administrator is tasked with changing the NDB GUI password via CLl.
Which command will accomplish this task?
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?
A request is received to refresh a database clone from a new manual snapshot. When the administrator attempts to create the new snapshot from the Time Machine, it is in a Frozen state.
What causes a Time Machine to enter the Frozen state and what are the administrator's options to complete the request?
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?
When provisioning Microsoft SQL Server utilizing database groups, which statement is true?
An administrator has opened the Enable Multi-Cluster configuration for an NDB instance, but the wizard does not present the VLAN, as shown in the exhibit.
Which configuration allows to choose a VLAN in the drop-down box?
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?
An administrator needs to restore databases provisioned with a shared disk configuration on Windows Storage Spaces What happens when NDB runs the restore operation?
An administrator is tasked with auditing NDB SLAs. What data will the administrator be reviewing?
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?