Question 180
An Azure SQL operations team investigates: A cloud DBA wants to grant one external group database role membership rather than maintain individual SQL passwords. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A cloud DBA wants to grant one external group database role membership rather than maintain individual SQL passwords.) is: The signed-in user can perform the assigned database operations and is denied unrelated schema or data actions. It directly tests whether the remediation (Create contained database users mapped to supported Microsoft Entra identities and grant only the required database roles or permissions.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A cloud DBA wants to grant one external group database role membership rather than maintain individual SQL passwords. The specific supported administrative response is: Create contained database users mapped to supported Microsoft Entra identities and grant only the required database roles or permissions. The technical risk is: An Entra identity alone does not automatically confer SQL database authorization to the data it needs. Confirm the correction with: The signed-in user can perform the assigned database operations and is denied unrelated schema or data actions.
Incorrect Answers
SQL ledger tamper-evidence (2.3) would demonstrate or implement: An external digest and ledger verification detect a controlled unauthorized alteration of historical records. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: The signed-in user can perform the assigned database operations and is denied unrelated schema or data actions.
Managed identity database access (2.1) addresses another technical failure: Embedded long-lived SQL passwords in configuration files are easily copied and difficult to rotate safely. The required paired action and test concerns Contained database users from entra identities (2.1); a passing result for this alternative could leave that requirement unresolved.
Dynamic data masking limitations (2.3) addresses another technical failure: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. The paired-answer requirement concerns Contained database users from entra identities (2.1); this alternative does not provide the matching intervention and separate acceptance evidence.