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 questionsNDB'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.
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.
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.
Keep practicing
Take the free NCP-DB practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other NCP-DB practice questions
- Question 1Which file type must be downloaded from the Nutanix Portal for NDB deployment?
- Question 2An administrator changed NDB language settings from English to Spanish, but when accessin…
- Question 3An administrator is experiencing issues with NDB and some of its operations. A case has b…
- Question 4An administrator enables NDB Multi-cluster. Which NDB Service component is deployed on a …
- Question 5Because of a cost reduction program, many Microsoft SQL server instances will be consolid…
- Question 6An administrator configures VM Host Affinity for database server VMs on a Nutanix AHV-pow…
