Tableau-Desktop-Found Understanding Tableau Concepts — All Questions With Answers

Question 1hardmulti select

Read the full Understanding Tableau Concepts explanation →

Which TWO of the following statements regarding Tableau Data Extracts (.hyper files) are accurate?

Question 2mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Refer to the exhibit. What is the most likely cause of the error message when attempting to blend these two data sources?

Exhibit

LOG_ENTRY: [ERROR] 2023-10-12 14:02:11 - Data source 'Sales_Data' failed to blend. Reason: Cannot aggregate 'City' from primary source with 'Sales' from secondary source due to mismatched level of detail.

Question 3easymultiple choice

Read the full Understanding Tableau Concepts explanation →

Which Tableau interface component allows you to change a field's data type, such as converting a string to a date?

Question 4mediummulti select

Read the full Understanding Tableau Concepts explanation →

Which THREE of the following are considered 'Discrete' fields in Tableau?

Question 5hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

Refer to the exhibit. Given this JSON policy for a published workbook, what is the impact on user experience regarding dashboard performance?

Exhibit

JSON_POLICY: { 'access_level': 'restricted', 'data_source': 'Live', 'caching': 'no-store', 'execution_context': 'Server' }

Question 6mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

An analyst creates a view containing country, region, and sales. They drag region onto the Filters shelf, selecting only 'North' and 'South'. Next, they add country to the context. What is the execution order of these operations in Tableau?

Question 7easymultiple choice

Read the full Understanding Tableau Concepts explanation →

Which component of the Tableau architecture is primarily responsible for the storage and retrieval of data from the underlying data sources during a live connection?

Question 8mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

When creating an extract from a large SQL database, you notice the file size is significantly smaller than the source table. Which feature is likely responsible for this behavior?

Question 9hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

Refer to the exhibit. A user receives this error when opening a dashboard connected to a multi-terabyte cloud data warehouse. What is the fundamental Tableau concept involved here?

Exhibit

Error: The requested query could not be completed because the connection to the data source timed out. Check the data source status or consider creating an extract.

Question 10mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Which of the following describes the behavior of a 'Context Filter' in Tableau?

Question 11easymultiple choice

Read the full Understanding Tableau Concepts explanation →

Which of the following is true regarding the 'Live' vs 'Extract' connection types?

Question 12mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Which Tableau feature allows you to combine multiple data sources from disparate systems without writing custom SQL code?

Question 13hardmulti select

Read the full Understanding Tableau Concepts explanation →

An analyst is building a complex executive dashboard and needs to ensure that user filters interact correctly with global filters, context filters, and mark selections. Which THREE of the following statements accurately describe the order of operations in Tableau? (Choose three.)

Question 14mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

When working with a Discrete date part vs. a Continuous date value, what determines how the date is displayed in a visualization?

Question 15mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A sales manager connects to a table containing a continuous numeric field named 'Profit Ratio'. After dragging it onto the Color shelf, Tableau prompts to choose whether the field should be treated as a dimension or a measure. The manager wants to color-code regions by the actual ratio value, not by individual discrete values. Which field role should the manager assign?

Question 16mediummulti select

Read the full Understanding Tableau Concepts explanation →

A financial analyst is building a view that shows the cumulative year-to-date (YTD) sales for each product category. The analyst wants the calculation to be computed at the correct level of detail and to work when the view is filtered by region. Which two statements accurately describe how Tableau handles table calculations and filters in this scenario? (Choose two.)

Question 17hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

A data analyst is working with a data source that contains a field 'Order Date' (Date type) and 'Sales' (Measure). The analyst wants to create a view that shows the cumulative running total of sales over time, with the running total resetting at the beginning of each year. Which approach should the analyst use?

Question 18mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A financial analyst has a view showing 'Profit' by 'Sub-Category' as a bar chart. The analyst wants to highlight only the sub-categories that have a profit greater than $10,000 by coloring those bars in green and all others in gray. Which feature should the analyst use to achieve this?

Question 19hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

A financial analyst is building a view with 'Region' on Rows and monthly revenue on Columns. The analyst applies a table calculation on revenue that computes a running total. After adding a filter that excludes one region, the running totals for the remaining regions change unexpectedly. The analyst wants the running total computed only across the regions that remain after filtering. Which Tableau behavior explains this and what should the analyst do?

Question 20mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A financial analyst has a view showing 'Segment' on Rows and 'Profit Ratio' on Columns as a bar chart. She wants to add a reference line that shows the overall average profit ratio across all segments, and she wants that line to remain at the same position even if she later filters the view to show only a subset of segments. Which reference line scope should she choose?

Question 21mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A hospital analyst builds a view that shows Readmission Rate by Department. The workbook connects to a live SQL Server data source, and the analyst wants readers of the published dashboard to see the most current readmission figures each time they open it, without the analyst manually refreshing anything. Which connection strategy satisfies this requirement?

Question 22hardmulti select

Read the full Understanding Tableau Concepts explanation →

A data analyst is exploring a dataset and wants to understand the distribution of sales across different product categories. The analyst decides to create a histogram of sales. Which two statements are true regarding histograms in Tableau? (Choose two.)

Question 23hardmulti select

Read the full Understanding Tableau Concepts explanation →

A data analyst is preparing a Tableau extract for a dashboard that will be published to Tableau Cloud. The source is a large relational table with many columns, and the analyst wants to reduce extract size and improve performance while preserving the ability to add new fields later. Which two actions should the analyst take when configuring the extract? (Choose two.)

Question 24hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

A healthcare analyst builds a view with 'Department' on Rows and 'Average Length of Stay' on Columns. She wants to display a small horizontal bar inside each row that shows the department's value relative to the maximum value in the view, without adding a second axis or changing the mark type. Which Marks card property should she configure?

Question 25hardmulti select

Read the full Understanding Tableau Concepts explanation →

A retail analyst builds a view with 'Region' on Rows and 'Sales' on Columns as a bar chart, then adds 'Category' to the Color shelf. She wants to add a table calculation that ranks regions by sales within each category, and she wants the ranking to update correctly when the view is filtered to a subset of regions. Which two actions should she take? (Choose two.)

Question 26mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

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?

Question 27easymultiple choice

Read the full Understanding Tableau Concepts explanation →

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?

Question 28easymultiple choice

Read the full Understanding Tableau Concepts explanation →

What is the primary function of a 'Set' in Tableau?

Question 29mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Why would you use a 'Group' instead of a 'Set' when preparing data in Tableau?

Question 30mediummulti select

Read the full Understanding Tableau Concepts explanation →

Which TWO of the following are benefits of using parameters in Tableau?

Question 31hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

In the context of the Tableau 'Order of Operations', which filter is applied first?

Question 32easymultiple choice

Read the full Understanding Tableau Concepts explanation →

What is the primary difference between a Dimension and a Measure in Tableau?

Question 33mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Which of the following scenarios best justifies the use of a data relationship (Noodles) over a physical join?

Question 34mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A user is attempting to calculate the percentage of total sales per region. Why is a Table Calculation chosen over a standard calculated field?

Question 35mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

When is it appropriate to use a 'Discrete' date field rather than a 'Continuous' date field in a visualization?

Question 36hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

Refer to the exhibit. What is the primary purpose of this configuration policy in the Tableau environment?

Exhibit

JSON Policy: { "row_level_security": "enabled", "filter_mapping": { "user_region": "[Region]" }, "enforcement": "strict" }

Question 37mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Which Tableau feature should be used to display a metric from a secondary data source that is not joined to the primary source?

Question 38easymultiple choice

Read the full Understanding Tableau Concepts explanation →

What is the purpose of the 'VizQL' engine in Tableau?

Question 39mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Why would an analyst choose to use 'Hide Unused Fields' in an extract?

Question 40mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Which of the following describes the behavior of a 'Discrete' color legend versus a 'Continuous' color legend?

Question 41mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

You are building a dashboard and need to ensure that when a user selects a value in one chart, it highlights related data in other charts without filtering out the entire dataset. Which feature should you configure?

Question 42easymultiple choice

Read the full Understanding Tableau Concepts explanation →

Which Tableau component acts as a container for multiple worksheets and provides the layout structure for a final presentation?

Question 43mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Refer to the exhibit. You receive this error when creating a calculation. What is the fundamental Tableau concept that prevents this formula from executing?

Exhibit

Error: Aggregate and non-aggregate arguments cannot be mixed in IF expression.

Question 44mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

An analyst wants to combine two tables from the same Microsoft SQL Server database using a relationship instead of a physical join in the Tableau data source canvas. What is the primary operational characteristic of relationships compared to traditional joins?

Question 45easymultiple choice

Read the full Understanding Tableau Concepts explanation →

When designing a high-performance dashboard in Tableau Desktop, an analyst creates a calculated field that aggregates correctly at the view level. What distinguishes a measure from a dimension in the Tableau data pane?

Question 46mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

An analyst creates a calculated field using a FIXED level of detail expression to calculate regional sales totals. When a standard dimension filter is applied to the worksheet, the fixed calculation does not change. Why does this occur in Tableau?

Question 47easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A user wants to understand the difference between dimensions and measures in Tableau. Which statement accurately describes a dimension?

Question 48hardmulti select

Read the full Understanding Tableau Concepts explanation →

Which TWO of the following statements correctly describe the behavior of the 'Data Interpreter' in Tableau?

Question 49mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

Which of the following actions is the most efficient way to change the default aggregation of a measure?

Question 50mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A retail analyst drags the discrete numeric field 'Order Year' onto the Columns shelf and 'Category' onto the Rows shelf, then places a continuous 'Profit' measure on Text. The resulting view displays a compact text table with year columns and category rows. They now want each year to be read as an independent header across the top rather than a single continuous axis. Which Tableau concept explains why the view already renders as discrete headers, and what would change if the field were made continuous?

Question 51easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A marketing analyst connects Tableau Desktop to a cloud-based CRM and wants every new opportunity record added by the sales team to appear in the workbook when the view is refreshed, without manually rebuilding the data source. Which connection type should the analyst use?

Question 52mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A sales operations analyst has a view showing SUM(Sales) by Region. They want to see each region's sales as a percentage of total sales across all regions, displayed as a bar chart where the bars sum to 100 percent. Which Tableau feature should they use?

Question 53hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

A financial analyst builds a view showing Profit Ratio by Sub-Category. To highlight only sub-categories whose Profit Ratio is below zero, the analyst creates a calculated field returning a boolean based on Profit Ratio < 0 and places it on the Color shelf. Which Tableau concept does this calculated field represent when used on Color?

Question 54mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A logistics analyst wants to show shipment counts by destination city on a map, but several cities share the same name across different states. The data includes City, State, and Country fields but no latitude or longitude. Which approach best ensures Tableau plots each city correctly?

Question 55hardmulti select

Read the full Understanding Tableau Concepts explanation →

A retail analyst is building a dashboard that must show the same sales measure at two different levels of aggregation: total sales per store and total sales per product category, on a single worksheet without blending or joining additional tables. Which two Tableau features allow the measure to be computed at a level of detail independent of the view's dimensions? (Choose two.)

Question 56mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A business analyst has a data source containing a field called 'Shipping Cost' that is currently classified as a measure with a default aggregation of SUM. The analyst wants to display the average shipping cost per order on a view without changing the underlying data source. Which action should the analyst take?

Question 57easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A sales manager is building a view and wants to show the total sales for each region as a bar chart. The 'Region' field is a dimension and 'Sales' is a measure. After dragging 'Region' to Columns and 'Sales' to Rows, the bar chart appears. The manager then drags 'Category' to Color on the Marks card. What is the effect of adding 'Category' to Color?

Question 58easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A sales operations analyst is building a view showing total profit by product category. After dragging 'Category' to the Rows shelf and 'Profit' to the Columns shelf, the analyst notices the mark type has defaulted to a bar chart and that the Profit axis is continuous. The analyst wants to compare discrete categories against a numeric value. Which statement best describes how Tableau is treating these two fields in this view?

Question 59easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A marketing analyst connects Tableau Desktop to a Microsoft Excel workbook containing a single sheet of campaign records. She wants to build several visualizations without repeatedly re-importing the file, and she needs the workbook's data to remain available inside the Tableau workbook even when the original .xlsx file is moved to an archive folder. Which connection type should she use?

Question 60hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

A data analyst is building a view that shows the average shipping cost per order across different ship modes. The data source contains one row per order line item, and orders can have multiple line items. The analyst notices that the average shipping cost is skewed because orders with many line items are overrepresented. Which Tableau feature should the analyst use to calculate the average shipping cost per order correctly?

Question 61mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A logistics analyst wants to highlight orders whose shipping cost exceeds a fixed threshold of 500. The analyst creates a calculated field returning a Boolean result and drags it onto the Color shelf, but the resulting legend shows only 'True' and 'False' labels with generic colors. The analyst needs a two-color scheme where qualifying orders are red and all others are gray. Which approach best accomplishes this in Tableau Desktop?

Question 62easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A marketing analyst wants to display the percentage of total sales contributed by each marketing channel in a pie chart. The data source contains sales amounts per channel. Which Tableau feature should the analyst use to quickly show the percent of total without writing a calculation?

Question 63mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A retail analyst is creating a view that shows sales by product category and sub-category. The analyst wants to allow users to drill down from category to sub-category without changing the view structure. Which Tableau feature should the analyst use?

Question 64easymultiple choice

Read the full Understanding Tableau Concepts explanation →

A retail analyst studies a data source containing a postal code field that is stored with a numeric data type. When the analyst drags Postal Code onto the Rows shelf, Tableau produces a continuous horizontal axis with values such as 0, 20,000, 40,000, and 60,000 instead of discrete postal code labels. Which concept explains why the postal codes are rendered as an axis rather than as individual headers?

Question 65mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A marketing analyst has two data sources: a primary source with campaign spend and a secondary source with website conversions. The sources share a 'Campaign ID' field but are not joined. The analyst wants to display total conversions alongside spend in a single view without blending, because blending has produced null values. Which Tableau feature should the analyst use to bring the conversion metric into the primary source's view?

Question 66mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A supply chain analyst creates a scatter plot with 'Shipping Cost' on Columns and 'Order Total' on Rows, then drags 'Ship Mode' onto the Color shelf. She wants each ship mode to be represented by a distinct shape as well as a distinct color, and she wants the shapes to be consistent every time the workbook is opened. What should she do?

Question 67hardmultiple choice

Read the full Understanding Tableau Concepts explanation →

A logistics analyst combines shipment records from two tables in a single data source. The Shipments table contains one row per shipment, and the Packages table contains one row per package, with many packages belonging to a single shipment. The analyst relates the two tables on Shipment ID and then builds a view of Total Freight Cost by Carrier. The freight cost column lives only in the Shipments table. Which statement describes what happens to the freight cost values in the resulting view?

Question 68mediummultiple choice

Read the full Understanding Tableau Concepts explanation →

A marketing analyst builds a scatter plot of Ad Spend against Revenue by Region and wants to highlight the relationship between the two measures on the same view. The analyst drops a continuous Profit measure onto the Color shelf. Which statement describes how Tableau renders the marks?

LOG_ENTRY: [ERROR] 2023-10-12 14:02:11 - Data source 'Sales_Data' failed to blend. Reason: Cannot aggregate 'City' from primary source with 'Sales' from secondary source due to mismatched level of detail.