QuestionQ87

VerifiedPrepare data

You are implementing a medallion architecture in one Fabric workspace.

A lakehouse contains the Bronze and Silver layers, and a warehouse contains the Gold layer.

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

Question Image

You need the layers to be populated daily and in sequence: populate Silver only after Bronze completes, and populate Gold only after Silver completes. The solution must minimize development effort and complexity.

What should you use to execute each set of items?

Each option may be used once, more than once, or not at all.

Drag & Drop
Orchestration pipeline:
Bronze layer:
Silver layer:
Gold layer:
Explanation

A scheduled Fabric pipeline provides the daily trigger. An Invoke pipeline activity orchestrates the existing Bronze pipelines, while success dependencies can sequence the Bronze, Silver, and Gold steps. A Dataflow activity runs Dataflow Gen2 for the Silver layer, and a Stored procedure activity executes the warehouse stored procedures for the Gold layer.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!