ExpertMedium1 markMultiple Choice
AZ-305 · Question 34 · Domain 3.1: Backup and Disaster Recovery
A developer accidentally executes a DROP TABLE command on a production Azure SQL Database at 2:15 PM.
The database is configured with the default automated backup settings. You need to recover the deleted table with the minimum amount of data loss.
What should you do?
A developer accidentally executes a DROP TABLE command on a production Azure SQL Database at 2:15 PM.
The database is configured with the default automated backup settings. You need to recover the deleted table with the minimum amount of data loss.
What should you do?
Answer options:
A.
Restore the latest daily full backup over the existing database.
B.
Perform a Point-in-Time Restore (PITR) to a new database using the timestamp 2:14 PM.
C.
Use the Azure SQL Data Sync feature to sync the table from a secondary replica.
D.
Perform a Point-in-Time Restore (PITR) to overwrite the existing database using the timestamp 2:14 PM.
How to approach this question
Recognize that human error (dropping a table) requires Point-in-Time Restore, and remember that Azure SQL PITR always creates a new database.
Full Answer
B.Perform a Point-in-Time Restore (PITR) to a new database using the timestamp 2:14 PM.✓ Correct
Azure SQL Database provides built-in automated backups, including transaction log backups every 5-10 minutes. This enables Point-in-Time Restore (PITR). To recover from a human error like a dropped table, you use PITR to restore the database to the minute just before the error (2:14 PM). Crucially, Azure SQL PITR always restores to a *new* database on the same server. You would then extract the dropped table from the new database and copy it back to the original.
Common mistakes
Assuming PITR can overwrite the existing database in place. It cannot.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 3
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees across 30 countries. They cur...MediumQ02Fabrikam Inc. is a Managed Service Provider (MSP) managing Azure environments for 50 different en...HardQ03A financial institution generates 5 TB of telemetry and audit logs daily across its Azure environ...MediumQ04A retail company has recently migrated several workloads to Azure. The IT Director wants a centra...EasyQ05A healthcare organization with 10,000 employees uses on-premises Active Directory. They are migra...Hard