dp-900 Practice Question 1828
Exam: dp-900
Domain: Describe how to work with relational data on Azure
Topic: Describe relational Azure data services
Difficulty: medium
During a recent audit, Contoso Ltd discovered that their Azure SQL Database is experiencing permission bottlenecks, affecting application performance. They need to implement a solution that minimizes the number of permissions required while ensuring secure access. Which approach should they take, and why?
Answer Options
A
Entity-level permissions
B
Role-Based Access Control (RBAC)
C
Managed Identities
D
Azure Active Directory (AAD)
Correct Answer
B: Role-Based Access Control (RBAC)
Explanation
The correct answer is B: Role-Based Access Control (RBAC). RBAC allows for fine-grained control over permissions by assigning roles to users or groups, reducing the need for individual object-level permissions.