DP-200 Azure Data Integration and Migration — 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.
Question 8: What is the role of Integration Runtime (IR) in Azure Data Factory?
- To store pipeline definitions and metadata
- To provide the compute infrastructure that executes data integration activities (Correct answer)
- To schedule pipeline triggers at defined intervals
- To generate reports on data lineage
Correct answer: To provide the compute infrastructure that executes data integration activities
Integration Runtime is the compute infrastructure Azure Data Factory uses to run activities, providing data movement, data transformation, and SSIS package execution capabilities.
Question 9: Which type of Azure Data Factory Integration Runtime must be installed on an on-premises machine to access private network data sources?
- Azure Integration Runtime
- Azure-SSIS Integration Runtime
- Self-hosted Integration Runtime (Correct answer)
- Hybrid Integration Runtime
Correct answer: Self-hosted Integration Runtime
Self-hosted Integration Runtime is installed on on-premises or cloud VMs in a private network, allowing Azure Data Factory to reach data sources not exposed to the public internet.
Question 10: What do Linked Services represent in Azure Data Factory?
- Logical groupings of pipeline activities
- Connection strings and authentication details for external data stores (Correct answer)
- References to datasets used across multiple pipelines
- Scheduled trigger definitions
Correct answer: Connection strings and authentication details for external data stores
Linked Services in Azure Data Factory function like connection strings, storing the endpoint and credentials required to connect ADF to external data sources and compute resources.
Question 11: Which Azure Data Factory trigger type fires pipelines on a recurring wall-clock schedule, such as every day at 8:00 AM UTC?
- Tumbling window trigger
- Schedule trigger (Correct answer)
- Storage event trigger
- Custom event trigger
Correct answer: Schedule trigger
Schedule triggers fire pipelines based on wall-clock time on a recurring basis (e.g., daily, weekly), making them suitable for time-based batch workloads.
Question 12: Which Azure Data Factory feature provides a visually designed, code-free interface for building complex data transformation logic that runs on Spark?
- Data Flow
- Pipeline Editor
- Mapping Data Flow (Correct answer)
- Copy Data wizard
Correct answer: Mapping Data Flow
Mapping Data Flow lets you visually design data transformations using a graph-based UI; ADF compiles these flows into Spark jobs that run on an auto-managed Spark cluster.
Question 13: Which Azure Data Factory capability allows a single dataset definition to serve multiple data sources by accepting runtime-provided values?
- Schema mapping
- Parameterization (Correct answer)
- Linked service chaining
- Dataset cloning
Correct answer: Parameterization
Parameterization lets you define datasets and linked services with parameters so that a single definition can dynamically point to different tables, files, or databases at runtime.
Question 14: In Azure Data Factory, which construct is a logical grouping of activities that together perform a unit of work?
- Dataset
- Linked Service
- Pipeline (Correct answer)
- Trigger
Correct answer: Pipeline
A Pipeline in Azure Data Factory is a logical grouping of activities—such as Copy, Data Flow, and stored procedure activities—that together accomplish a data integration task.
Question 15: Which columnar file format is natively optimized for Azure Data Lake Storage Gen2 and Azure Synapse Analytics analytics workloads?
- CSV
- JSON
- Parquet (Correct answer)
- XML
Correct answer: Parquet
Parquet is a columnar storage format that provides efficient compression and fast analytical query performance, and is natively supported across Azure analytics services including Synapse and Databricks.
Question 16: What is the key difference between Azure Data Factory's Copy Activity and Mapping Data Flow?
- Copy Activity supports transformation while Data Flow only copies data
- Copy Activity moves data without transformation; Data Flow performs complex transformations on Spark (Correct answer)
- Data Flow is only for real-time streaming; Copy Activity is for batch only
- Copy Activity uses Python scripts; Data Flow uses SQL only
Correct answer: Copy Activity moves data without transformation; Data Flow performs complex transformations on Spark
Copy Activity is optimized for high-throughput data movement without transformation logic, while Mapping Data Flow provides a visual, code-free transformation environment backed by Spark.
Question 17: What must be enabled on the source SQL Server to allow Azure Database Migration Service to perform an online (minimal-downtime) migration?
- Always On Availability Groups
- Change Data Capture (CDC) (Correct answer)
- SQL Server Replication
- Database mirroring
Correct answer: Change Data Capture (CDC)
Change Data Capture (CDC) must be enabled on the source SQL Server so that Azure Database Migration Service can continuously track and apply data changes during the online migration.
Question 18: Which Azure Data Factory Integration Runtime type enables lift-and-shift of on-premises SSIS packages to run in the cloud?
- Azure-SSIS Integration Runtime (Correct answer)
- Self-hosted Integration Runtime
- Azure IR with SSIS trigger
- SSIS Migration Assistant
Correct answer: Azure-SSIS Integration Runtime
Azure-SSIS Integration Runtime is a fully managed cluster that allows existing SSIS packages to be executed natively in Azure without modification.
Question 19: Which approach should you use in Azure Data Factory to implement incremental data loading from a relational source database?
- Full load with truncate-and-reload on each run
- Watermark column tracking or Change Data Capture (Correct answer)
- Snapshot isolation on the source database
- Read-only replica with full export
Correct answer: Watermark column tracking or Change Data Capture
Incremental loading requires a way to identify new or changed rows; ADF supports watermark columns (last-modified timestamps) and Change Data Capture for this purpose.
Question 20: Which Azure Data Factory Mapping Data Flow feature automatically handles new or changed columns in the source without requiring pipeline changes?
- Schema enforcement
- Schema drift (Correct answer)
- Manual schema mapping
- Dataset versioning
Correct answer: Schema drift
Schema drift in Mapping Data Flow allows the data flow to dynamically adapt to changes in the source schema—such as added or renamed columns—without failing or requiring manual updates.
Question 21: When designing an ADF pipeline to load data from multiple source files with the same structure in Azure Blob Storage, which feature reduces the need to create separate datasets per file?
- Dataset chaining
- Parameterized datasets with wildcard paths (Correct answer)
- Linked service arrays
- Multi-source Copy Activity
Correct answer: Parameterized datasets with wildcard paths
Parameterized datasets allow you to pass dynamic file paths (including wildcard patterns) at runtime, enabling a single dataset to target multiple files without duplicating dataset definitions.
DP-200 Azure Data Integration and Migration
Which Azure service is designed specifically to migrate on-premises databases to Azure with minimal downtime?
What Practice Test Geeks adds beyond an AI chat for DP-200
An AI chatbot can quiz you, but it can't reproduce the exam conditions or keep your record. Here you get:
- A timed, full-length DP-200 mock exam — 50 questions in 180 minutes with a 70% pass mark, modeled on the official exam's question count and time limit, followed by a score report broken down by exam domain.
- A fixed DP-200 question bank: the same test every attempt, so your score is comparable from one try to the next instead of changing with every regenerated quiz.
- Progress saved on your device: completed tests, scores and missed questions stay in My Progress, so you can retake only what you got wrong.
- A printable DP-200 cheat sheet you can print or save as a PDF.
- DP-200 flashcards built from the same question bank.
These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Eligibility, renewal, score validity, retake policy, passing score, score release, exam information · verified Nov 2026
- pearsonvue.com — Test delivery · verified Nov 2026