Nutanix NCP-DB Practice Questions

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. Page

B. System

C. Database

D. Backup

A. Page

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 should be 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.

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

A. Greenfield Database

B. Brownfield Database

C. Cloned Database

D. Source Database

B. Brownfield Database

Explanation:
In the context of Nutanix Era, the term “Brownfield Database” is used to refer to an existing database that is registered with Era1. This process allows Era to bring Database as a Service (DBaaS) capabilities to your existing database2. It’s important to note that before you register a database with Era, certain prerequisites must be met3.

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?

A. Database files must exist in the Windows OS boot drive.

B. The login account provided must be a member of the sysadmin role.

C. The SQL service account should not have read privileges on the mount points.

D. SQL Server instance must be in single-user mode.

B. The login account provided must be a member of the sysadmin role.

Explanation:
Before registering a SQL Server Single Node Database Server VM with NDB, it is necessary that the login account provided for this task must be a member of the sysadmin role. This ensures the necessary permissions are in place for managing and administering the SQL Server instance.
References: Nutanix Database Automation documentation, under SQL Server database registration and permission requirements.

An administrator has been tasked with restoring an Oracle database that has recently failed. The administrator must restore the database to the prior day's state. Which two restore options could be used? (Choose two.)

A. Most Recent Time Available

B. Snapshot

C. Tail Logs Backup

D. Point in Time

B. Snapshot

D. Point in Time

Explanation:
The correct answer is B and D because they are the two restore options that can be used to restore an Oracle database to the prior day’s state using Nutanix Era. A snapshot is a point-in-time copy of a database that is stored in the Era Time Machine, which is a distributed file system that collects logs and snapshots from databases. A point in time is a specific moment in time within the retention period of the SLA policy that is applied to the database. By using either of these options, the administrator can select the snapshot or the point in time that corresponds to the prior day’s state and restore the database from it. The other options are not correct because they are not restore options that are available in Nutanix Era. Option A is not correct because Most Recent Time Available is not a restore option, but a clone option that creates a clone of the database from the most recent snapshot or log backup. Option C is not correct because Tail Logs Backup is not a restore option, but a backup option that captures the transaction logs of the database that have not been backed up by the SLA policy.

An administrator needs to migrate a large 1/0-intensive database that doesn't support multi-disk layout. How should the storage be provisioned with Era to support the database while optimizing performance?

A. Volume Group

B. Volume Group with Load Balancing

C. Storage Spaces

D. vDisk based provisioning

A. Volume Group

Explanation:
In Nutanix Era, a Volume Group is the recommended storage provisioning method for a large I/O-intensive database that doesn’t support a multi-disk layout1. A Volume Group in Nutanix Era is a collection of disks that can be managed as a single entity, providing a way to aggregate the storage capacity of multiple disks into a larger storage unit1. This allows for better performance optimization as it enables the database to leverage the combined I/O capabilities of all the disks in the group1. It’s important to note that while other options like Load Balancing, Storage Spaces, and vDisk based provisioning can also be used in certain scenarios, a Volume Group is specifically designed for situations where a single, high-performance storage unit is required1.

What does a Time Machine frozen status indicate?

A. The database is paused on the database VM.

B. The database was de-registered from NDB without removing the associated time machine.

C. The NDB agent is stopped on the database VM.

D. The Time Machine is paused and all automatic snapshot and log catch-up activities are halted.

B. The database was de-registered from NDB without removing the associated time machine.

Explanation:
A Time Machine frozen status indicates that the database that was associated with the Time Machine has been de-registered from NDB, but the Time Machine itself has not been deleted. This means that the Time Machine still contains the snapshots and logs of the de-registered database, but it cannot perform any further operations on it. To resume the normal functioning of the Time Machine, the administrator can either re-register the database with NDB, or delete the Time Machine and free up the storage space.