VendorsExamsEnterprise
Support
Request an ExamContact UsFAQ

Tableau Consultant Free Sample Questions

12 free sample questions120 in the full practice test

Try simulator

Analytics-Con-301 Sample Questions

  1. Question 1

    Intermediate

    Data Architecture · Connection Types

    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?

    Answer and explanation

    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.

  2. Question 2

    Intermediate

    Data Modeling · Relationships vs Joins

    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?

    Answer and explanation

    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).

  3. Question 3

    Advanced

    Calculations · Order of Operations

    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?

    Answer and explanation

    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

  4. Question 4

    AdvancedMultiple answers

    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)

    Answer and 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.

  5. Question 5

    Intermediate

    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?

    Answer and 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).

  6. Question 6

    Beginner

    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.

    Answer and 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.

Register free for 6 more questions

Or unlock all 120 Analytics-Con-301 questions with explanations, timed mode and flashcards.

Related practice tests

All Salesforce practice exams