What are two possible ways to achieve the goal?

You plan to deploy an Azure SQL Database instance to support an application. You plan to use the DTU-based purchasing model.

Backups of the database must be available for 30 days and point-in-time restoration must be possible.

You need to recommend a backup and recovery policy.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A . Use the Premium tier and the default backup retention policy.
B . Use the Basic tier and the default backup retention policy.
C . Use the Standard tier and the default backup retention policy.
D . Use the Standard tier and configure a long-term backup retention policy.
E . Use the Premium tier and configure a long-term backup retention policy.

View Answer

Answer: DE

Explanation:

The default retention period for a database created using the DTU-based purchasing model depends on the service tier:

– Basic service tier is 1 week.

– Standard service tier is 5 weeks.

– Premium service tier is 5 weeks.

Incorrect Answers:

B: Basic tier only allows restore points within 7 days.

Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-long-term-retention