Question 1
An Azure database administrator observes: A new web API needs a managed relational database without an operating-system administration team. Which action best addresses the specific technical requirement?
Explanation
Correct Answer
The reported Azure SQL or SQL Server condition is: A new web API needs a managed relational database without an operating-system administration team. 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.
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 choice can be useful for that problem, but it does not establish the Azure SQL database platform fit (1.1) control being assessed here.
Azure SQL managed instance database copy and move (1.3) addresses another technical failure: A copy preserves the source database after completion, whereas an approved move removes the source; wrong operation choices or incompatible update policies can interrupt work. 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 corrective action concerns Azure SQL database platform fit (1.1); a passing result for this alternative could leave that requirement unresolved.