What should you configure in the backup policy?

You need to configure a disaster recovery solution for SALESDB to meet the technical requirements.

What should you configure in the backup policy?
A . weekly long-term retention backups that are retained for three weeks
B . failover groups
C . a point-in-time restore
D . geo-replication

View Answer

Answer: C

Explanation:

Scenario: SALESDB must be restorable to any given minute within the past three weeks.

The Azure SQL Database service protects all databases with an automated backup system. These backups are retained for 7 days for Basic, 35 days for Standard and 35 days for Premium. Point-in-time restore is a self-service capability, allowing customers to restore a Basic, Standard or Premium database from these backups to any point within the retention period.

References: https://azure.microsoft.com/en-us/blog/azure-sql-database-point-in-time-restore/