Nutanix NCP-DB Practice Questions

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 and attach the July 31st backup from Time Machine.

B. Restore a backup from July 31st, Recover the database to bring the database up.

C. Provision a database, restore the backup from Ju)' 31st, and Recover the database to bring the database up.

D. Create a clone from July 31st snapshot in Time Machine.

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.

Which two ports can be used by external applications to make API calls to Era? (Choose two.)

A. 9443

B. 443

C. 8443

D. 9440

B. 443

D. 9440

Explanation:
Nutanix Era is a database management system that provides API endpoints for automation and integration with external applications. These API calls are typically made over HTTPS for security, and the standard ports for HTTPS are 443 and 94401. Please note that the actual ports used can depend on the specific configuration of the Nutanix Era system. It’s always a good idea to check the system’s documentation or consult with the system administrator for the most accurate information.

An administrator has received a request to clone a source production database to an existing development server. Which two actions must be taken to complete this task?

A. The development server must be registered by Era in order to receive the clone.

B. The development server must be registered by Era and authorized to host clones from the Time Machine.

C. The development server must be authorized for the database Time Machine.

D. The development server must have the IP and credentials provided during cloning.

A. The development server must be registered by Era in order to receive the clone.

D. The development server must have the IP and credentials provided during cloning.

Explanation:
According to the Nutanix Database Automation (NCP-DB) Learning documents12, to clone a source production database to an existing development server, the following actions must be taken:
A. The development server must be registered by Era in order to receive the clone1. This is because Nutanix Era is a database management tool that manages the lifecycle of databases and their copies. Registering the development server with Era allows it to manage the database on that server.
D. The development server must have the IP and credentials provided during cloning2. This is necessary for Era to access the development server and perform the cloning operation. The IP address and credentials are used to establish a connection to the development server. Without these details, Era would not be able to access the server and perform the cloning operation.

What is required to cre110ate a network profile in Era?

A. The network must contain static IP addresses.

B. The network must be added to Era.

C. The network must be managed by Era.

D. The network must provide IP address management.

B. The network must be added to Era.

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to create a network profile in Era, the network must be added to Era1. This is because Era needs to have control over the network in order to manage the databases effectively1. Once the network is added to Era, it can be used for various operations such as provisioning new databases, managing existing databases, and more1.

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?

A. Use an SLA that supports Continuous Log retention.

B. Update the TM schedule to perform DB Log catch up.

C. Take a Manual snapshot and use it for DB recovery.

D. Use Brass SLA & update the Log catch up frequency.

A. Use an SLA that supports Continuous Log retention.

Explanation:
Point in Time Recovery (PITR) is a feature of NDB that allows restoring a database to any point in time within the retention period of the SLA. To enable PITR, the SLA must support Continuous Log retention, which means that NDB captures and stores the database logs continuously. This allows NDB to replay the logs from the last snapshot to the desired point in time during the restore process. The other options do not enable PITR, but rather affect the frequency and timing of the snapshots and log catch up operations.

An administrator has applied an Oracle security patch to a database server VM registered in Era. How do you make this change available to other existing database instances?

A. Register the VM as a have' database server VM and then create a software profile using this newly registered VIVI.

B. Create a n.. software profile version from the patched VM.

C. Merge the changes into an existing software profile.

D. Create a new software profile in Era from the patched VM.

Explanation:
Nutanix Database Service (NDB) uses software profiles for database patching to keep your databases secure and optimized1. When a new database is provisioned, it will be on your current environment’s database version to maintain consistency and stop version sprawl1. Therefore, after an administrator has applied an Oracle security patch to a database server VM registered in Era, the change can be made available to other existing database instances by creating a new software profile in Era from the patched VM1.