Question 340
A data architect recommends this approach: Place suitable Azure SQL databases in an elastic pool. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for SQL elastic pool. Databases can share a pool of provisioned compute resources.
Incorrect Answers
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 Treat Azure SQL Database as platform as a service with provider-managed host patching. The customer focuses more on schema, access and workload than guest OS maintenance.
The other situation is better matched to Connect using an appropriate SQL client such as SQL Server Management Studio. The engineer can run authorized SQL statements against the managed database.