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.
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