Question 540
An Azure SQL operations team investigates: A DBA needs to confirm which SQL hosting products and tiers support the proposed Resource Governor settings. 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 DBA needs to confirm which SQL hosting products and tiers support the proposed Resource Governor settings. The specific supported administrative response is: Use Resource Governor where supported on SQL Server or eligible managed configurations to isolate competing workload resources after verifying availability. The technical risk is: Applying an instance feature to an unsupported Azure SQL database tier or using incorrect classifiers can fail or throttle critical users. Confirm the correction with: A workload classification test shows intended resource limits without starving high-priority connections.
The acceptance evidence for this incident (A DBA needs to confirm which SQL hosting products and tiers support the proposed Resource Governor settings.) is: A workload classification test shows intended resource limits without starving high-priority connections. It directly tests whether the remediation (Use Resource Governor where supported on SQL Server or eligible managed configurations to isolate competing workload resources after verifying availability.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Execution plan scans and cardinality estimation (3.2) addresses another technical failure: Choosing an index solely from table size without seeing the predicate and plan can waste resources. This choice can be useful for that problem, but it does not establish the Resource governor workload classification (3.3) control being assessed here.
Database integrity checks and consistency (3.3) addresses another technical failure: A successful backup or query does not by itself prove every database page and relationship is consistent. This case instead tests Resource governor workload classification (3.3); the choice measures or changes another part of the system.
Deadlock detection and remediation (3.2) would demonstrate or implement: A concurrency test no longer produces the captured deadlock cycle and database correctness is preserved. The paired-answer requirement concerns Resource governor workload classification (3.3); this alternative does not provide the matching intervention and separate acceptance evidence.