Analytics-DA-201 - Explore and Analyze Data (41% of the exam) - Section 2.6
Structure data using sets, bins, hierarchies, and groups.
Practice question for this objective
lock_openFree sampleExplore and Analyze Datamedium
Larkfield Logistics has a workbook of six worksheets built on one shared data source. An analyst sets a [Carrier] dimension filter on the first worksheet, then opens the filter card menu and chooses Apply to Worksheets, then All Using This Data Source. Which TWO statements correctly describe how this scoped filter then behaves? Select TWO.
AThe same [Carrier] filter selection is shared by every existing worksheet that is built on that one data source, kept in step across them.check_circle Correct
BA new worksheet added later on the same data source inherits the [Carrier] filter automatically, because the scope follows the data source not the sheets.check_circle Correct
CWorksheets built on a different data source in the same workbook are also filtered by [Carrier] as long as they contain a matching field.
DThe setting silently converts the [Carrier] filter into a data source filter that removes the excluded carriers before any worksheet queries run.
EEach worksheet keeps its own independent copy of the [Carrier] filter, so changing it on one sheet leaves the others on their previous selection.
Determine how a filter scoped to All Using This Data Source shares its selection across current and future worksheets on the same data source. All Using This Data Source attaches the filter to the data source rather than to one sheet, so every worksheet on that source, including ones created later, shares a single synchronised filter state. It does not reach across to a separate data source and it is distinct from a data source filter, which removes rows before queries run rather than at sheet scope.
Why A is correct: All Using This Data Source binds the worksheets to one shared filter state, so a change on any of them updates the others together.
Why B is correct: Because the scope is tied to the data source, sheets created afterwards on that source pick up the existing shared filter without manual reapplication.
Why C is wrong: This sounds plausible but the scope is limited to the one data source, so sheets on a separate source are untouched even with a like-named field.
Why D is wrong: Apply to Worksheets is a sheet-scope option, not a data source filter, so it does not change the extract-level or pre-query filtering layer.
Why E is wrong: That describes the default Only This Worksheet scope, which is exactly the behaviour this All Using This Data Source choice overrides.
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.
The filter ignores the new worksheet because Apply to Worksheets only ever affects sheets that existed when the scope was set.
errorWhy it is wrong: This is a common assumption but wrong: the data-source scope is dynamic, so sheets added afterwards are still covered, unlike the Selected Worksheets scope which is fixed.
Only the worksheet where the filter was created is affected, and each other sheet must have the same filter recreated by hand.
errorWhy it is wrong: Tempting because filters are local by default, but choosing All Using This Data Source deliberately removes that per-sheet limitation.
The bin size sets the total number of bins created, and Tableau divides the field's range evenly across that many bins.
errorWhy it is wrong: This is a common misreading: the bin size sets the width of each interval, not the count of bins, so treating it as a bin count is wrong.