Question 10
An Azure SQL operations team investigates: An architect must explain why Azure SQL Database logical servers do not grant full SQL Server host access. 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: An architect must explain why Azure SQL Database logical servers do not grant full SQL Server host access. The specific supported administrative response is: Select Azure SQL Database for a managed single-database PaaS application that does not depend on instance-level SQL Server features. The technical risk is: Moving an application with unsupported instance dependencies to a logical database can break its procedures or operations. Confirm the correction with: A deployment assessment confirms all required features work without managing SQL Server operating system or instance maintenance.
The acceptance evidence for this incident (An architect must explain why Azure SQL Database logical servers do not grant full SQL Server host access.) is: A deployment assessment confirms all required features work without managing SQL Server operating system or instance maintenance. It directly tests whether the remediation (Select Azure SQL Database for a managed single-database PaaS application that does not depend on instance-level SQL Server features.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
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 case states: An architect must explain why Azure SQL Database logical servers do not grant full SQL Server host access. The most direct paired action and test is: Select Azure SQL Database for a managed single-database PaaS application that does not depend on instance-level SQL Server features.
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 platform fit (1.1); the choice measures or changes another part of the system.
SQL database in microsoft fabric (1.1) addresses another technical failure: Assuming Fabric SQL database is simply a SQL Server VM can lead to wrong instance-management and integration expectations. The required paired action and test concerns Azure SQL database platform fit (1.1); a passing result for this alternative could leave that requirement unresolved.