Practice · Microsoft Certified: SQL AI Developer Associate

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

← Microsoft Certified: SQL AI Developer Associate · practice sheet

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

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?

A Update database, which applies the migration directly to production
B Add migration, which snapshots the current model
C Generate SQL script, which produces a reviewable script for deployment
D Open in SQL Server Object Explorer to work directly with the data

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

next question →