NCP-DB practice question 12 of 35

A quality assurance team noticed a significant change between a cloned database they are currently using versus the one used one week ago. They created an SQL script to verify the differences. Which task should be performed by an NDB administrator to provide the correct database to the QA team?

Full set: 251 questions
Answer options
A: Replicate a selected snapshot.
B: Create a clone database from a snapshot.
C: Clone database selecting Point in Time data. Correct answer
D: Perform a Log Catch Up operation.
Correct Answer:
C. Clone database selecting Point in Time data.
Explanation

NDB's Time Machine feature enables Point-in-Time Recovery (PITR) by capturing snapshots and continuous transaction logs. To fulfill the QA team's request for a database as it existed at a specific time one week ago, the administrator should use the cloning feature. The clone operation allows the selection of a specific date and time. NDB then uses the closest preceding snapshot and rolls the transaction logs forward to that exact moment, creating a new, fully functional database clone that precisely matches the state of the source database at the requested time.

Why Incorrect

A. Replicating a snapshot sends a copy of the backup to a remote NDB instance; it does not create a usable database for local testing.
B. Creating a clone from a snapshot is less precise, as it restores the database only to the exact moment the snapshot was taken, not any point in between.
D. A Log Catch Up operation is part of the backup process that updates the Time Machine with the latest logs from the source database, not a restore or cloning function.

References

1. Nutanix Database Service (NDB) 2.5 User Guide, "Database Cloning Management" section, "Cloning a Database" subsection. The guide details the cloning workflow, which includes the step: "In the Time Machine tab, select a point in time from which you want to create the clone."

2. Nutanix Database Service (NDB) Architecture Guide, "Time Machine" section. This section explains that the combination of snapshots and log collection allows for recovery to any specific point in time, which is the technology leveraged by the point-in-time cloning feature.

Scroll to Top