DP-200 Azure Data Integration and Migration 3

Question 1

Which columnar file format is natively optimized for Azure Data Lake Storage Gen2 and Azure Synapse Analytics analytics workloads?

Accepted Answer

Parquet

Answer

CSV

Answer

JSON

Answer

XML

Question 2

What is the key difference between Azure Data Factory's Copy Activity and Mapping Data Flow?

Accepted Answer

Copy Activity moves data without transformation; Data Flow performs complex transformations on Spark

Answer

Copy Activity supports transformation while Data Flow only copies data

Answer

Data Flow is only for real-time streaming; Copy Activity is for batch only

Answer

Copy Activity uses Python scripts; Data Flow uses SQL only

Question 3

What must be enabled on the source SQL Server to allow Azure Database Migration Service to perform an online (minimal-downtime) migration?

Accepted Answer

Change Data Capture (CDC)

Answer

Always On Availability Groups

Answer

SQL Server Replication

Answer

Database mirroring

Question 4

Which Azure Data Factory Integration Runtime type enables lift-and-shift of on-premises SSIS packages to run in the cloud?

Accepted Answer

Azure-SSIS Integration Runtime

Answer

Self-hosted Integration Runtime

Answer

Azure IR with SSIS trigger

Answer

SSIS Migration Assistant

Question 5

Which approach should you use in Azure Data Factory to implement incremental data loading from a relational source database?

Accepted Answer

Watermark column tracking or Change Data Capture

Answer

Full load with truncate-and-reload on each run

Answer

Snapshot isolation on the source database

Answer

Read-only replica with full export

Question 6

Which Azure Data Factory Mapping Data Flow feature automatically handles new or changed columns in the source without requiring pipeline changes?

Accepted Answer

Schema drift

Answer

Schema enforcement

Answer

Manual schema mapping

Answer

Dataset versioning

Question 7

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?

Accepted Answer

Parameterized datasets with wildcard paths

Answer

Dataset chaining

Answer

Linked service arrays

Answer

Multi-source Copy Activity