ExpertHard1 markMultiple Choice
AZ-305 · Question 33 · Domain 3.1: Backup and Disaster Recovery
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)
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:
A.
Azure Site Recovery.
B.
Short-term retention policy (PITR).
C.
Auto-failover groups.
D.
Long-term retention policy (LTR).
E.
Azure Blob Storage lifecycle management.
How to approach this question
Identify the two native SQL backup retention features.
Full Answer
B,D
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.
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...MediumQ02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...HardQ03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...HardQ04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...EasyQ05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium