Question 550
An Azure SQL operations team investigates: A SQL tuning change should be reversible and isolated from the rest of a managed instance. 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 SQL tuning change should be reversible and isolated from the rest of a managed instance. The specific supported administrative response is: Use supported ALTER DATABASE SCOPED CONFIGURATION settings to tune behaviors for a specific database with controlled verification. The technical risk is: Applying server-wide settings for one database's issue can unintentionally affect unrelated workloads. Confirm the correction with: The targeted database reports the intended scoped value and regression tests show other databases are unaffected.
The acceptance evidence for this incident (A SQL tuning change should be reversible and isolated from the rest of a managed instance.) is: The targeted database reports the intended scoped value and regression tests show other databases are unaffected. It directly tests whether the remediation (Use supported ALTER DATABASE SCOPED CONFIGURATION settings to tune behaviors for a specific database with controlled verification.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Azure SQL compute and storage scaling (3.3) addresses another technical failure: Increasing vCores blindly may not solve throttled log IO or storage bottlenecks and scaling can cause transient failovers. This choice can be useful for that problem, but it does not establish the Database-scoped configuration controls (3.3) control being assessed here.
Wait statistics and resource bottleneck interpretation (3.1) addresses another technical failure: Treating every high wait counter as CPU pressure can prompt ineffective scaling or index changes. This case instead tests Database-scoped configuration controls (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 Database-scoped configuration controls (3.3); this alternative does not provide the matching intervention and separate acceptance evidence.