DP-300 Plan and implement data platform resources Practice Question
Which TWO of the following are valid methods to migrate an on-premises SQL Server database to Azure SQL Database?
⚠ Common exam trap
A common mix-up: candidates assume native SQL Server backup restore (Option E) works in Azure SQL Database because it works in Azure SQL Managed Instance, but Azure SQL Database is a different PaaS tier that only supports BACPAC-based import/export.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Export the database as a BACPAC file and import into Azure SQL Database
A BACPAC file is a logical backup that contains the database schema and data in a compressed format. Azure SQL Database supports importing BACPAC files directly via the Azure portal, PowerShell, or the SqlPackage utility, making this a straightforward and fully supported migration method.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Export the database as a BACPAC file and import into Azure SQL Database
Why this is correct
BACPAC is a supported migration method.
- ✗
Configure transactional replication to replicate changes to Azure SQL Database
Why it's wrong here
Replication is not used for migration.
- ✗
Use log shipping to continuously copy transaction logs
Why it's wrong here
Log shipping is not supported.
- ✓
Use the Data Migration Assistant (DMA) to perform an online migration
Why this is correct
DMA supports migration to Azure SQL Database.
- ✗
Restore a native SQL Server backup to Azure SQL Database
Why it's wrong here
Native backup restore is not supported on Azure SQL Database.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 906-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.