Question 120
An Azure SQL operations team investigates: An administrator needs to choose boundaries for fiscal periods while retaining correct insert placement. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The acceptance evidence for this incident (An administrator needs to choose boundaries for fiscal periods while retaining correct insert placement.) is: Partition-aware maintenance and representative predicates show expected partitions accessed with correct results. It directly tests whether the remediation (Implement table partitioning on appropriate SQL Server or Azure SQL database tables using a suitable partition function and scheme after testing query patterns.) solves the specified issue, instead of proving an unrelated database control works.
The reported Azure SQL or SQL Server condition is: An administrator needs to choose boundaries for fiscal periods while retaining correct insert placement. The specific supported administrative response is: Implement table partitioning on appropriate SQL Server or Azure SQL database tables using a suitable partition function and scheme after testing query patterns. The technical risk is: Partitioning without a matching access pattern or maintenance plan can complicate administration without improving queries. Confirm the correction with: Partition-aware maintenance and representative predicates show expected partitions accessed with correct results.
Incorrect Answers
Azure SQL managed instance compatibility (1.1) addresses another technical failure: Selecting single-database PaaS for SQL Agent or instance-centered dependencies creates costly compatibility rework. This choice can be useful for that problem, but it does not establish the Table partitioning for large tables (1.2) control being assessed here.
Azure SQL managed instance database copy and move (1.3) would demonstrate or implement: An approved copy leaves both independent databases online, or a controlled move finishes with the target writable and the source removed as intended. The required paired action and test concerns Table partitioning for large tables (1.2); a passing result for this alternative could leave that requirement unresolved.
Azure SQL business critical tier selection (1.2) addresses another technical failure: Under-sizing storage IO or latency for transaction-heavy databases can cause persistent response-time problems. The paired-answer requirement concerns Table partitioning for large tables (1.2); this alternative does not provide the matching intervention and separate acceptance evidence.