To protect a mission-critical SQL database from being accidentally or maliciously deleted, you want to ensure that any deletion attempt requires a separate approval from a security manager and that the database can be recovered even if the primary admin account is compromised. Which feature provides this?

Direct Answer (Verified)Reviewed by Sunny (Senior Cloud Engineer)

Correct Answer: Azure SQL Database 'Soft Delete' and 'Long-term retention' (LTR) with a Resource Lock

Resource Locks prevent deletion at the management plane, while Soft Delete and LTR provide the ability to recover from destructive actions....

📋Part of Microsoft Certified: Azure Solutions Architect Expert (AZ-305) · Azure Certification Practice
Real Exam ScenarioAzure SQL Database

To protect a mission-critical SQL database from being accidentally or maliciously deleted, you want to ensure that any deletion attempt requires a separate approval from a security manager and that the database can be recovered even if the primary admin account is compromised. Which feature provides this?

✓ Correct Answer & ExplanationAzure SQL Database

Correct Answer

Azure SQL Database 'Soft Delete' and 'Long-term retention' (LTR) with a Resource Lock

Why This Answer Is Correct

Resource Locks prevent deletion at the management plane, while Soft Delete and LTR provide the ability to recover from destructive actions.

📚 What This Question Tests

This question evaluates your knowledge of Azure SQL Database — a core concept tested in Microsoft Certified: Azure Solutions Architect Expert (AZ-305). Understanding Azure SQL Database is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.

All Microsoft Certified: Azure Solutions Architect Expert (AZ-305) Questions →Browse All Azure Exams →

More Azure SQL Database Practice Questions

A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?

An organization is using Azure SQL Database. They want to ensure that if the primary region experiences a major disaster, the database automatically fails over to a secondary region with an RPO of less than 30 seconds. Which feature should they use?

Which Azure data service provides a managed, cloud-native SQL database with 'Hyperscale' capabilities that can automatically scale up to 100 TB per database and provides near-instant backups?

You are designing a high-performance database for a legacy application that requires full compatibility with SQL Server Agent and Cross-database queries, but you want to move to a fully managed platform. Which service is best?

To protect your Azure SQL Database from 'SQL Injection' and other unusual activity like 'Data Exfiltration', which security feature should you enable within Microsoft Defender for SQL?

← Back to Microsoft Certified: Azure Solutions Architect Expert (AZ-305) Full Practice Hub