Tableau Consultant Practice Questions
Prepare for Analytics-Con-301 with more than an answer.
- 1
In Tableau Server, which permission rule logic is applied when a user belongs to two groups, where Group A is 'Denied' capability X, and Group B is 'Allowed' capability X, and the user has no explicit user-level permissions set?
Show answer details
Correct answer: A
In Tableau's permission model, an explicit 'Deny' always overrides an 'Allow' derived from another group. The hierarchy is: 1. Administrator/Owner (Super) -> 2. Explicit User Deny -> 3. Explicit User Allow -> 4. Explicit Group Deny -> 5. Explicit Group Allow.
- 2
You have a dashboard containing a map and a list. You want to configure a Dashboard Action such that selecting a state on the map filters the list, but deselecting the state (clicking the background) restores the list to show all values. Which setting in the 'Edit Filter Action' dialog controls this behavior?
Show answer details
Correct answer: C
The 'Clearing the selection will' option determines what happens when the action trigger is removed. 'Show all values' restores the target sheet to its unfiltered state.
- 3
Select TWO features that are unique to Tableau Prep Builder compared to the Data Source tab in Tableau Desktop. (Select TWO)
Show answer details
Correct answer: B, D
Prep provides a visual profile pane showing distribution histograms for all fields at every step, allowing for immediate data quality assessment.
Tableau Prep allows you to aggregate data (GROUP BY) in the middle of a flow and continue processing or output that aggregated data. Desktop aggregates primarily for visualization.
- 4
A client, RetailCo, has a Snowflake database containing 500 million transaction rows. They require a dashboard that allows store managers to view daily performance with sub-second response times. However, the data warehouse team only allows updates once every 24 hours at midnight. Which data connection strategy provides the best performance while meeting the data freshness requirement?
Show answer details
Correct answer: D
For large datasets (500M rows) where data is static throughout the day, an Extract offers superior query performance compared to a Live connection. Since the data only changes once every 24 hours, an Incremental Refresh scheduled after the warehouse load ensures data currency without the overhead of querying the live database for every user interaction.
- 5
You are designing a data model in Tableau Desktop using the Logical Layer (Relationships). You have a 'Sales' table at the transaction level and a 'Targets' table at the monthly level. When you drag 'Targets' into the canvas to relate it to 'Sales', which behavior should you expect regarding row duplication?
Show answer details
Correct answer: C
Relationships (the 'noodle' connections in the Logical Layer) differ from physical joins. They do not merge tables into a single flat table immediately. Instead, Tableau queries them independently at the appropriate level of detail during analysis, ensuring that measures from the 'Targets' table (monthly) are not duplicated for every row in the 'Sales' table (transactional).
- 6
A consultant is troubleshooting a dashboard where a 'Top 10 Customers' filter is ignoring the selection made in a 'Region' filter. The user wants to see the Top 10 Customers specifically for the selected Region, but currently, it shows the Top 10 Global customers and then hides those not in the selected Region. How should the consultant resolve this based on the Order of Operations?
Show answer details
Correct answer: D
In Tableau's Order of Operations, Dimension Filters are applied after Top N filters. This means the Top 10 are calculated on the entire dataset first, and then the Region filter hides rows. By adding the Region filter to Context, it moves up the pipeline (before Top N), ensuring the Top 10 are calculated within the filtered subset.
flowchart TD A[Extract Filters] --> B[Data Source Filters] B --> C[Context Filters] C --> D[Fixed LODs] D --> E[Top N Filters] E --> F[Dimension Filters] style C fill:#f9f,stroke:#333,stroke-width:2px style E fill:#bbf,stroke:#333,stroke-width:2px
