Question 1mediummultiple choice
Full question →mediummultiple choiceObjective-mapped
A company has deployed a production Azure SQL Database that is used by a critical line-of-business application. The database administrators need to be able to change the database schema and scaling settings. However, the operations team must ensure that no one can accidentally delete the database or its server. The company does not want to implement a complex backup strategy for this prevention; they want a simple control that can be applied at the resource level without affecting other management operations. What should the operations team configure to meet these requirements?
Answer choices
Why each option matters
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
A
Distractor review
An Azure Policy definition with the 'Deny' effect assigned to the resource group containing the database
Incorrect. A Deny policy blocks all non-compliant resource creation or modification, but it does not specifically prevent deletion. It would block schema changes if they are not explicitly allowed, which contradicts the requirement.
B
Distractor review
A custom Azure Role-Based Access Control (RBAC) role that excludes the delete action
Incorrect. While a custom RBAC role could remove delete permissions, it requires careful design and assignment. It is more complex to manage and could inadvertently affect other operations. Resource locks provide a simpler, declarative control.
C
Best answer
A 'CanNotDelete' resource lock on the database and the server
Correct. A 'CanNotDelete' resource lock prevents deletion of the resource while allowing all other management operations such as reading, updating, and scaling. This directly meets the requirement for a simple, resource-level control.
D
Distractor review
An Azure Blueprint that includes a policy enforcing a read-only state
Incorrect. Azure Blueprints are used to define and deploy a repeatable set of Azure resources and policies. They do not directly provide a mechanism to lock existing resources against deletion. Applying a read-only state through a blueprint would block both deletion and modifications, which is not desired.
Common exam trap
Common exam trap: ACLs stop at the first match
ACLs are processed top to bottom. The first matching entry wins, and an implicit deny usually exists at the end.
Technical deep dive
How to think about this question
ACL questions test precision: source, destination, protocol, port and direction. A generally correct ACL can still fail if it is applied on the wrong interface or in the wrong direction.
KKey Concepts to Remember
- Standard ACLs match source addresses.
- Extended ACLs can match source, destination, protocol and ports.
- The first matching ACL entry is used.
- There is usually an implicit deny at the end.
TExam Day Tips
- Check inbound versus outbound direction.
- Read the ACL from top to bottom.
- Look for a broader permit or deny above the intended line.
Related practice questions
Related AZ-900 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
AZ-900 cloud concepts practice questions
Practise AZ-900 questions linked to AZ-900 cloud concepts.
AZ-900 Azure services practice questions
Practise AZ-900 questions linked to AZ-900 Azure services.
AZ-900 pricing and support practice questions
Practise AZ-900 questions linked to AZ-900 pricing and support.
AZ-900 security and compliance practice questions
Practise AZ-900 questions linked to AZ-900 security and compliance.
AZ-900 governance practice questions
Practise AZ-900 questions linked to AZ-900 governance.
More questions from this exam
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
A developer is building a serverless application that requires integration with an on-premises SQL Server database for real-time data processing. The on-premises network is connected to Azure via a site-to-site VPN. Which Azure service would allow the function to securely access the on-premises database without exposing it to the public internet?
Question 2
A solutions architect is designing a storage solution for a large media company. The company needs to store video files that are accessed infrequently but must be retained for several years for compliance. Which two Azure storage options meet these requirements? (Select two.)
Question 3
A company deploys a multi-tier application using Azure virtual machines. The web tier VMs must be evenly distributed across two distinct data centers within an Azure region to avoid a single point of failure from an infrastructure outage. Which Azure construct should they use to meet this requirement?
Question 4
A company wants to enforce a set of security policies across all their Azure subscriptions. They have created several individual policy definitions. Which Azure construct should they use to group these policies together and assign them as a single package?
Question 5
A company deploys a line-of-business application on an Azure virtual machine. The IT team wants to ensure the application remains secure. According to the shared responsibility model, which of the following security tasks is the sole responsibility of the customer (the company)?
Question 6
A company develops a web API that runs on Azure App Service. The development team wants to deploy a new version of the API to a staging environment, run integration tests against it, and then gradually shift production traffic to the new version. If any issues are detected, they want to immediately roll back to the previous version without redeploying. Which Azure App Service feature should the team use to meet these requirements?
FAQ
Questions learners often ask
What does this AZ-900 question test?
Standard ACLs match source addresses.
What is the correct answer to this question?
The correct answer is: A 'CanNotDelete' resource lock on the database and the server — Azure resource locks are used to prevent accidental deletion or modification of critical resources. A 'CanNotDelete' lock allows all operations including read, update, and create, but specifically prevents deletion of the resource. This is simpler and more targeted than using Azure Policy, RBAC, or Blueprints for this specific requirement.
What should I do if I get this AZ-900 question wrong?
Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.
Discussion
Loading comments…
Sign in to join the discussion.