NCP-DB-6.10 · Question #243
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…
The correct answer is C. Restore using point in time till 10:42pm. 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 logs. By restoring using point in time…
Question
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?
Options
- ARestore the 10:42pm snapshot.
- BRestore using point in time till 10:41pm.
- CRestore using point in time till 10:42pm.
- DRestore the 10:30pm snapshot.
How the community answered
(28 responses)- A7% (2)
- B25% (7)
- C57% (16)
- D11% (3)
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 logs. 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 amount. 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.
Topics
Community Discussion
No community discussion yet for this question.