Question 80
An Azure SQL operations team investigates: A database owner wants to compare aggregate pool capacity with the maximum consumption of individual members. 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 owner wants to compare aggregate pool capacity with the maximum consumption of individual members. The specific supported administrative response is: Use an Azure SQL Database elastic pool for multiple independent databases with complementary and variable compute demand after measuring pool limits. The technical risk is: Provisioning every idle tenant database for its own peak can waste capacity while a mis-sized pool causes noisy-neighbor contention. Confirm the correction with: Pool and per-database resource metrics demonstrate the expected concurrency without sustained saturation.
The acceptance evidence for this incident (A database owner wants to compare aggregate pool capacity with the maximum consumption of individual members.) is: Pool and per-database resource metrics demonstrate the expected concurrency without sustained saturation. It directly tests whether the remediation (Use an Azure SQL Database elastic pool for multiple independent databases with complementary and variable compute demand after measuring pool limits.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Azure SQL database serverless compute (1.2) addresses another technical failure: Auto-pause resume delay and compute minimum settings can be unsuitable for continuous low-latency traffic. This case instead tests Azure SQL database elastic pools (1.2); the choice measures or changes another part of the system.
Azure SQL database platform fit (1.1) addresses another technical failure: Moving an application with unsupported instance dependencies to a logical database can break its procedures or operations. The required paired action and test concerns Azure SQL database elastic pools (1.2); a passing result for this alternative could leave that requirement unresolved.
SQL server on azure virtual machines (1.1) would demonstrate or implement: The application passes functional acceptance on the chosen VM while OS patching, storage and backup responsibilities are explicitly assigned. The paired-answer requirement concerns Azure SQL database elastic pools (1.2); this alternative does not provide the matching intervention and separate acceptance evidence.