Question 190
An Azure SQL operations team investigates: A test identity can create tables despite a stated requirement to call only existing procedures. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (A test identity can create tables despite a stated requirement to call only existing procedures.) is: A permission check proves only the intended schema or table actions succeed for the dedicated workload identity. It directly tests whether the remediation (Use custom database roles and targeted GRANT or REVOKE permissions instead of broad administrative memberships.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: A test identity can create tables despite a stated requirement to call only existing procedures. The specific supported administrative response is: Use custom database roles and targeted GRANT or REVOKE permissions instead of broad administrative memberships. The technical risk is: Giving every application db_owner or server-wide authority expands the blast radius of compromised credentials. Confirm the correction with: A permission check proves only the intended schema or table actions succeed for the dedicated workload identity.
Incorrect Answers
Change tracking and change data capture (2.3) addresses another technical failure: Confusing lightweight change identifiers with historical before-and-after data can produce incomplete downstream synchronization. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: A permission check proves only the intended schema or table actions succeed for the dedicated workload identity.
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 case instead tests Least-privilege database roles and grants (2.1); the choice measures or changes another part of the system.
Sensitive data classification and discovery (2.3) would demonstrate or implement: The classification inventory identifies sensitive columns and its labels match approved data handling requirements. The required paired action and test concerns Least-privilege database roles and grants (2.1); a passing result for this alternative could leave that requirement unresolved.