Plan and Perform Backup and Restore of a Database DP-300 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   A business requires that after a disaster, the database be available within 2 hours. The restore process currently takes 3 hours because many transaction log backups must be applied. Which restore strategy would most effectively reduce the recovery time?

   • ATake more frequent differential backups
   • BTake more frequent full backups
   • CTake more frequent transaction log backups
   • DUse a full backup and restore with NORECOVERY
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A company uses Azure SQL Database for an e-commerce platform. A developer accidentally deleted a critical table at 10:15 AM. The database has automated backups with a 7-day retention period. The administrator needs to restore the database to a state as close to 10:14 AM as possible. What should the administrator do?

   • ARestore the database to a new database using point-in-time restore with the time set to 10:14 AM.
   • BRestore the database in-place to the point of deletion using the RESTORE command.
   • CUse the Azure portal to export the database as a .bacpac and import it back.
   • DRestore the latest automated backup and manually re-enter the deleted data.
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A company has an Azure SQL Database with automated backups configured for 35 days and long-term retention (LTR) for 5 years. At 3:00 PM, a user accidentally deletes a critical table. The deletion is discovered at 5:00 PM. You need to restore the database to a point just before 3:00 PM. What is the best approach?

   • AUse geo-restore to recover the database.
   • BRestore from the latest LTR backup.
   • CRestore from the latest automated backup and then apply transaction log backups manually.
   • DUse point-in-time restore to 2:59 PM.
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A company uses Azure SQL Database for a customer portal. The database has automated backups with a 35-day retention period. A user accidentally deleted a large amount of data at 2:30 PM. The administrator needs to restore the database to 2:29 PM. The restore must be completed within 1 hour. What should the administrator do?

   • APerform an in-place restore of the database to 2:29 PM using the Azure portal.
   • BPerform a point-in-time restore to a new database with the time set to 2:29 PM, then switch the application connection string to the new database.
   • CUse the Azure portal to export the database as a .bacpac and import it back to the same database.
   • DRestore the latest automated backup and manually re-enter the deleted data.
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A company has an Azure SQL Database with automated backups configured for 30 days. The compliance team requires that backups be retained for 3 years. The database is 2 TB. During a recent audit, you need to restore the database to a specific point in time from 2 years ago. What should you do?

   • AUse geo-restore to recover the database from a geo-redundant backup.
   • BIncrease automated backup retention to 3 years.
   • CUse point-in-time restore to the desired time.
   • DRestore from a long-term retention (LTR) backup taken at that time.
   Reveal Solution Discussion Select an answer first