Question 380
A data architect recommends this approach: Configure supported Microsoft Entra authentication for Azure SQL. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for SQL authentication mode. Authorized identities can use centralized identity management for database connections.
Incorrect Answers
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 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 Deploy SQL Server on an Azure virtual machine. The organization can customize OS and SQL Server instance configuration.