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

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 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 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 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

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 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

Azure-SSIS Integration Runtime is a fully managed cluster that allows existing SSIS packages to be executed natively in Azure without modification.

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

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.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Integration and Migration 3