Restore Deleted Databases Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Backup and Restore

Restore Deleted Databases Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which of the following is the first step you should take immediately after discovering a production database has been accidentally deleted?

  2. 2

    When restoring a database to a point-in-time, what is the primary requirement for the transaction log backups?

  3. 3

    You are restoring a database that was deleted. You have a full backup from Sunday at 12:00 AM and transaction log backups taken every hour. The deletion occurred at 2:30 PM on Monday. Which backup files are required to restore the database to 2:15 PM on Monday?

  4. 4

    What is the purpose of performing a 'Tail-Log Backup' before restoring a database that has been dropped or corrupted?

  5. 5

    If you are using a cloud-based managed database service (e.g., AWS RDS or Azure SQL) and the database is deleted, what is the most common mechanism used to restore it?