Microsoft · DP-300
Running and troubleshooting migrations
DP-300 · Lesson 6 of 22 · 41:39
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: online migrations with the Managed Instance link, offline migrations with native backups from Blob Storage, the Log Replay Service, and BACPAC files with SqlPackage, moving between Azure SQL services with database copy, replication, and Managed Instance copy and move, and troubleshooting connectivity, permissions, compatibility, orphaned users, and TDE certificates. Includes three original practice questions.
Preview the topics
- Contoso must move a 300 GB SQL Server database to Azure SQL Database during a weekend maintenance window. Which approach works?
- Contoso wants to move its reporting database to a managed instance in another subscription of the same tenant, online, and drop it from the source afterwards. What should it use?
- After restoring a backup on a SQL Server VM, Contoso’s application user exists in the database, but every sign-in fails. What’s the likely cause?