A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.
The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes.
The last available snapshot is at 10:30pm.
What is the optimal path to restore the table back with minimum data loss?
- Restore the 10:42pm snapshot.
- Restore using point in time till 10:41pm.
- Restore using point in time till 10:42pm.
- Restore the 10:30pm snapshot.
Answer(s): C
Explanation:
The optimal path to restore the table back with minimum data loss is to use the point in time restore feature of NDB, which allows the administrator to restore the database to a specific point in time based on the available snapshots and logs1. By restoring using point in time till 10:42pm, the administrator can recover the table just before it was dropped by the user, and minimize the data loss to the least possible amount1. The other options are not optimal, as they either involve restoring an older snapshot, which may result in more data loss, or restoring a non-existent snapshot, which is not possible.
Reference:
1: Nutanix Database Automation (NCP-DB) course, Module 6: Database Recovery, Lesson 6.2: Point in Time Restore, slide 5
Reveal Solution Next Question