Nutanix NCP-DB Practice Questions

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?

A. • Continuous log retention (days): 7
• Daily snapshot retention (days): 5

B. • Continuous log retention (days): 5
• Weekly snapshot retention (weeks): 1

C. • Weekly snapshot retention (weeks): 1
• Continuous log retention (days): 7

D. • Daily snapshot retention (days): 7
• Continuous log retention (days): 5

Explanation:
The correct answer is D because it meets the requirements of maintaining five days of time-travel capability to any second and an additional seven days of discrete recovery at a daily interval. Continuous log retention allows the administrator to restore the database to any point in time within the specified number of days, while snapshot retention allows the administrator to restore the database to a specific point in time at a fixed interval. Therefore, by setting the daily snapshot retention to 7 days, the administrator can ensure that there is a discrete recovery point for each day of the week. By setting the continuous log retention to 5 days, the administrator can ensure that there is a time-travel capability to any second within the last five days. The other options do not meet the requirements because they either have less than five days of continuous log retention or less than seven days of snapshot retention.

Which Era component collects logs and snapshots from the database?

A. Profiles

B. Era Database Agent

C. SLAs

D. Time Machine

Explanation:
The Era copy data management service includes several components, one of which is the Time Machine. The Time Machine is responsible for collecting logs and snapshots from the database123. This functionality allows for granular clone and refresh operations, making it a crucial part of the Nutanix Era’s database as a service (DBaaS) solution1.

What is purpose of the NDB Database Agent service?

A. Temporarily stores the transaction logs.

B. Hosts one or more source databases for the same time machine.

C. Schedules and monitors the NDB-related operations.

D. Contains an instance of the database engine software.

C. Schedules and monitors the NDB-related operations.

Explanation:
The correct answer is C because the NDB Database Agent service is responsible for scheduling and monitoring the NDB-related operations, such as provisioning, patching, cloning, and restoring databases. The NDB Database Agent service is deployed on the NDB server and on each of the database server VMs provisioned by NDB. It contains the tools required to perform each task and communicates with the NDB server through the NDB API. The other options are not correct because they describe different components or functions of the NDB solution. Option A is not correct because the transaction logs are not stored by the NDB Database Agent service, but by the NDB Time Machine service, which is a distributed file system that stores the database snapshots and logs. Option B is not correct because the source databases are not hosted by the NDB Database Agent service, but by the database server VMs, which are virtual machines that contain an instance of the database engine software and the database files. Option D is not correct because the NDB Database Agent service does not contain an instance of the database engine software, but only the tools required to perform the NDB-related operations. The database engine software is installed on the database server VMs, which are provisioned by NDB using the profiles defined by the administrator.

An administrator needs to add a stretched VLAN across two clusters in NDB. Which two prerequisites should be met prior to completing this action? (Choose two.)

A. VLAN must be IPAM.

B. VLAN must be static.

C. Both clusters must be registered in NDB.

D. Nutanix Cluster Management must be enabled.

B. VLAN must be static.

C. Both clusters must be registered in NDB.

Explanation:
A stretched VLAN is a virtual network that spans across multiple Nutanix clusters and allows the communication between VMs on different clusters using the same subnet. A stretched VLAN can be used to provide high availability and load balancing for NDB components, such as HAProxy VMs, that require a virtual IP address (VIP) to be accessible from any cluster. To add a stretched VLAN across two clusters in NDB, the administrator needs to meet two prerequisites: the VLAN must be static and both clusters must be registered in NDB. A static VLAN is a VLAN that is manually created and configured by the administrator, as opposed to an IPAM VLAN that is automatically created and managed by NDB. A static VLAN can be added to a stretched VLAN in NDB, while an IPAM VLAN cannot. Both clusters must be registered in NDB before adding a stretched VLAN, as NDB needs to have the information and access to the clusters and their networks. The administrator can register the clusters in NDB using the Prism Element details, agent network configuration, and storage container information. The other option, Nutanix Cluster Management, is not a prerequisite for adding a stretched VLAN in NDB. Nutanix Cluster Management is a feature that allows the administrator to manage multiple Nutanix clusters from a single NDB UI, such as creating or deleting clusters, adding or removing nodes, or performing cluster operations. Nutanix Cluster Management is not required for adding a stretched VLAN, as the VLANs are created and configured in Prism Element, not in NDB.

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.

A developer with RBAC privileges in Era needs to refresh an existing DB Clone. What steps must the developer take to perform the refresh?

A. Navigate to Databases > Sources, Select the appropriate Database from the table and Refresh Clone from the Database Actions menu.

B. Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh

C. Navigate to Time Machines Select the appropriate Database Time Machine from the table end Refresh Clone from the Actions menu.

D. Navigate to Databases > Clones, Select the appropriate clone from the table, choose

B. Navigate to Databases > Clones, Select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot and click Refresh

Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, to refresh an existing DB Clone, a developer with RBAC privileges in Era needs to navigate to Databases > Clones. From there, they select the appropriate clone from the table, click Refresh, select the desired Point In Time or Snapshot, and then click Refresh12. This process allows the developer to update the cloned database3.