Tableau Desktop Foundations (Desktop Specialist) Practice Test 2 – 2026 Leave a Comment / By LearningTableau / October 22, 2026 This free practice test has 37 questions written for the current Salesforce Certified Tableau Desktop Foundations exam (formerly Tableau Desktop Specialist). The real exam has 40 scored questions, a 70-minute time limit and a 48% passing score, covering Connecting & Preparing Data, Exploring & Analyzing Data, Sharing Insights and Tableau Concepts. You'll see the correct answers and explanations at the end. Enter Email to Subscribe A retail analyst connects to a cloud data warehouse and needs dashboards to always reflect the most current transactions, even though queries will be slower. Which connection type should the analyst use? Live connection Extract with full refresh Extract with incremental refresh Cross-database join None A sales manager creates an extract of a large order table but only needs records from the last two years. Where should the analyst apply this restriction so the extract file itself contains only those rows? On the Filters shelf of a worksheet after the extract is created In the Extract Data dialog, using the Add filter option on the source table By creating a data source filter after publishing to Tableau Server By setting the geographic role of the order date field None An analyst has renamed fields, set default number formats, and created folders in the Data pane. The analyst wants to reuse this metadata with the same underlying database without duplicating the data. Which file should be saved? A packaged workbook (.twbx) A Tableau data source file (.tds) A Tableau bookmark (.tbm) A Tableau extract (.hyper) None An analyst needs to combine an Excel budget sheet with a Snowflake transactions table in a single Tableau data source. Which two statements are true about this cross-database join? (Choose two.) The join is performed by Tableau after querying each source separately. Tableau requires both sources to use identical database platforms. Cross-database joins can reduce performance compared with a join within one database. Cross-database joins are only supported for extracts, never live connections. The join must be defined as a relationship, not a physical join. An analyst drags Orders and Returns tables onto the Canvas. Each table appears as a separate logical table with a noodle connecting them, and no join type is specified. What has the analyst created? An inner join in the physical layer A relationship in the logical layer A union of the two tables A blended data source None An analyst joins a Customers table (left) to an Orders table (right) using Customer ID and selects a left join. Which rows are retained in the result? Only customers who have at least one order All customers, with null order values for customers without orders Only orders that match a customer All customers and all orders, matched where possible None Monthly sales files are named Sales_2022_01.csv through Sales_2022_12.csv and sit in one folder. The analyst wants a single table that automatically includes new monthly files placed in that folder. Which approach is most appropriate? Create a wildcard union using the folder path and a search pattern such as Sales_*.csv Create a relationship between each monthly file and a calendar table Create an inner join between the first and last monthly files Create an extract filter on the file name None An analyst is deciding between a physical join and a relationship for combining Orders and Products. Which two situations favor using a relationship? (Choose two.) The tables have different levels of detail and the analyst wants Tableau to choose the join at query time based on the viz. The analyst needs to define a single flattened table with a fixed row-level structure before building visualizations. The analyst wants Tableau to preserve each table's level of detail when aggregating measures, reducing the risk of inflated totals from duplicated rows. The analyst needs to explicitly enforce a full outer join between the tables rather than let Tableau choose the join type for each visualization. The analyst wants to append rows from two tables with the same structure. An analyst has a field named Region containing state names such as 'Washington' and 'Texas', but Tableau treats it as a string dimension. The analyst wants to place it on a map. Which action should the analyst take in the Data pane? Convert the field to a measure Assign the Geographic Role of State to the field Add the field to the Filters shelf Change the field's default aggregation to Sum None A retail analyst wants Sales and Profit to appear as bars sharing a single continuous axis in the same view, so both measures are plotted on one y-axis. Which approach accomplishes this in Tableau Desktop? Place Sales on Rows, place Profit on Rows, then select Dual Axis from the Profit pill's context menu Place Sales on Rows, then drag Profit directly onto the existing vertical axis in the view until a double-bar icon appears Place Sales and Profit on Columns, right-click the axis, and select Synchronize Axis Place Sales on Rows, and add Profit to the Detail property on the Marks card None A dashboard author overlays a line for Profit Ratio on top of bars for Sales using a dual axis, but the line and bars do not align visually. Which action should the author take? Right-click the secondary axis and select Synchronize Axis Change the Profit Ratio mark type to Bar Move Profit Ratio from Rows to the Detail shelf Convert the dual axis into a combined axis by dragging Profit Ratio onto the Sales pill None A logistics manager wants to visualize where order concentration is highest across many ZIP codes on a map without plotting a mark for every single record. Which chart type should be used? Symbol map (filled map) Density map Highlight table Scatterplot None A sales director wants a grid of Category by Region where each cell is colored by Sales so high and low performers stand out at a glance. Which view should be built? Place Category on Rows, Region on Columns, Sales on Color with Square marks Place Category on Rows, Region on Columns, Sales on Size with Circle marks Place Category on Rows, Region on Columns, Sales on Text only Place Category on Rows, Region on Columns, Sales on the Filters shelf None You want to create a scatter plot to analyze the relationship between Discount and Profit for each order. You place Discount on Columns and Profit on Rows, which initially displays a single mark. What should you do to display a distinct mark for each order? Add Order ID to Detail on the Marks card. Add Order ID to the Rows shelf. Add Order ID to the Filters shelf. Add Order ID to the Pages shelf. None A product manager wants total Sales by Region as bars, with each bar segmented by Category to show the contribution of each category. Which view achieves this? Region on Columns, Sales on Rows, Category on Color Region on Columns, Sales on Rows, Category on Detail Region on Columns, Sales on Rows, Category on Rows Region on Columns, Category on Rows, Sales on Text None A store manager wants to combine several individual states into a single 'West Coast' member for analysis, without creating a new calculated field. Which feature should be used? Create a set of the states Create a group by selecting the states in the view and choosing Group Create a hierarchy with the states as a level Create a bin on the State field None A sales analyst creates a set on Customer Name for the top 50 customers by Sales. Which two statements are true about how this set behaves? (Choose two.) The set creates an In/Out membership that can be used on shelves such as Filters, Rows, or Color The set pill in the view can be toggled between showing In/Out of Set and showing members in the set The set permanently removes non-member customers from the data source A Top N set is static and will not recalculate when underlying sales data changes Placing the set on Color automatically converts it into a permanent Tableau group A business user wants to drill from Country to State to City within a single field in the view. Which Tableau feature should be created? A group containing the three fields A hierarchy with Country as the top level, State in the middle, and City at the bottom A set on City A calculated field concatenating the three fields None Which statement correctly describes the sequence in which Tableau evaluates filters in its Order of Operations? Context filters are evaluated before dimension filters, which are evaluated before measure filters Measure filters are evaluated before dimension filters, which are evaluated before context filters Dimension filters are evaluated before context filters, which are evaluated before measure filters Table calculation filters are evaluated before measure filters, which are evaluated before dimension filters None A manager wants a filter that always shows only the last 30 days of data relative to today, without manually changing dates each time the workbook opens. Which filter should be used? A range of dates filter with fixed start and end dates A relative date filter set to Last 30 days A measure filter on the date field A context filter on the date field None A view shows Products sorted by Sales descending, but when the analyst adds a Region filter the order of products changes. Which sort type is being used? A manual sort A computed sort A nested sort on the dimension only A sort applied by the data source None A view displays Order Date (Month) on Columns and Region on Rows showing SUM(Sales). You want each region's monthly sales to be displayed as a cumulative total across the months. Which quick table calculation and Compute Using setting should you apply to SUM(Sales)? Running Total computed using Table (across) Running Total computed using Table (down) Percent of Total computed using Table (across) Difference computed using Table (across) None The data contains exactly one row per order, with a unique, non-null Order ID and a numeric Order Value measure. A quality analyst wants to see how many orders fall into each $50 range of order value. Which approach builds the correct histogram? Create a bin on Order Value with size 50, place the bin on Columns and CNT(Order ID) on Rows Create a group on Order Value with size 50, place it on Columns Create a set on Order Value and show IN/OUT on Columns Create a calculated field rounding Order Value to 50 and place it on Color None A sales analyst has a bar chart of revenue by Region and wants each region bar to display a distinct color. Where on the Marks card should the analyst place the Region field? On the Color shelf On the Size shelf On the Detail shelf On the Tooltip shelf None A marketing manager wants a scatter plot where each product category appears as a different symbol (circle, square, triangle) based on Category. Which Marks card setting should be changed? Change the mark type to Shape and place Category on the Shape shelf Change the mark type to Circle and place Category on the Color shelf Change the mark type to Text and place Category on the Label shelf Change the mark type to Square and place Category on the Detail shelf None A dashboard team is presenting how sales shift between quarters on a bar chart. They want the bars to visibly grow or shrink as the Quarter filter changes, and they want to control the animation speed. Which two statements about viz animations in Tableau Desktop 2022.3 are true? (Choose two.) Viz animations can be turned on or off by choosing Format > Animations The animation duration can be adjusted in the Animations pane Viz animations only work on maps and cannot be applied to bar charts Viz animations automatically export as motion when saving to PowerPoint Animations must be enabled per worksheet by adding a field to the Detail shelf A dashboard author wants reviewers to be able to hover over a bar and see the underlying customer name and order date without changing the view. Which interactive element should the author configure? Tooltip on the Marks card Highlighter on the dashboard Show Filter control Filter action None A dashboard has a bar chart of Sales by Region and a detail chart of Orders. The author wants selecting a region bar to filter the detail chart to only that region, while leaving the region bar chart unchanged. Which two settings are required when creating the filter action? (Choose two.) Set the source sheet to the region bar chart and the target sheet to the detail chart Set the target sheet to the region bar chart so it filters itself Choose the action type Filter and set the run behavior to on selection Set the action type Highlight so the detail chart filters Add the Region field to the Detail shelf of the detail chart A retail analyst wants clicking a store mark on a dashboard to open that store's page on an internal website, passing the Store ID as a parameter in the URL. Which dashboard action should the analyst create? URL action Filter action Highlight action Go to Sheet action None A dashboard author needs a phone layout where certain charts stack vertically and some desktop-only charts are hidden. What should the author use in Tableau Desktop 2022.3? Device Preview with a Phone layout, where sheets can be shown or hidden per device A floating layout on the desktop dashboard only A story point that contains the phone charts A filter action set to run on the phone device None A manager wants a presentation that walks viewers through three sequential views: an overview, a regional breakdown, and a trend. Each step should keep a consistent layout while changing the charts to support a guided narrative. Which Tableau feature should be used? A story with three story points A dashboard with three filter actions A worksheet configured with the Pages shelf A dashboard configured with three layout containers None An analyst must send a workbook to a colleague who may not have access to the original Excel file used in the connection. The analyst also wants to share a static snapshot with stakeholders who have no Tableau access. Which two approaches are appropriate? (Choose two.) Save and share the workbook as a packaged workbook (.twbx) so the data is included Export the view to PDF for the stakeholders without Tableau Save and share only the workbook (.twb) with no data included Publish the workbook to Tableau Public as a private draft for the stakeholders Email the original Excel file and ask stakeholders to install Tableau Desktop A business analyst connects to a sales data source in Tableau Desktop and opens the Data pane. The field 'Customer Name' is listed above the horizontal divider, while 'Profit' appears below it. Which statement correctly describes these fields? 'Customer Name' is a dimension and 'Profit' is a measure; dimensions are typically qualitative and measures quantitative. 'Customer Name' is a measure and 'Profit' is a dimension; the divider indicates numeric versus text fields only. Both fields are measures because Tableau places all fields that can be aggregated below the divider. 'Customer Name' is a dimension only if it is dragged to Rows; otherwise it is treated as a measure. None A store manager places the discrete dimension 'Region' on Columns and the continuous measure 'SUM(Sales)' on Rows. How do these fields display in the worksheet view? Region pill is green and SUM(Sales) pill is blue. Region appears as column headers and SUM(Sales) renders on a continuous axis. Region renders on a continuous axis and SUM(Sales) appears as a header. Both Region and SUM(Sales) render as headers because one field is on Columns. None An operations analyst wants each month shown as a separate labeled column header across the view, without a continuous timeline axis. Which date field configuration on Columns achieves this? MONTH(Order Date) as a continuous (green) date value YEAR(Order Date) as a continuous (green) date value MONTH(Order Date) as a discrete (blue) date part Order Date as an exact continuous date with full precision None A consultant drags the measure 'Sales' from the Data pane onto the Rows shelf without changing any aggregation setting. Which default aggregation does Tableau Desktop apply? COUNT AVG SUM MIN None A regional sales director wants to compare total revenue by product line. The analyst places the dimension 'Product Line' on Columns and the measure 'Revenue' on Rows. Which two statements are correct about how these fields interact? (Choose two.) Product Line partitions the data into slices, and Revenue is aggregated within each slice. Revenue must be placed on the Filters shelf before Product Line can slice it. Product Line is treated as a measure because it appears alongside a numeric field. Removing Product Line would collapse the view to a single aggregate of Revenue across all product lines. The Revenue pill becomes discrete automatically when Product Line is added to Columns. Time's upTime is Up!
