Exam DP-600 All Questions

View all questions & answers for the DP-600 exam

Exam DP-600 topic 1 question 70 discussion

Actual exam question from Microsoft's DP-600

Question #: 70
Topic #: 1

DRAG DROP
-

You are implementing a medallion architecture in a single Fabric workspace.

You have a lakehouse that contains the Bronze and Silver layers and a warehouse that contains the Gold layer.

You create the items required to populate the layers as shown in the following table.

You need to ensure that the layers are populated daily in sequential order such that Silver is populated only after Bronze is complete, and Gold is populated only after Silver is complete. The solution must minimize development effort and complexity.

What should you use to execute each set of items? To answer, drag the appropriate options to the correct items. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by Nefirs at April 19, 2024, 10:03 a.m.

Comments

Submit Cancel

c8f5bdf

Highly Voted 11 months ago

Bronze Layer answer is wrong. the Bronze Layer already has pipeline defined with it so you need an invoke pipeline activity to call them

upvoted 28 times

...

vernillen

Highly Voted 9 months, 3 weeks ago

Should be; Orchestration pipeline: Schedule Bronze layer: An invoke pipeline activity (see table -> PIPELINE is already there) Silver: Dataflow activity Gold: Stored procedure activity

upvoted 13 times

...

BRW

Most Recent 5 months ago

• Orchestration Pipeline: Invoke pipeline activity - because the requirement is to update each layer in a sequence. So orchestration pipeline invokes Bronze, Silver and Gold pipelines one after another. • Bronze Layer: Invoke pipeline activity - because there are multiple pipelines with Copy activity in this layer. We must group them together in one Bronze Layer pipeline • Silver Layer: A pipeline Dataflow activity • Gold Layer: A pipeline Stored procedure activity Schedule is type of trigger not a pipeline

upvoted 6 times

...

AbhiShar

5 months, 3 weeks ago

Orchestration pipeline: Use An Invoke pipeline activity to manage the orchestration and invoke other pipelines in the correct sequence. Bronze layer: Use A pipeline Copy activity because the Bronze layer typically involves raw data ingestion, where data is copied into the lakehouse. Silver layer: Use A pipeline Dataflow activity as this layer involves transforming and cleaning the data, for which Dataflows are typically used. Gold layer: Use A pipeline Stored procedure activity because the Gold layer often involves aggregations and advanced processing, which can be handled using stored procedures in a warehouse.

upvoted 2 times

BRW

5 months ago

Agree. Bronze, Silver and Gold pipelines are invoked in parent orchestration pipeline

upvoted 1 times

...

byyleoo

9 months, 4 weeks ago

I also think that bronze is wrong. Since the pipeline with Copy activities is already created, we just need an invoke pipeline to trigger it

upvoted 3 times

...

PaweuG

10 months ago

Orchestration: A schedule Bronze Layer: An invoke pipeline activity (the actual pipeline is already there) Silver Layer: A pipeline Dataflow activity Gold Layer: A pipeline Stored Procedure activity

upvoted 4 times

...

282b85d

10 months ago

• Orchestration Pipeline: A schedule • Bronze Layer: A pipeline Copy activity • Silver Layer: A pipeline Dataflow activity • Gold Layer: A pipeline Stored procedure activity