Nutanix Certified Professional - Database Automation (NCP-DB)
Last Update May 9, 2024
Total Questions : 146
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) test questions that will help you more.
An administrator has a production PostgreSQL database cloned for development and testing purpose. A new table is added to the source database.
What should the administrator do to publish the update leveraging the point in Time Era capability?
(C) 1. PeHorm a Log Catch-up using source database Time Mechine
2. Refresh the clone database
(C) l. Perform a Log Catch-up using source database Time Mechine
2. Refresh the source database
(C) l. update Log Catch-up interval from Tme Machine
2. Refresh the source database
C) 1. Update Log Catch-up interval from Tame Machine
2. Refresh the clone database
How is the size of a database time machine defined?
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 change the maximum number of database connections during the cloning workflow.
Which Era profile should the administrator choose?
How can an administrator exclude Kernel patches for the Linux OS using the most efficient means?
Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?
An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?
When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore
Location as New Location?
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?
An administrator has configured NDB HA across multiple Nutanix clusters.
Which failure scenario will require manual interaction for the recovery?
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?
Era allows custom metadata to be assigned to entities (clones, time machines, databases, and database servers) by using which component?
What are two of the required steps to provision a new network in Clusters and extend it to Era? (Choose two.)
A developer with RBAC privileges in Era needs to refresh an existing DB Clone.
What steps must the developer take to perform the refresh?
An administrator needs to distribute NDB management plane components.
Which NDB HA VM needs to be deployed on the same L2 network?
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?
Which ports must be open between the NDB server and Controller VMs to facilitate iSCSI connections?
An administrator has created a new SQL Server software profile version to apply the latest cumulative update.
What should the administrator do to make it available to all users?
An administrator would like to replicate database snapshots to remote Nutanix clusters.
What should the administrator do to manage Time Machine data availability across all registered Nutanix clusters in NDB?
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?
An administrator needs to create a custom PostgreSQL HA software profile.
Which software component manages the state of the cluster and handles failover?
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?
What is the first step to add Time Machine (TM) data access to a Nutanix cluster?
An administrator is adding a stretched VLAN in NDB.
Which VLAN type(s) will satisfy this task?
What is used to temporarily store the transaction logs of the source database before they are copied to the log?
An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.
How should the administrator best complete this task?
What feature of Era allows an administrator to create Time Machine policies in a Multi-Cluster configuration?
Which command can be used to assign a static IP address to the Era VM on ESXi?
set
era-server > era
era-server >
An administrator is trying to register an Oracle Database Server VM to Era.
Which dependency must be met?
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?
An administrator needs to roll back an Oracle patch on a database server VM using NDB. What is required for this action to be successful?
Where should an administrator perform an upgrade within the Era management interface?
A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version.
What should the database admin do?
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)
In NDB, which two Time Machine options are available when creating a database clone? {Choose two.)
What is the most efficient way to get information on REST APIs for a task in Era?
Which Time Machine feature allows developers to automate the data refresh for their clones?
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?
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?
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,)