You are designing a backup strategy for Azure SQL Databases. The business requires point-in-time restore capabilities for up to 35 days. Additionally, monthly backups must be retained for 10 years to meet regulatory compliance. Which TWO features should you configure? (Select TWO)

Answer options:

Azure Site Recovery.

Short-term retention policy (PITR).

Auto-failover groups.

Long-term retention policy (LTR).

Azure Blob Storage lifecycle management.

How to approach this question

Identify the two native SQL backup retention features.

Full Answer

Azure SQL Database natively supports Short-term retention (PITR) for up to 35 days, and Long-term retention (LTR) for keeping backups for up to 10 years.

Common mistakes

Attempting to use Blob lifecycle management for native SQL backups.

Question 32 All questions Question 34

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6

55 questions · hints · full answers · grading

More questions from this exam

Q01Contoso Ltd is a global manufacturing company with 50,000 employees. They operate a mix of on-pre...Medium Q02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...Hard Q03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...Hard Q04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...Easy Q05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium

View all 55 questions →