Tableau-Desktop-Found Practice Exam 3 — 20 Questions

Question 1

You are working with a CSV file and want to ensure that Tableau treats certain columns as numbers, even though they look like categories. What should you do?

Accepted Answer

Manually change the data type to 'Number' in the Data Source page.. Tableau's data type detection is usually accurate, but occasionally it misinterprets data, especially if a column contains mostly categories with a few numeric values. Manually overriding the data type in the Data Source page is the standard procedure to force the correct behavior. Ensuring the correct data type is foundational for enabling appropriate aggregations and sorting, which prevents subtle errors in charts and calculations later in the development cycle.

Answer

Use a filter to remove categories.

Answer

Create a group from the column.

Answer

Change the file connection to a live connection.

Question 2

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

Accepted Answer

To reduce extract file size. This feature reduces the size of the extract by stripping out unnecessary columns that aren't used in the workbook. This is a critical performance tip for developers. By reducing the physical size of the extract, you lower the memory pressure on the server and speed up query processing times, resulting in a snappier dashboard experience for end-users.

Answer

To encrypt sensitive data

Answer

To speed up extract creation

Answer

To prevent unauthorized column access

Question 3

What is the primary difference between a Dimension and a Measure in Tableau when dragging them into a view?

Accepted Answer

Dimensions define labels and groupings, while Measures are aggregated.. Dimensions add granularity and slice the data into headers, whereas Measures are quantitative values that are aggregated by default (like SUM or AVG). Understanding this distinction is fundamental because it dictates how data is organized, grouped, and displayed on your visualizations. Misidentifying a field's role can lead to incorrect data summaries or charts that fail to represent the business question accurately.

Answer

Measures cannot be used on the Filters shelf.

Answer

Dimensions are always numbers, and Measures are always strings.

Answer

Only Dimensions can be used to color marks.

Question 4

Refer to the exhibit. You are receiving a calculation error when trying to aggregate a 'Revenue' field. What is the most efficient way to resolve this in the Data Source tab?

Accepted Answer

Change the data type of the field using the icon in the data grid.. Tableau requires numerical data to perform aggregate calculations like Sum or Average. If a field is imported as a string, it must be cast to a number. Understanding data type conversion is crucial because incorrect types prevent the use of fundamental features like filters and color-coding, which rely on the underlying mathematical properties of the data to generate accurate visual representations.

Answer

Create a new parameter to force numeric conversion.

Answer

Use a hide and unhide operation to refresh the schema.

Answer

Export the data to CSV and re-import it.

Question 5

Refer to the exhibit. Why are the sales records being duplicated in the output?

Accepted Answer

The join condition involves a many-to-many relationship.. The exhibit illustrates a common issue when joining tables at different granularities. A left join on 'Sales' and 'Targets' where multiple rows in 'Targets' exist for a single row in 'Sales' will cause the 'Sales' data to replicate for every match found in 'Targets'. Understanding this behavior is vital for maintaining data accuracy, as it demonstrates why relationships are often preferred over physical joins to avoid fan-traps and data duplication.

Answer

The join condition uses an incorrect join type.

Answer

The connection is set to Live instead of Extract.

Answer

The data contains null values in the join key.

Question 6

You need to connect to a CSV file that is updated daily. To maintain the most up-to-date data while keeping the file lightweight, which connection strategy should you use?

Accepted Answer

Use an Extract with a scheduled refresh.. Using an Extract with a refresh schedule ensures that the data is periodically updated without requiring the user to manually trigger the import. This balance between performance and freshness is key in professional environments where users expect real-time or near-real-time data without the performance penalty of a live connection, which can be unstable with local CSV files.

Answer

Always use a Live connection.

Answer

Use a Data Source Filter on every field.

Answer

Import the CSV as a new data source every day.

Question 7

Refer to the exhibit. If this logic is applied as a Top N filter on 'Customer' using 'Profit', what will the view display?

Accepted Answer

The 10 customers with the highest profit.. The filter logic indicates an inclusion of the top 10 customers based on the Profit measure in descending order. This means the view will specifically isolate the 10 most profitable customers. In Tableau, this effectively ranks the records based on the sum of Profit and retains only the top 10, allowing the analyst to focus purely on the highest performers and exclude the rest of the dataset from the current worksheet view.

Answer

The 10 customers with the lowest profit.

Answer

All customers, sorted by profit.

Answer

The top 10 customers based on count of records.

Question 8

Which THREE actions can be performed to improve the performance of a slow-loading visualization during the analysis phase?

Accepted Answer

Apply Extract Filters to reduce the data volume.. Optimizing visualization performance is critical for effective data storytelling. Large data volumes and complex calculations can drag down interactivity. By using extract filters, minimizing marks, and simplifying complex calculations, analysts can ensure their dashboards remain responsive. These techniques are standard best practices for ensuring that the end-user experience remains smooth, especially when dealing with large datasets typical in enterprise business intelligence environments, preventing frustration and increasing adoption rates.

Answer

Use as many quick filters as possible.

Answer

Increase the number of dashboard sheets.

Question 9

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

Accepted Answer

One field is aggregated and the other is not, causing a level-of-detail mismatch.. Tableau requires consistent dimensionality in calculations. You cannot mix aggregated values, like SUM(Sales), with non-aggregated values, like Profit, in the same expression because they operate at different levels of granularity. Understanding this concept is critical because it forces users to align their data grain. To fix this, one must either aggregate the non-aggregated field using functions like ATTR() or MIN(), or disaggregate the aggregated field if appropriate for the analysis.

Answer

The calculation is using an invalid syntax for the IF statement.

Answer

The data source has not been refreshed with the latest metadata.

Answer

The calculation uses a field that is not in the current view.

Question 10

Refer to the exhibit. You are trying to create a calculated field: 'Sales / SUM(Profit)'. Why does this trigger the error shown?

Accepted Answer

You must aggregate 'Sales' using a function like SUM() or AVG() to match 'SUM(Profit)'.. The error occurs because Tableau enforces strict rules on aggregation. You cannot perform arithmetic between raw row-level data and an aggregated measure. To resolve this, you must aggregate the first field as well. This concept is vital for ensuring mathematical integrity in complex calculations, preventing illogical results that could mislead stakeholders during data analysis.

Answer

The field 'Sales' is a dimension and cannot be used in a calculation.

Answer

The calculation syntax is invalid because forward slashes are not permitted.

Answer

The 'Profit' field must be converted to a dimension before it can be used.

Question 11

You are connecting Tableau Desktop to a large transactional database containing millions of rows. You need to improve workbook performance and reduce query load on the live database during exploratory analysis. What is the most effective connection and data storage strategy to achieve this?

Accepted Answer

Convert the connection to an extract and store the resulting hyper file locally. Creating a Tableau extract compresses the data, stores it locally, and utilizes columnar storage technology, which significantly enhances query performance for large datasets. This approach reduces network latency and frees up transactional database resources. While live connections ensure real-time accuracy, extracts are the industry standard for optimizing desktop performance during complex exploratory analysis sessions involving millions of rows.

Answer

Switch the connection type to Live and apply custom SQL with heavy aggregation

Answer

Maintain a live connection and enable serial execution mode for all queries

Answer

Use an incremental refresh schedule on a live connection without creating an extract

Question 12

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?

Accepted Answer

Create a relationship between the two sources in the Data Source page and add the conversion measure to the view.. Relationships provide a logical, non-materialized link between tables or data sources, allowing measures from a secondary source to be aggregated correctly in a view without physically merging rows. Defining the relationship on 'Campaign ID' and adding the conversion measure avoids the nulls that blending can produce when IDs do not align, and it keeps the analysis in a single worksheet.

Answer

Use a cross-database join to physically combine the tables into one extract.

Answer

Create a parameter that maps campaign IDs to conversion values and use it in a calculated field.

Answer

Add a secondary data source and use a data blend, setting 'Campaign ID' as the linking field.

Question 13

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?

Accepted Answer

Freight cost values are preserved because the relationship aggregates shipment-level measures at the shipment level of detail, independent of the package rows.. Relationships keep related tables logically separate and let Tableau determine the level of detail required by the view. Shipment-level measures such as freight cost are aggregated at the shipment grain, so adding package rows does not multiply them. Physical joins, by contrast, can repeat rows and inflate totals.

Answer

Freight cost is summed across all packages in the shipment, producing a value equal to the shipment cost multiplied by the package count.

Answer

The relationship fails to resolve because the two tables are at different levels of detail, so freight cost returns null for every carrier.

Answer

Freight cost is duplicated for each matching package row, so the totals are inflated unless the analyst switches to a many-to-many relationship.

Question 14

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?

Accepted Answer

The postal code field is numeric, so Tableau treats it as continuous by default, and changing the field to a discrete dimension or converting it to a string will produce individual headers.. Numeric fields default to the continuous role in Tableau, which is why an identifier such as a postal code renders as a numbered axis. Because postal codes are names, not quantities, the analyst should convert the data type to string or explicitly set the field to discrete, at which point each code becomes its own header on the shelf.

Answer

Tableau automatically treats any numeric field as a measure, so the postal code must be converted to a dimension before it can display as discrete values.

Answer

The data source uses an extract, and extracts always materialize numeric fields as continuous axes until the extract is refreshed against the live connection.

Answer

The postal code field is being aggregated, which forces any numeric field onto a continuous axis regardless of its data type or role assignment.

Question 15

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?

Accepted Answer

A live connection to the CRM. A live connection queries the source system whenever the view is rendered, so records added after the workbook was authored appear without rebuilding the data source. Extract-based approaches, joins to static files, and publishing settings change performance, storage, or governance but do not deliver automatic visibility of newly created records in the same way.

Answer

A cross-database join to a local spreadsheet

Answer

An extract refreshed on a schedule

Answer

A published data source with a stored password

Question 16

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?

Accepted Answer

Create a hierarchy with Category and Sub-Category, then enable drill-down.. Hierarchies are the built-in Tableau feature for drill-down. By placing Category and Sub-Category in a hierarchy, users can expand and collapse levels directly in the view. This provides an interactive way to explore data without changing the view structure or requiring additional parameters.

Answer

Use a table calculation to compute sales at different levels.

Answer

Use a parameter to switch between Category and Sub-Category.

Answer

Use a set to group categories and sub-categories, then filter.

Question 17

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?

Accepted Answer

Drag 'Ship Mode' onto the Shape shelf and assign a specific shape to each member.. The Shape shelf is the Marks card property that assigns a glyph to each member of a dimension. Dragging Ship Mode to Shape and picking a shape per member gives distinct, persistent shapes for every ship mode. Color editing, changing the mark type to Pie, or placing a field on Detail does not control the glyph used for each mark, so those approaches fail the stated goal.

Answer

Create a calculated field that returns a shape name for each ship mode and place it on Detail.

Answer

Change the mark type to Pie and place 'Ship Mode' on the Angle shelf.

Answer

Right-click 'Ship Mode' on the Color shelf and select 'Edit Colors' to assign a shape palette.

Question 18

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?

Accepted Answer

The bars are split into stacked segments representing each category's sales, and the total bar height remains the sum of all categories for that region.. When a dimension is placed on the Color shelf, Tableau uses it to differentiate marks by color. On a bar chart, this results in stacked bars, where each bar represents the total for the primary dimension and is segmented by the color dimension. The total height remains the sum of all segments, but the breakdown by category is visible through color.

Answer

The bars are grouped side-by-side by category within each region, with each category having its own bar.

Answer

The bars are replaced with a scatter plot showing individual category sales points for each region.

Answer

The bars remain unchanged, but a color legend appears that allows filtering by category.

Question 19

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?

Accepted Answer

Drag 'Shipping Cost' to a shelf, then use the drop-down menu on the pill and select Measure > Average.. The correct approach is to change the aggregation of the measure on the view itself. Right-clicking the pill on a shelf and selecting Measure > Average sets the aggregation for that specific worksheet without modifying the data source's default properties. This preserves the original SUM default for other analyses while allowing the analyst to see average shipping cost per order.

Answer

Change the default aggregation of the 'Shipping Cost' field to Average by right-clicking the field in the Data pane and selecting Default Properties > Aggregation > Average.

Answer

Create a calculated field using the formula AVG([Shipping Cost]) and replace the original field on the shelf with this calculation.

Answer

Right-click the 'Shipping Cost' field in the Data pane and select 'Convert to Dimension', then place it on a shelf and set the aggregation to Average.

Question 20

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?

Accepted Answer

Use the 'Quick Table Calculation' option on the Sales measure and select 'Percent of Total'.. The Quick Table Calculation 'Percent of Total' is designed to compute the percentage contribution of each mark to the total. It requires no manual formula and can be applied directly to the Sales measure. This is the most efficient method for the analyst's goal.

Answer

Use the 'Analytics' pane to add a reference line showing the average sales.

Answer

Use a set to group channels and then display the set's percentage.

Answer

Use a calculated field with SUM([Sales]) / TOTAL(SUM([Sales])).