pbPassingBI
/
tableau/quizzes/tableau-hands-on
intermediate 10 questions

Hands-on Practice

Applied tasks — what you would actually click.

  1. You need sales by month with every year pooled together. Use:

    1. Continuous MONTH(Order Date)
    2. Discrete MONTH(Order Date)
    3. Exact date
    4. YEAR(Order Date)

    Answer: Discrete MONTH(Order Date) — A discrete date part gives twelve month headers regardless of year — the seasonality view.

  2. To show profit and sales on the same chart with independent scales:

    1. Add both to Rows
    2. Create a dual axis
    3. Use a filter
    4. Use the Pages shelf

    Answer: Create a dual axis — Dual axis layers two independent axes. Synchronise them if the units match.

  3. You want to see the top 5 and bottom 5 products in one view. Approach:

    1. Two worksheets
    2. Create two sets and combine them
    3. Two dashboards
    4. A context filter

    Answer: Create two sets and combine them — Build a top 5 set and a bottom 5 set, then combine them into a single 10-row view.

  4. To view the SQL Tableau is generating, you would:

    1. Open the .twb in a text editor
    2. Start a Performance Recording or check the logs
    3. Use Show Me
    4. Publish to Server

    Answer: Start a Performance Recording or check the logs — Help → Settings and Performance → Start Performance Recording, or read the Tableau Desktop logs.

  5. To add a custom colour palette you edit:

    1. The .twb file
    2. Preferences.tps in My Tableau Repository
    3. The .tds file
    4. The extract

    Answer: Preferences.tps in My Tableau Repository — Preferences.tps is XML; restart Desktop after saving, then Edit Colors on the legend.

  6. You need a field grouping several dimension members into buckets. Use:

    1. A set
    2. A group
    3. A parameter
    4. A bin

    Answer: A group — Groups combine members into higher-level categories.

  7. You need "top 10 customers" to stay correct as data changes. Use:

    1. A group
    2. A dynamic set
    3. An alias
    4. A static filter

    Answer: A dynamic set — Dynamic sets re-evaluate their condition, so membership tracks the data.

  8. To display an image in a dashboard that filters other sheets when clicked:

    1. A URL action
    2. An image object with a filter action
    3. A parameter
    4. A story point

    Answer: An image object with a filter action — Add the image, then configure a filter action triggered by selecting it.

  9. To combine a database table with a flat file in one data source:

    1. Blend only
    2. Connect to both and define the relationship or join on a common column
    3. Publish first
    4. Use a parameter

    Answer: Connect to both and define the relationship or join on a common column — Connect twice, then join on the common column or edit the relationship.

  10. The NOW() function returns:

    1. Today's date only
    2. The current date and time
    3. The workbook creation date
    4. A string

    Answer: The current date and time — NOW() returns current date and time; TODAY() returns the date alone.