Question 230
An Azure SQL operations team investigates: A database user has overlapping role grants and DENY permissions that require effective access analysis. 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 user has overlapping role grants and DENY permissions that require effective access analysis. The specific supported administrative response is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently. The technical risk is: Granting broad table permissions for a narrow reporting requirement can expose unrelated sensitive objects. Confirm the correction with: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail.
The acceptance evidence for this incident (A database user has overlapping role grants and DENY permissions that require effective access analysis.) is: Database effective-permission tests confirm view and procedure access while disallowed base-table operations fail. It directly tests whether the remediation (Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Azure SQL firewall rule scoping (2.2) addresses another technical failure: Allowing every public Azure IP or all internet clients to connect widens access to the SQL endpoint unnecessarily. The case states: A database user has overlapping role grants and DENY permissions that require effective access analysis. The most direct paired action and test is: Use schema ownership, object-level GRANT, DENY and appropriate role membership to control SQL access consistently.
Microsoft entra administrator for azure SQL (2.1) addresses another technical failure: Without correct tenant mapping and directory administration, intended Entra accounts cannot be provisioned for database access. This case instead tests Database object ownership and schema authorization (2.1); the choice measures or changes another part of the system.
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 required paired action and test concerns Database object ownership and schema authorization (2.1); a passing result for this alternative could leave that requirement unresolved.