pbPassingBI
/
quicksight/quizzes/quicksight-quiz-viz
8 questions

Analyses & visuals — quiz

8 questions covering this module. Visual types, calculations, parameters and interactivity.

  1. Which computes revenue per customer regardless of visual grouping?

    1. sum(revenue)
    2. sumOver(sum({revenue}), [{customer_id}], PRE_AGG)
    3. runningSum(sum(revenue))
    4. percentOfTotal(sum(revenue))

    Answer: sumOver(sum({revenue}), [{customer_id}], PRE_AGG) — A level-aware aggregation pins the computation to customer_id independent of the visual.

  2. In runningSum, the third argument specifies:

    1. The sort order
    2. The partition where the calculation resets
    3. The aggregation type
    4. The filter

    Answer: The partition where the calculation resets — Partition defines reset boundaries; the second argument is the sort order.

  3. Numbers in one visual do not match the rest of the dashboard. Likely cause?

    1. SPICE lag
    2. Filter applied at single-visual scope
    3. Wrong visual type
    4. Missing geographic role

    Answer: Filter applied at single-visual scope — Scope determines which visuals a filter touches; a single-visual filter is easy to forget.

  4. Which action type passes a value to another sheet?

    1. Filter action
    2. Navigation action with parameters
    3. URL action
    4. AutoGraph

    Answer: Navigation action with parameters — Navigation actions move between sheets and can carry parameter values.

  5. Where is a visual configured in QuickSight?

    1. The format pane
    2. The field wells
    3. The dataset
    4. Parameters

    Answer: The field wells — They change depending on the visual type.

  6. Which usually reads better than five overlapping lines?

    1. A pie chart
    2. Small multiples
    3. A KPI visual
    4. A table

    Answer: Small multiples — One small chart per category on a shared scale.

  7. A parameter with a control appears to do nothing. Why?

    1. It needs SPICE
    2. Nothing references it yet
    3. Wrong data type
    4. It needs a refresh

    Answer: Nothing references it yet — A filter, calculation or action must use it.

  8. To let readers switch which metric a chart shows, use:

    1. A filter
    2. A parameter referenced in a calculated field
    3. Small multiples
    4. An insight

    Answer: A parameter referenced in a calculated field — One chart replaces three.