← Back to exam page

DP-203 – Data Engineering on Microsoft Azure

Loading demo links...

Showing 19–20 of 20 questions

Question 19 (New Update)

You have the following Azure Data Factory pipelines

• ingest Data from System 1

• Ingest Data from System2

• Populate Dimensions

• Populate facts

ingest Data from System1 and Ingest Data from System1 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System* Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.

What should you do to schedule the pipelines for execution?

Select an option, then click Submit answer.

  • ○

    Add an event trigger to all four pipelines.
  • ○

    Create a parent pipeline that contains the four pipelines and use an event trigger.
  • ○

    Create a parent pipeline that contains the four pipelines and use a schedule trigger.
  • ○

    Add a schedule trigger to all four pipelines.
Question 20 (Mixed Questions)

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.

You plan to insert data from the files in container1 into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.

You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.

Solution: You use a dedicated SQL pool to create an external table that has an additional DateTime column.

Does this meet the goal?

Select an option, then click Submit answer.

  • ○

    Yes
  • ○

    No