Question 170
An Azure SQL operations team investigates: A database team must review which directory account has authority to create Azure SQL Entra users. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A database team must review which directory account has authority to create Azure SQL Entra users. The specific supported administrative response is: Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in. The technical risk is: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. Confirm the correction with: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password.
The acceptance evidence for this incident (A database team must review which directory account has authority to create Azure SQL Entra users.) is: An authorized Entra identity can authenticate and create the intended supported contained database principal without a shared SQL password. It directly tests whether the remediation (Configure a supported Microsoft Entra administrator and tenant identity prerequisites before enabling Entra-based SQL principals and sign-in.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Diagnosing login and token failures (2.1) addresses another technical failure: Treating every database error as a firewall block can conceal authentication and access-control faults. This choice can be useful for that problem, but it does not establish the Microsoft entra administrator for azure SQL (2.1) control being assessed here.
Row-level security with session predicates (2.3) addresses another technical failure: Filtering tenant data only in application code can leak rows through other SQL query paths or reporting tools. The required paired action and test concerns Microsoft entra administrator for azure SQL (2.1); a passing result for this alternative could leave that requirement unresolved.
SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. The paired-answer requirement concerns Microsoft entra administrator for azure SQL (2.1); this alternative does not provide the matching intervention and separate acceptance evidence.