Publishing & outputs — quiz
4 questions covering this module. Output steps, running flows, and scheduling.
Which output gives a team one shared refreshed source?
- CSV
- Published data source
- .hyper on a shared drive
- Excel
Answer: Published data source — Every workbook connecting to it gets the refresh.
Your output table doubled after the second run. Cause?
- A fan-out
- The write option was set to Append
- Wrong join type
- Sampling
Answer: The write option was set to Append — Use create/replace unless the flow only handles new rows.
Which is needed to schedule flows on Server?
- Nothing extra
- Prep Conductor
- Desktop
- A published data source
Answer: Prep Conductor — Or drive the command line from an external scheduler.
Incremental refresh is blind to:
- New rows
- Rows updated or deleted after they were loaded
- Nulls
- Text fields
Answer: Rows updated or deleted after they were loaded — Hence a periodic full refresh alongside it.