pbPassingBI
/
4 questions

Publishing & outputs — quiz

4 questions covering this module. Output steps, running flows, and scheduling.

  1. Which output gives a team one shared refreshed source?

    1. CSV
    2. Published data source
    3. .hyper on a shared drive
    4. Excel

    Answer: Published data source — Every workbook connecting to it gets the refresh.

  2. Your output table doubled after the second run. Cause?

    1. A fan-out
    2. The write option was set to Append
    3. Wrong join type
    4. Sampling

    Answer: The write option was set to Append — Use create/replace unless the flow only handles new rows.

  3. Which is needed to schedule flows on Server?

    1. Nothing extra
    2. Prep Conductor
    3. Desktop
    4. A published data source

    Answer: Prep Conductor — Or drive the command line from an external scheduler.

  4. Incremental refresh is blind to:

    1. New rows
    2. Rows updated or deleted after they were loaded
    3. Nulls
    4. Text fields

    Answer: Rows updated or deleted after they were loaded — Hence a periodic full refresh alongside it.