ExamGecko
Question list
Search
Search

Related questions

Question 84 - NCP-DB-6.5 discussion

Report
Export

An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore time and minimize data loss.

What option should the administrator do to achieve this objective?

A.
Perform Restore Source Database by selecting Restore time just before the database crash.
Answers
A.
Perform Restore Source Database by selecting Restore time just before the database crash.
B.
Perform Restore Source Database by selecting most recent and include Tail log Backup
Answers
B.
Perform Restore Source Database by selecting most recent and include Tail log Backup
C.
Perform Restore Source Database by selecting the available snapshot.
Answers
C.
Perform Restore Source Database by selecting the available snapshot.
D.
Perform Restore Source Database by selecting the current time.
Answers
D.
Perform Restore Source Database by selecting the current time.
Suggested answer: B

Explanation:

Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup.In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup12.

The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss.By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered12.This approach aligns with the Nutanix Era's capabilities and best practices for database recovery12.

asked 23/09/2024
Pablo Hilario
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first