Exam DP-201 topic 4 question 10 discussion

You have the right information, and the wrong answers. Default backup retention for the Standard and Premium tiers is 35 days, and you need 30 days. So you do not need long-term retention set up.

Correct answers are A and C

Can some please confirm https://azure.microsoft.com/en-us/blog/azure-sql-database-built-in-backups-vs-importexport-2/. According to this default for standard - 14 days only.

Answer is correct: Backup retention for purposes of PITR within the last 1-35 days is sometimes called short-term backup retention. If you need to keep backups for longer than the maximum short-term retention period of 35 days, you can enable Long-term retention. https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database

Your choices: 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. Only two of them use long-term storage. As noted elsewhere the default retention periods have been aligned and are 7 days. 7 days does not meet the requirements. Only D and E mention long-term backup and are thus the correct choice.

C,D -the best

I think the right answer is A nd C. Still not very clear though cos the default is 7 days, but can be changed to up to 35 days (which is still within the short term retention). Setting up a long term retention policy is totally different and that is for backup requirements for over 35 days to up to 10 years. Ref: https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview

Basic Standard Premium Maximum backup retention 7 days 35 days 35 days https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu

https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database For all new, restored, and copied databases, Azure SQL Database and Azure SQL Managed Instance retain sufficient backups to allow PITR within the last 7 days by default. With the exception of Hyperscale and Basic tier databases, you can change backup retention period per each active database in the 1-35 day range Backup retention for purposes of PITR within the last 1-35 days is sometimes called short-term backup retention. If you need to keep backups for longer than the maximum short-term retention period of 35 days, you can enable Long-term retention.

I think the correct answer is just not there. You do not create a LTR policy as this is only required for storage longer than 35 days. But you can't use the default either as this is et to 7 days. Think the question is outdated. Only thing we can be sure of is that the basic tier will not do as this one cannot be set to higher than 7 days.

From 1st July 2019 the Default backup retention is set to 7 days not 35 days , so the given answers are correct ( the day I'm writing this)

https://azure.microsoft.com/en-us/updates/default-backup-retention-period-for-dtu-based-azure-sql-databases-is-changing-soon/#:~:text=To%20facilitate%20smooth%20conversion%20from,35%20days%20to%207%20days.: "the default backup retention period for point in time restore of the DTU-based Azure SQL Databases is changing from 35 days to 7 days." D and E are therefore correct

The default retention policy for DTU based purchasing had changed from 35 days to 7 days starting from July of 2020. So, the specified answers are correct. https://azure.microsoft.com/en-in/updates/default-backup-retention-period-for-dtu-based-azure-sql-databases-is-changing-soon/#:~:text=Published%20date%3A%2014%20June%2C%202019,35%20days%20to%207%20days.&text=The%20existing%20databases%20will%20remain%20unchanged.

The answer should be A & C. Default backup is for 35 days.

D and E are correct

the correct answer is A and C. It is very clear in explanation they have given.

as of jun 2020 new policies are default PiTR is 7 days for all db except hyperscale not sure if this is updated to the new question database. https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database