Q: 17
You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1.
Dataflow1 returns 500 rows of data.
You need to identify the min and max values for each column in the query results.
Which three Data view options should you select? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.
Options
Discussion
Orchestration pipeline -> schedule, Bronze -> Invoke pipeline activity, Silver -> Dataflow activity, Gold -> Stored procedure activity
Yeah, matches my thinking: schedule for orchestration, invoke for Bronze, dataflow for Silver, stored proc for Gold.
Orchestration pipeline: schedule, Bronze: Invoke pipeline activity, Silver: Dataflow activity, Gold: Stored procedure activity.
This matches what I've seen in similar exam reports. Using schedule for orchestration keeps things simple and lets each step trigger the right process for that layer. Pretty sure this is the minimal effort path. Agree?
If the Silver layer had any extra dependencies (like a manual approval before running), this whole mapping could change. But since it just wants minimal effort and sequential population, schedule for orchestration, then pipeline invoke/dataflow/stored proc fits. Seen similar logic in other practice sets.
Matches what I've seen in practice: schedule for orchestration, invoke pipeline for Bronze, dataflow for Silver, stored proc for Gold.
I don’t think D fits here. From what I remember, Show column value distribution just gives you a quick visual, not min/max specifics. Isn’t A (Show column quality details) more likely if you want details on data range? If someone’s used this in Power Query lately, let me know if I’ve got that wrong.
Be respectful. No spam.
