Question 40
An Azure SQL operations team investigates: A disconnected server appears absent from a newly deployed Azure Arc inventory and needs onboarding validation. 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 disconnected server appears absent from a newly deployed Azure Arc inventory and needs onboarding validation. The specific supported administrative response is: Use Azure Arc-enabled SQL Server capabilities to inventory and govern eligible SQL Server instances outside Azure, respecting supported onboarding and extensions. The technical risk is: Without consistent hybrid inventory, patch and configuration state can be missed across data centers. Confirm the correction with: Connected eligible instances appear in centralized Azure management views with expected metadata and authorized access.
The acceptance evidence for this incident (A disconnected server appears absent from a newly deployed Azure Arc inventory and needs onboarding validation.) is: Connected eligible instances appear in centralized Azure management views with expected metadata and authorized access. It directly tests whether the remediation (Use Azure Arc-enabled SQL Server capabilities to inventory and govern eligible SQL Server instances outside Azure, respecting supported onboarding and extensions.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
Columnstore and row compression decisions (1.2) would demonstrate or implement: Before-and-after size, CPU and representative query tests establish the net benefit of the selected compression. The case states: A disconnected server appears absent from a newly deployed Azure Arc inventory and needs onboarding validation. The most direct paired action and test is: Use Azure Arc-enabled SQL Server capabilities to inventory and govern eligible SQL Server instances outside Azure, respecting supported onboarding and extensions.
Hyperscale storage and growth planning (1.2) addresses another technical failure: Choosing an unsuitable service tier can impose size or growth constraints on a rapidly expanding database. The required paired action and test concerns Azure arc-enabled SQL server inventory (1.1); a passing result for this alternative could leave that requirement unresolved.
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. The paired-answer requirement concerns Azure arc-enabled SQL server inventory (1.1); this alternative does not provide the matching intervention and separate acceptance evidence.