pbPassingBI
/
tableau/quizzes/tableau-quiz-2
intermediate 10 questions

Tableau Quiz 2

Filters, parameters and how they differ.

  1. What does a context filter do?

    1. Filters only the current sheet
    2. Creates a temporary table that later filters operate on
    3. Filters the workbook on open
    4. Removes null values

    Answer: Creates a temporary table that later filters operate on — Tableau materialises a temporary table for the context filter; all other filters then work on that subset.

  2. Which is a genuine limitation of context filters?

    1. They cannot be used on dates
    2. The temporary table reloads each time, costing time
    3. They only work on extracts
    4. They cannot be combined with parameters

    Answer: The temporary table reloads each time, costing time — Placing a filter in context has a real cost because the temp table is rebuilt when it changes.

  3. Parameters differ from filters because:

    1. Parameters are faster
    2. Users supply a value that can be used in calculations
    3. Parameters filter rows directly
    4. Parameters only accept dates

    Answer: Users supply a value that can be used in calculations — A filter restricts data; a parameter supplies a value that calculations, filters or reference lines can use.

  4. A classic (non-dynamic) parameter allows:

    1. Multiple value selection
    2. A single value at a time
    3. Only integers
    4. Only dimensions

    Answer: A single value at a time — Classic parameters are single-value; that is one of their stated limitations.

  5. Quick filters are best described as:

    1. Filters applied at the data source
    2. Controls letting users change filter values at run time
    3. Filters that always use context
    4. Extract-level filters

    Answer: Controls letting users change filter values at run time — Quick filters expose the filter to the user so values can be changed dynamically.

  6. Which filter type would you use to return the top 10 values in a view?

    1. Context filter
    2. Top filter
    3. Quick filter
    4. Extract filter

    Answer: Top filter — A Top filter (by field or formula) returns the highest N values.

  7. To compute the top 10 within a specific region, you should:

    1. Use two top filters
    2. Put the region filter in context
    3. Use a parameter
    4. Sort descending

    Answer: Put the region filter in context — Without context, both are dimension filters and the top 10 is computed across all regions first.

  8. Can parameters have a dropdown list?

    1. No
    2. Yes
    3. Only for dates
    4. Only on Server

    Answer: Yes — Parameters can present their allowable values as a dropdown list.

  9. Where can global filters be used?

    1. Only in worksheets
    2. In sheets, dashboards and stories
    3. Only in dashboards
    4. Only on Server

    Answer: In sheets, dashboards and stories — Global filters apply across sheets, dashboards and stories.

  10. How do you remove the "All" option from an auto-filter?

    1. Delete the filter
    2. Customize → uncheck Show "All" Value
    3. Use a context filter
    4. Convert to a parameter

    Answer: Customize → uncheck Show "All" Value — The dropdown arrow on the filter heading has a Customize menu containing that option.