DP-203 Drag & Drop — 10 Questions

Question 1

Drag and drop the steps to implement Azure Data Lake Storage Gen2 lifecycle management to move data to cool and archive tiers into the correct order.

Accepted Answer

Create Azure Data Lake Storage Gen2 account, then define a lifecycle management rule with conditions and actions, then apply the rule to the account, then verify data movement.. After creating the account, define a lifecycle rule with conditions and actions, then apply it.

Answer

Define a lifecycle management rule, then create an Azure Data Lake Storage Gen2 account, then apply the rule, then verify data movement.

Answer

Create Azure Data Lake Storage Gen2 account, then apply a lifecycle management rule, then define the rule conditions and actions, then verify data movement.

Answer

Define a lifecycle management rule, then apply it to the account, then create the Azure Data Lake Storage Gen2 account, then verify data movement.

Question 2

Drag and drop the steps to implement incremental data loading using Azure Data Factory into the correct order.

Accepted Answer

Lookup the last watermark value from control table, then copy data from source where timestamp > watermark, then update watermark with max timestamp from copied data.. Incremental loading requires a watermark column. The pipeline retrieves the last watermark, copies data changed since then, then updates the watermark for next run.

Answer

Copy data from source, then lookup the last watermark value, then update watermark.

Answer

Update watermark with max timestamp from source, then lookup the last watermark, then copy data.

Answer

Lookup the last watermark value, then update watermark with max timestamp, then copy data.

Question 3

Drag and drop the steps to set up Azure Data Factory pipeline with parameterization and dynamic expressions into the correct order.

Accepted Answer

Step 1: Create the pipeline. Step 2: Define parameters. Step 3: Use parameters in activities and linked services. Step 4: Trigger pipeline with parameter values.. Create the pipeline, define parameters, use them in activities and linked services, then trigger with values.

Answer

Step 1: Define parameters. Step 2: Create the pipeline. Step 3: Use parameters in activities and linked services. Step 4: Trigger pipeline with parameter values.

Answer

Step 1: Create the pipeline. Step 2: Use parameters in activities and linked services. Step 3: Define parameters. Step 4: Trigger pipeline with parameter values.

Answer

Step 1: Trigger pipeline with parameter values. Step 2: Create the pipeline. Step 3: Define parameters. Step 4: Use parameters in activities and linked services.

Question 4

Drag and drop the steps to convert data from CSV to Parquet format using Azure Data Factory into the correct order.

Accepted Answer

Define source CSV dataset, then define sink Parquet dataset, then create copy activity with mapping, then run and monitor.. Define source (CSV) and sink (Parquet) datasets, then a copy activity with mapping, run, and monitor.

Answer

Define sink Parquet dataset, then define source CSV dataset, then create copy activity with mapping, then run and monitor.

Answer

Define source CSV dataset, then create copy activity with mapping, then define sink Parquet dataset, then run and monitor.

Answer

Create copy activity with mapping, then define source CSV dataset, then define sink Parquet dataset, then run and monitor.

Question 5

Drag and drop the steps to set up Azure Purview for data cataloging and lineage tracking into the correct order.

Accepted Answer

Create Azure Purview account, then Register data sources, then Scan data sources, then Set classifications, then Explore catalog. First create the Purview account, then register sources, scan them, set classifications, and finally explore the catalog.

Answer

Create Azure Purview account, then Register data sources, then Set classifications, then Scan data sources, then Explore catalog

Answer

Register data sources, then Create Azure Purview account, then Scan data sources, then Set classifications, then Explore catalog

Answer

Create Azure Purview account, then Scan data sources, then Register data sources, then Set classifications, then Explore catalog

Question 6

Drag and drop the steps to implement Slowly Changing Dimension (SCD) Type 2 in Azure Synapse Analytics dedicated SQL pool into the correct order.

Accepted Answer

Stage data, then identify changes, then expire old records, then insert new versions.. SCD Type 2: stage data, merge to find changes, expire old records, insert new versions, and update attributes (if needed).

Answer

Stage data, then insert new versions, then expire old records.

Answer

Identify changes, then stage data, then expire old records, then insert new versions.

Answer

Stage data, then expire old records, then identify changes, then insert new versions.

Question 7

Drag and drop the steps to set up Azure Data Lake Storage Gen2 hierarchical namespace for a data lake into the correct order.

Accepted Answer

Enable hierarchical namespace on storage account, create a container, create directories, set permissions, upload data.. The storage account must have hierarchical namespace enabled. Then create a container, directories, set permissions, and upload data.

Answer

Enable hierarchical namespace on storage account, create directories, create a container, set permissions, upload data.

Answer

Enable hierarchical namespace on storage account, create a container, set permissions, create directories, upload data.

Answer

Create a container, enable hierarchical namespace on storage account, create directories, set permissions, upload data.

Question 8

Drag and drop the steps to configure Azure Stream Analytics job with event input and Power BI output into the correct order.

Accepted Answer

Step 1: Set up Event Hub as data source, Step 2: Create Stream Analytics job, Step 3: Configure input (Event Hub), Step 4: Configure output (Power BI), Step 5: Write the query, Step 6: Start the job. First, set up the event hub as the data source. Then create the Stream Analytics job, configure input and output, write the query, and start it.

Answer

Step 1: Set up Event Hub as data source, Step 2: Configure input (Event Hub), Step 3: Create Stream Analytics job, Step 4: Configure output (Power BI), Step 5: Write the query, Step 6: Start the job

Answer

Step 1: Set up Event Hub as data source, Step 2: Create Stream Analytics job, Step 3: Configure output (Power BI), Step 4: Configure input (Event Hub), Step 5: Write the query, Step 6: Start the job

Answer

Step 1: Set up Event Hub as data source, Step 2: Create Stream Analytics job, Step 3: Configure input (Event Hub), Step 4: Write the query, Step 5: Configure output (Power BI), Step 6: Start the job

Question 9

Drag and drop the steps to configure Azure Databricks auto-scaling cluster for ETL workloads into the correct order.

Accepted Answer

Create Azure Databricks workspace, then configure cluster auto-scaling settings, then select runtime version, then attach libraries, then set cluster policies.. First create the workspace, then the cluster with auto-scaling settings, choose runtime, attach libraries, and set policies.

Answer

Create Azure Databricks workspace, then select runtime version, then configure cluster auto-scaling settings, then attach libraries, then set cluster policies.

Answer

Configure cluster auto-scaling settings, then create Azure Databricks workspace, then select runtime version, then attach libraries, then set cluster policies.

Answer

Create Azure Databricks workspace, then configure cluster auto-scaling settings, then attach libraries, then select runtime version, then set cluster policies.

Question 10

Drag and drop the steps to configure Azure Synapse Analytics serverless SQL pool to query data in Azure Data Lake Storage Gen2 into the correct order.

Accepted Answer

Set up the storage account and data, then create the serverless SQL pool, then create a database, then create an external data source referencing the storage, and finally create an external file format and external table.. First, set up the storage account and data. Then create the serverless SQL pool, a database, external data source referencing the storage, and finally external file format and external table to query.

Answer

Create the serverless SQL pool, then set up the storage account and data, then create a database, then create an external data source, and finally create an external table.

Answer

Create a database, then create an external data source, then create an external file format, then create an external table, and finally set up the storage account and data.

Answer

Set up the storage account and data, then create a database, then create an external data source, then create an external file format, then create an external table, and finally create the serverless SQL pool.