DP-300 Certification Practice Question #237

Question

You configure backups for an Azure SQL database as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Accepted Answer

To recover from a recent database failure (e.g., 2 days ago) with minimal data loss, a Point-in-Time Restore (PITR) backup must be used because it utilizes frequent transaction log backups to restore to a precise point in time. LTR backups only keep weekly full backups, which would result in up to a week of data loss. For the second statement, Azure SQL Database LTR policies do not duplicate backup files; instead, the same weekly full backup is reused to satisfy weekly, monthly, and yearly retention policies by extending its expiry date. Since we are at the 52nd week and weekly backups are retained for 52 weeks, exactly 52 physical backups have been created and none have expired yet, meaning there are exactly 52 backup copies in LTR storage.

More DP-300 practice questions