Analytics-DA-201 - Explore and Analyze Data (41% of the exam) - Section 2.5
Create parameters to drive interactivity in calculations, filters, and reference lines, and set parameters to refresh dynamically.
Practice question for this objective
lock_openFree sampleExplore and Analyze Datamedium
An analyst at Greendale Cycles builds a dashboard where clicking a bar in a regional sales chart should add the clicked customers to a set named 'Focus Cohort', and a second highlight worksheet should then react to that membership. The analyst configures a set action with the source sheet as the sales chart and the target set as 'Focus Cohort'. Which two statements about how this set action behaves are correct? Select TWO.
AWhen 'Add to set' is chosen as the running-action behaviour, each new selection appends marks to the set rather than replacing the previous members.check_circle Correct
BThe set action permanently rewrites the underlying data source rows so the membership survives even after the workbook is closed and reopened.
CClearing the selection can reset the set to a defined value when the 'Clearing the selection will' option is set to keep, add to, or remove from the set.check_circle Correct
DA set action is restricted to a fixed set whose members were typed in by hand, so a condition-based set cannot be a valid target.
EBecause a set is binary, the target set must be split into two new sets before any set action will run against it on the dashboard.
Explain how set actions drive in-session set membership from user selection, including additive behaviour and the configurable response to clearing a selection. A set action updates the target set's membership in response to selection on a source sheet, and it works entirely in the view layer without touching source rows. The running-action behaviour can be set to add marks so the cohort accumulates, and a separate option governs what happens to membership when the selection is cleared, letting the analyst keep, extend, or empty the set.
Why A is correct: Set actions offer 'Add to set' so successive selections accumulate members, which is exactly how an additive Focus Cohort is built up across clicks.
Why B is wrong: This sounds plausible because set members persist in the view, but set actions only change in-session set membership and never alter source rows.
Why C is correct: The deselection setting controls what membership the set returns to on clearing, which is a genuine option in the set action dialog.
Why D is wrong: It is tempting because conditions feel separate, but a set action overwrites whatever members the target set holds regardless of how it was first defined.
Why E is wrong: Sets are indeed in-or-out, yet that binary nature is what a single set action drives directly, so no splitting into two sets is required.
Answers that look right on this material and are not. Each one is a distractor from a different question in the Analytics-DA-201 bank for this domain.
FIXED is computed after all dimension filters, so any dimension filter on the view always narrows the records the FIXED value sees.
errorWhy it is wrong: This describes how INCLUDE and EXCLUDE behave; FIXED is computed before ordinary dimension filters, so it is the opposite of what is stated here.
The hand-typed list updates on every refresh, whereas the field-backed list must be edited manually whenever the field gains new values.
errorWhy it is wrong: This reverses the two behaviours; it is the field-backed list that updates automatically, not the hand-typed one.
The customer stays out of the set because computed set membership is fixed at the moment the set is created.
errorWhy it is wrong: This describes a constant (manual) set, where members are picked individually and frozen. A set defined by a condition is computed, so this is a tempting but incorrect generalisation.