Examkin

Question

Difficulty: EasyResource Locks

An Azure administrator applies a ReadOnly resource lock to an Azure SQL Database. Which action can a user still perform on this database?

  1. Read the database configuration settingsAnswer
  2. B
    Change the database pricing tier
  3. C
    Modify the database firewall rules
  4. D
    Rename the database resource

Answer

Read the database configuration settings
The correct answer is reading the database configuration settings. A ReadOnly lock is the most restrictive lock type. It blocks any modifications (writes) and deletions, but allows authorized users to read the configuration, properties, and status of the resource.

Step-by-Step Solution

1
Identify the type of resource lock applied to the Azure SQL Database.
The applied lock is a ReadOnly lock.
This determines the restrictions placed on the resource.
2
Recall the behavior and restrictions of a ReadOnly resource lock.
A ReadOnly lock prevents all write and delete operations, meaning no configurations can be modified and the resource cannot be deleted, but read-only actions are permitted.
This helps filter which user actions are allowed versus blocked.
3
Evaluate the choices to find the action that is a read-only operation.
Viewing or reading the database configuration settings is a read-operation, whereas changing the pricing tier, modifying firewall rules, or renaming the database are write operations.
Only read operations are allowed under a ReadOnly lock.

Key Concept

Azure resource locks prevent accidental deletion or modification of resources. A ReadOnly lock restricts all write, modify, and delete operations while permitting read operations.
Rate this question

Topics

Resource Locks

More questions from this topic