Analytics-Con-301 Sample Questions & Answers
Free Tableau Consultant practice questions with worked answers and explanations. See how the ExamJungle simulator prepares you — then jump into the full test.
Launch the full Analytics-Con-301 simulator →Showing 6 of 12 free samples.
- Question 1AdvancedSelect 2
Data Architecture · Joins vs Relationships
Which TWO scenarios would strictly require the use of a Physical Join (or Custom SQL) instead of Logical Relationships in the Data Source tab? (Select TWO)
Show answer & explanation
Correct answers: C, D
While Relationships support most join logic, specific requirements for a forced Full Outer Join or specific join clauses often require dropping into the Physical Layer.
RLS often relies on 'exploding' rows when a user has multiple roles or entitlements (Row Multiplication), which is a behavior of physical joins. Relationships attempt to preserve the native level of detail and avoid duplication, which can break RLS models dependent on row multiplication.
- Question 2Intermediate
Calculations · LOD Expressions
You need to calculate the average sales per customer, and then average those values per region. Which Level of Detail (LOD) expression structure achieves this?
Show answer & explanation
Correct answer: B
This expression first calculates the total sales for each customer (inner aggregation) regardless of the view level, and then the outer aggregation (AVG) averages those customer totals based on the dimensions in the view (Region).
- Question 3Beginner
Data Preparation · Tableau Prep
True or False: When using a 'Wildcard Union' in Tableau Prep Builder to combine multiple Excel files from a folder, the schemas (column names and data types) of all files must match exactly, otherwise the flow will fail immediately.
Show answer & explanation
Correct answer: B
False. Tableau Prep (and Desktop) Wildcard Union is permissive. If columns do not match, it will union the matching columns and create nulls for the mismatched columns in the respective rows. It does not fail immediately; it creates a superset of all columns.
- Question 4Advanced
Calculations · LOD Expressions
Case Study:
A healthcare provider uses Tableau to track patient readmissions. The data model consists of a 'Patients' table and an 'Admissions' table.
Requirement 1: The dashboard must show the readmission rate, defined as the percentage of patients admitted more than once within a 30-day window.
Requirement 2: The user needs to filter by 'Hospital Wing', but the readmission classification (Yes/No) must be calculated based on the patient's total history across ALL wings, not just the selected one.Which solution correctly addresses Requirement 2?
Show answer & explanation
Correct answer: D
A FIXED LOD expression is calculated before Dimension filters (unless they are in Context). By using {FIXED [Patient ID]...}, Tableau calculates the total admissions for the patient across the entire dataset. When the user filters by 'Hospital Wing', the view is filtered, but the patient's classification as 'Readmitted' remains consistent based on their global history.
- Question 5Intermediate
Dashboards · Layout Containers
You are creating a dashboard that requires a 'Sheet Swapping' parameter to toggle between a Map view and a Bar Chart view. After setting up the parameter and the calculated field for filtering, you place both sheets in a container. However, when you toggle the parameter, the hidden sheet leaves a large blank space, preventing the active sheet from expanding to fill the container. What is the most likely cause?
Show answer & explanation
Correct answer: C
In Tableau, if a sheet title is visible, the sheet takes up space even when no data is returned by the filter. To make sheet swapping work seamlessly (collapsing the hidden sheet entirely), you must hide the Title of the sheet. You can use a dynamic text object or a separate sheet for the title if needed.
- Question 6Advanced
Performance · Dashboard Optimization
A user reports that a specific dashboard is loading very slowly. Performance Recording shows that the 'Computing Layout' phase is taking the longest time. Which dashboard design element is the most likely contributor to this specific performance bottleneck?
Show answer & explanation
Correct answer: D
The 'Computing Layout' phase involves the client-side rendering engine calculating the position of every object. Deeply nested containers, tiling many small objects, or complex dashboard structures significantly increase this time. Simplifying the hierarchy and using floating objects where appropriate can help.
Ready for the real thing?
The full Analytics-Con-301 simulator has every exam-style question, timed mode, and instant scoring.