practice sheet · all objectives switch to smart practice →
Microsoft Certified: SQL AI Developer Associate
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?
Explanation
If there isn't a Microsoft Entra admin user, the connection will fail to authenticate successfully.
you'll need to create a SQL user that corresponds to the managed identity, and set permissions by executing SQL statements in the database
System.Data.SqlClient , you'll need to upgrade to Microsoft.Data.SqlClient , since System.Data.SqlClient doesn't support Microsoft Entra authentication
A development team uses Entity Framework Core and needs to deploy schema changes to a production Azure SQL Database. They want the changes to be reviewable by a DBA and integrable into their CI process before being applied. Which Entity Framework migration option should they choose?
Explanation
After a migration has been created, it can be applied to a database. Entity Framework updates your database and your schema with the changes specified
The recommended way to deploy migrations to a production database is by generating SQL scripts.
Locked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to reviewLocked question — unlock this exam to view it.
locked — unlock to review