Question 360
A data architect recommends this approach: Treat Azure SQL Database as platform as a service with provider-managed host patching. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Infrastructure responsibility. The customer focuses more on schema, access and workload than guest OS maintenance.
Incorrect Answers
The other situation is better matched to Use the managed PostgreSQL service's supported backup and restore functionality. Recovery can use the service-managed backup mechanism within its configured limits.
The other situation is better matched to Configure supported Microsoft Entra authentication for Azure SQL. Authorized identities can use centralized identity management for database connections.
The other situation is better matched to Place suitable Azure SQL databases in an elastic pool. Databases can share a pool of provisioned compute resources.