Tableau (Salesforce) · Free Practice Questions · Last reviewed May 2026
18real exam-style questions organised by domain, each with the correct answer highlighted and a plain-English explanation of why it's right — and why the others are wrong.
An analyst builds a view showing Sales by Region using a live connection to a massive enterprise data warehouse. The dashboard feels sluggish during filtering. Which architectural component processes the query generation and executes the heavy lifting in this live connection setup?
The Tableau Data Engine processes the query natively in memory before sending requests to the database backend.
The VizQL Server translates visual specifications into database execution plans and caches the returned result sets.
The connected database management system executes the query and returns aggregated result sets to Tableau.
Live connections rely completely on the external database management system to process queries, apply filters, and compute aggregations. Tableau constructs standard SQL statements matching the visualization requirements and passes them directly to the database engine for execution and processing.
The Backgrounder service intercepts the dashboard filters and streams pre-calculated data blocks asynchronously.
A user needs to understand the core difference between a live connection and an extract in Tableau. Which scenario best dictates the use of an extract?
When the underlying data source requires real-time updates every second.
When the data source is a small, static CSV file with no performance issues.
When you need to perform complex calculations on a large dataset without impacting database performance.
Extracts utilize Tableau's high-performance data engine, which is optimized for complex calculations and aggregations. By pulling the data into an extract, you offload the heavy computational burden from the primary production database, ensuring that analytical processing does not slow down operational source systems.
When you want to ensure that security permissions are applied directly at the database level for every view.
What is the primary function of a 'Set' in Tableau?
To change the connection type of a data source.
To create a custom group of data points based on defined criteria.
Sets create a dynamic 'in' or 'out' classification for data points. This allows for flexible comparisons, such as comparing the sales of a specific group of products against the rest of the product line, which is a key requirement for performing advanced comparative data analysis.
To automatically join two separate data tables.
To format the axis of a bar chart.
Why would you use a 'Group' instead of a 'Set' when preparing data in Tableau?
To create a dynamic category that updates based on a calculation.
To combine multiple dimension members into a single, fixed category.
Groups are ideal for creating a static, fixed consolidation of members. For example, grouping several individual states into a single 'Region' category is a classic use case. This simplifies the view and creates a new categorical field that can be used consistently across multiple different visualizations.
To perform a spatial join between two geographic files.
To filter the dataset based on an 'in/out' condition.
Which TWO of the following are benefits of using parameters in Tableau?
They allow users to change the underlying data source connection type.
They allow for dynamic 'what-if' analysis in visualizations.
Parameters are the primary method for enabling 'what-if' analysis. By creating a parameter that the user can manipulate, you can update calculations that feed into the charts, allowing users to see how changing a target value or a growth rate impacts the overall visualization results in real-time.
They enable the user to switch between different measures in a view.
Parameters are frequently used to swap measures. By creating a parameter containing a list of measure names and a calculated field that selects the measure based on the parameter value, users can toggle between different metrics (like Sales vs. Profit) in the same view without cluttering the display.
They automatically refresh the data from the database.
They can be used to permanently delete data from the server.
In the context of the Tableau 'Order of Operations', which filter is applied first?
Dimension filters.
Measure filters.
Extract filters.
Extract filters are applied at the very beginning of the pipeline. They dictate which data is physically loaded into the extract, making them the most efficient way to reduce data volume and improve dashboard performance by ensuring that unnecessary data never enters the Tableau system in the first place.
Context filters.
Want more Understanding Tableau Concepts practice?
Practice this domainYou are analyzing sales data and need to compare the performance of three product categories over time. Which visualization technique best highlights the individual trends while allowing for immediate comparison of total sales across the categories?
Stacked bar chart
Line chart with color encoding
Line charts are the optimal choice for visualizing data points over time. Assigning a distinct color to each product category allows for easy identification of individual trends and patterns. This method ensures that the slope of each line represents the true growth or decline without being affected by other categories.
Pie chart series
Highlight table
When creating a scatter plot to analyze the relationship between two measures, how can you add a third dimension to the view without creating a new chart?
Add the dimension to the Filters shelf.
Drop the dimension onto the Color mark.
Dropping a dimension onto the Color mark effectively adds a third variable to the scatter plot. Each member of the dimension will be assigned a unique color, allowing the analyst to identify patterns and clusters based on that categorical variable while still observing the relationship between the two axes.
Move the dimension to the Row shelf.
Place the dimension on the Pages shelf.
You are creating a report to track monthly revenue. You notice that some months have missing data points in the database. What is the most effective way to ensure these months appear on the axis with a value of zero?
Use the ZN() function on the measure.
Filter out nulls using a calculated field.
Enable 'Show Missing Values' and use ZN().
Enabling 'Show Missing Values' creates the necessary placeholders for missing dates. Once these placeholders exist, they contain null values. Applying the ZN() function to the measure converts these nulls into zero, resulting in a continuous line chart that correctly reflects zero revenue for months without recorded transactions.
Join the dataset to a calendar table.
Refer to the exhibit. If this logic is applied as a Top N filter on 'Customer' using 'Profit', what will the view display?
The 10 customers with the lowest profit.
The 10 customers with the highest profit.
The combination of a limit of 10 and a descending sort order specifically identifies the top 10 records by the Profit measure. This is the standard behavior for a Top 10 filter in Tableau, which ranks the data points from highest to lowest and keeps only the top 10 results.
All customers, sorted by profit.
The top 10 customers based on count of records.
You are exploring a dataset and want to see how individual data points are distributed within a range of values. Which chart type is best suited for this task?
Bar chart
Pie chart
Box-and-whisker plot
Box-and-whisker plots are specifically designed to show the distribution of data. They highlight the median, the interquartile range (the 'box'), and potential outliers (the individual points beyond the 'whiskers'). This provides a comprehensive overview of the data spread, which is exactly what is needed for exploratory statistical analysis.
Highlight table
You are using a dual-axis chart to compare sales and profit. You notice that the two axes are not synchronized, making the comparison misleading. What is the correct way to fix this?
Right-click the secondary axis and select 'Synchronize Axis'.
This is the standard, built-in function to align the scales of two different measures. It ensures that both measures are displayed using the same range, which is necessary for making a valid comparison. Without synchronization, the viewer might misinterpret the relationship between the two distinct metrics being plotted.
Change the measure to a dimension.
Increase the font size of the axis labels.
Drag the measures to the same Row shelf.
Want more Exploring and Analyzing Data practice?
Practice this domainWhen connecting to a flat file, you notice that Tableau is interpreting a 'Date' column as a String. Which action should you take to ensure the field is recognized correctly for time-series analysis?
Create a calculated field using the DATE() function
Click the data type icon in the Data Source tab and change it to Date
This is the most efficient and direct way to resolve data type issues. By modifying the metadata in the Data Source tab, you inform Tableau how to interpret the underlying values, enabling automatic date recognition and unlocking advanced date functions without needing complex formulas or transformations.
Split the column into Year, Month, and Day segments
Filter the data to remove non-date entries
You are preparing a data source and need to pivot multiple columns representing 'Month' into a single column. What is the primary requirement for this action?
The columns must be adjacent in the data source
The columns must have the same data type
Pivoting requires that the selected columns share a consistent data type because the resulting single column will hold all the values from those original columns. If types differ, Tableau cannot successfully flatten them into a single coherent field without creating inconsistencies that violate database structure integrity rules.
The data must be in a live connection
The columns must contain only numeric values
Refer to the exhibit. You are attempting to join several tables in a physical layer and receive the error shown. What is the most likely cause?
The data files are too large for the extract engine
You have joined tables in a way that creates an infinite loop
Circular dependencies are caused by join logic where Table A connects to B, B to C, and C back to A. This creates a loop that the database engine cannot resolve. You must restructure the joins to be linear or use relationships, which handle multi-table links much better.
The primary keys are missing from all tables
The join condition involves incompatible data types
You have a dataset containing sales information for different years. You want to connect to this data but only need to keep records from the last two years. Which approach is the most efficient?
Use a Data Source filter to exclude older years
A data source filter is applied before the data is fully loaded, meaning Tableau never processes the unnecessary older records. This makes the workbook lighter and faster, as the underlying query is constrained at the source, preventing the system from reading and storing irrelevant historical data.
Use a hide field command on the Year column
Create a worksheet-level filter for every view
Delete the old data from the source file
What is the purpose of the 'Data Interpreter' in the Tableau Data Source tab?
To translate between different database dialects
To identify and clean formatting issues in spreadsheets
Data Interpreter is specifically designed to handle common formatting quirks in flat files, such as multi-row headers, sub-totals, or empty rows. By identifying the true data range, it structures the spreadsheet into a clean, analytical-ready table that Tableau can easily interpret for building visualizations.
To perform statistical analysis on the data
To automatically join tables based on column names
Which TWO of the following are valid ways to combine data from different sources in Tableau?
Blending
Blending is a method to query two different data sources separately and then aggregate the results at the visualization level. It is useful for sources that cannot be joined or related, or when data is at different granularities and you need to perform quick, ad-hoc comparisons without heavy modeling.
Data Mining
Relationships
Relationships are the recommended, modern method for linking tables. They are flexible, context-aware, and avoid the duplication issues associated with traditional joins. They allow for a logical model that automatically adjusts aggregation levels depending on the fields included in the visualization, making them superior to older techniques.
Data Sorting
Extracting
Want more Connecting to and Preparing Data practice?
Practice this domainThe Tableau-Desktop-Found exam has 60–90 questions and must be completed in 120 minutes. The passing score is 700/1000.
Scenario-based questions covering exam objectives with detailed answer explanations.
The exam covers 3 domains: Understanding Tableau Concepts, Exploring and Analyzing Data, Connecting to and Preparing Data. Questions are weighted by domain — higher-weight domains appear more on your actual exam.
No. These are original exam-style practice questions written against the official Tableau (Salesforce) Tableau-Desktop-Found exam objectives. They are not copied from the real exam. Courseiva focuses on genuine understanding, not memorisation of braindumps.
Courseiva tracks your accuracy per domain and routes you toward weak areas automatically. Free, no account required.