A database administrator applies a ReadOnly lock to the logical server that hosts a critical Azure SQL database and tells management the data is now protected against loss. Management asks whether the lock also prevents data inside the database from being modified or deleted. What is the correct answer?

1. A. No — locks apply to control-plane operations, so creating, updating, and deleting data inside the database is still possible ✓ A
2. B. Yes — a ReadOnly lock blocks every operation on the server, including data changes 💬 B
3. C. Yes — locks protect both the resource and the data it contains, so no backup is needed 💬 C
4. D. No — but applying a CanNotDelete lock instead would protect the data while allowing configuration changes 💬 D

Reveal answer

Correct answer: No — locks apply to control-plane operations, so creating, updating, and deleting data inside the database is still possible

Reference: https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/lock-resources