Practice · Microsoft Certified: SQL AI Developer Associate

~/azure-dp-800 · azure-dp-800_d1_9c2f959c4dbf ▊

← Microsoft Certified: SQL AI Developer Associate · practice sheet

azure-dp-800_d1_9c2f959c4dbf domain/d1 · medium single

You are building an ASP.NET Core web application in Visual Studio 2022 version 17.12. Using Connected Services, you add an Azure SQL Database dependency, which configures the connection to use Microsoft Entra managed identity. After completing the wizard, the application fails to authenticate to the database. What must you do to enable the managed identity to connect successfully?

A Switch the connection string to use SQL authentication with a stored username and password
B Create a Microsoft Entra admin user on the Azure SQL Database, then create a SQL user for the managed identity and grant it permissions
C Store the connection string in secrets.json instead of Azure Key Vault
D Downgrade the project to reference System.Data.SqlClient so managed identity is supported

Unlock this exam to join the per-question discussion and vote on questions.

next question →