DP-200 Azure Data Integration and Migration 1 — Questions and Answers
Question 1: Which Azure service is designed specifically to migrate on-premises databases to Azure with minimal downtime?
- Azure Data Factory
- Azure Database Migration Service (Correct answer)
- Azure Synapse Analytics
- Azure Site Recovery
Correct answer: Azure Database Migration Service
Azure Database Migration Service (DMS) is purpose-built for migrating on-premises databases to Azure SQL Database, Azure SQL Managed Instance, or SQL Server on Azure VMs.
Question 2: Which tool should you run before migrating an on-premises SQL Server database to Azure SQL Database to identify compatibility issues?
- Azure Advisor
- Database Experimentation Assistant
- Data Migration Assistant (DMA) (Correct answer)
- Azure Cost Management
Correct answer: Data Migration Assistant (DMA)
Data Migration Assistant (DMA) assesses SQL Server databases for compatibility issues and provides actionable recommendations before migration to Azure SQL Database.
Question 3: Which migration mode in Azure Database Migration Service keeps the source database operational throughout the migration process?
- Offline migration
- Snapshot migration
- Online migration (Correct answer)
- Bulk copy migration
Correct answer: Online migration
Online migration uses continuous data synchronization so the source database remains available, minimizing downtime to a brief cutover window at the end.
Question 4: When migrating from MongoDB to Azure Cosmos DB for MongoDB API, which service provides managed migration with minimal downtime?
- Azure Data Box
- Azure Database Migration Service (Correct answer)
- BACPAC import/export
- Azure Import/Export service
Correct answer: Azure Database Migration Service
Azure Database Migration Service supports online migration from MongoDB to Azure Cosmos DB for MongoDB API, handling continuous data sync until cutover.
Question 5: What is the primary function of the Copy Activity in Azure Data Factory?
- To transform data using Spark
- To schedule pipeline executions
- To move data from a source data store to a destination data store (Correct answer)
- To monitor pipeline execution status
Correct answer: To move data from a source data store to a destination data store
Copy Activity in Azure Data Factory is optimized for data movement, copying data from a supported source data store to a sink (destination) data store.
Question 6: Which network connectivity option is required by Azure Database Migration Service when migrating to Azure SQL Managed Instance?
- Public internet endpoint only
- Azure ExpressRoute or VPN Gateway (Correct answer)
- Azure Service Bus relay
- Azure CDN
Correct answer: Azure ExpressRoute or VPN Gateway
Azure Database Migration Service requires ExpressRoute or VPN Gateway to establish line-of-sight network connectivity between DMS and the on-premises source database when targeting SQL Managed Instance.
Question 7: What is the primary factor that determines whether to use online versus offline migration in Azure Database Migration Service?
- The number of tables in the source database
- The acceptable amount of downtime during migration (Correct answer)
- The version of the source database engine
- The size of the source database in GB
Correct answer: The acceptable amount of downtime during migration
Acceptable downtime is the key decision factor: offline migration requires the source to go offline, while online migration keeps it running with only a short cutover window.
DP-200 Azure Data Integration and Migration 1
Which Azure service is designed specifically to migrate on-premises databases to Azure with minimal downtime?