Tableau-Desktop-Found Practice Test 2 — 25 Questions

Question 1

You 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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Line chart with color encoding. A line chart with a color-encoded dimension is the standard for time-series analysis. By using color to differentiate categories, you allow the user to track individual trends clearly. This approach is superior to stacked charts when trend analysis is the primary goal, as stacking makes it difficult to distinguish the true slope of the individual data series, potentially leading to misinterpretation of growth patterns.

Answer

Stacked bar chart

Answer

Pie chart series

Answer

Highlight table

Question 2

You have a dataset with a 'Date' field that is recognized as a string. What is the best way to convert it to a Date type so you can use it in a time-series chart?

Accepted Answer

Change the Data Type to 'Date' in the Data Source page.. Converting strings to Date objects is a frequent step in data preparation. Using the 'Change Data Type' option in the interface is the most direct method. If the format is non-standard, using the DATEPARSE function is the robust, programmatic way to ensure Tableau maps the string correctly to its internal date representation. This allows for hierarchical drill-downs (Year, Quarter, Month), which are essential for effective time-series analysis in business intelligence.

Answer

Create a new column using the 'Split' function.

Answer

Use a group to change the date format.

Answer

Use an extract filter to change the data type.

Question 3

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?

Accepted Answer

You have joined tables in a way that creates an infinite loop. A circular dependency occurs when tables are linked in a way that creates an infinite loop or a closed path of joins. In the physical layer, Tableau requires a linear or hierarchical structure. This error is common when users create complex join paths that don't follow a logical, tree-like hierarchy, and resolving it requires simplifying the join structure or using relationships instead of physical joins.

Answer

The data files are too large for the extract engine

Answer

The primary keys are missing from all tables

Answer

The join condition involves incompatible data types

Question 4

You have a large CSV file with millions of rows. You want to keep the data updated every morning. What is the best strategy?

Accepted Answer

Create an extract and schedule an incremental refresh. Scheduled refreshes for extracts are the standard way to maintain data freshness for large files. By creating an extract, you optimize performance. By publishing it to Tableau Server or Cloud, you can leverage automated refresh tasks. This ensures that users always have the latest data without needing to manually refresh the file, balancing performance requirements with the need for timely, up-to-date business intelligence.

Answer

Use a live connection to the CSV

Answer

Manually refresh the extract every morning

Answer

Convert the CSV into a JSON file

Question 5

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

Accepted Answer

They allow for dynamic 'what-if' analysis in visualizations.. Parameters allow users to dynamically change parts of a workbook, such as thresholds, top-N filters, or measures, without modifying the underlying data source. Mastering parameters elevates a dashboard from static to highly interactive. They are essential for creating 'what-if' analyses and allowing end-users to customize their view, which is a core requirement for high-impact analytical tools that support complex decision-making processes.

Answer

They allow users to change the underlying data source connection type.

Answer

They automatically refresh the data from the database.

Answer

They can be used to permanently delete data from the server.

Question 6

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?

Accepted Answer

Use a Data Source filter to exclude older years. Data source filters allow you to limit the data loaded into the Tableau environment at the connection level. By applying a filter before the data is ingested, you reduce the size of the extract or the volume of data queried live. This improves performance, reduces memory usage, and ensures that the workbook only processes the records relevant to the current analytical scope.

Answer

Use a hide field command on the Year column

Answer

Create a worksheet-level filter for every view

Answer

Delete the old data from the source file

Question 7

You have a dashboard displaying regional profit. You want to enable users to interactively filter the view based on profit thresholds and product sub-categories. Which TWO actions should you perform to create this user experience?

Accepted Answer

Drag Profit to the Filters shelf and select 'Range of Values'.. Adding a filter for the profit measure and another for the sub-category dimension provides the necessary interactivity. By configuring these as 'Show Filter' cards, users can dynamically adjust the view. This setup is crucial for exploratory data analysis, allowing stakeholders to drill down into specific segments without requiring the author to create multiple static versions of the same dashboard visualization.

Answer

Drag Sub-Category to the Filters shelf and select 'Wildcard match'.

Answer

Create a parameter to control the background color of the view.

Answer

Add a dashboard action to highlight marks on click.

Question 8

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?

Accepted Answer

Configure a Highlight dashboard action.. Highlighting is the correct feature for focusing attention on a subset of data without removing other records from the view. Unlike filters, which exclude data from the visualization entirely, highlighting keeps all data points visible while dimming those that do not match the selection. This maintains the global context of the dashboard, allowing users to compare selected segments against the total population, which is crucial for detailed exploratory analysis.

Answer

Add a global context filter to the dashboard.

Answer

Use a dashboard action to filter all worksheets.

Answer

Create a parameter to control the visibility of marks.

Question 9

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

Accepted Answer

To create a custom group of data points based on defined criteria.. Sets are a powerful tool for dynamic grouping and segmentation. They allow users to create custom segments based on specific conditions or manual selections and then use these segments as a field in the analysis. Mastering sets allows for deeper 'in vs. out' analysis, which is essential for comparing subsets of data against the whole, providing insights that simple filtering cannot easily achieve.

Answer

To change the connection type of a data source.

Answer

To automatically join two separate data tables.

Answer

To format the axis of a bar chart.

Question 10

You have a scatter plot comparing Sales and Profit. You want to see the trend line for each segment. How should you apply this?

Accepted Answer

Add Segment to the Color mark.. Adding trend lines allows users to observe the direction and strength of the relationship between variables. By adding 'Segment' to the Color mark, you force Tableau to compute a unique trend line for each segment, which is a standard procedure for segment-based performance analysis. This provides deeper insights into whether certain segments follow different patterns, which is critical for targeted marketing and strategic business planning efforts.

Answer

Change the aggregation to Average.

Answer

Create a calculated field for each segment.

Answer

Use a dual-axis chart.

Question 11

You are creating a scatter plot with Sales on Rows and Profit on Columns. You add Category to Color. What happens to the level of detail in the view?

Accepted Answer

The level of detail increases, creating one mark per combination of Category and existing dimensions.. Adding a dimension to the Color mark card increases the level of detail by splitting the data points based on the members of that dimension. Each unique category now gets its own specific mark, allowing for segmented comparison. This is a core mechanism in Tableau for visual grouping and is essential for identifying outliers within specific data clusters.

Answer

The number of marks remains the same, but they change color.

Answer

The view collapses into a single mark because Category is not a measure.

Answer

Tableau throws an error because dimensions cannot be used on the color shelf for scatter plots.

Question 12

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

Accepted Answer

Dimensions describe data, while Measures calculate data. Understanding Dimensions and Measures is the foundation of Tableau's drag-and-drop analysis. Dimensions contain qualitative values like names or dates that define the level of detail, while Measures contain quantitative numbers that can be aggregated. Mastering this distinction allows users to build correct visualizations, as improper assignment leads to incorrect summaries or visualizations that fail to display the intended granularity of the underlying business data.

Answer

Dimensions can be aggregated, whereas Measures cannot

Answer

Measures create headers, while Dimensions create axes

Answer

Measures can only be discrete, while Dimensions are continuous

Question 13

You have connected to a CSV file and notice that the headers are not being correctly identified, resulting in column names like F1, F2, and F3. What is the fastest way to fix this in the Data Source page?

Accepted Answer

Enable the Data Interpreter.. Tableau's Data Interpreter is designed to detect and resolve common data formatting issues, such as missing headers or extra rows above the header. By enabling the Data Interpreter, Tableau attempts to identify the actual header row and promote it to the field name level automatically. This saves significant time compared to manual renaming of dozens of columns and ensures the data types are interpreted correctly based on the content.

Answer

Manually rename each column in the Data Source tab.

Answer

Change the file type to Excel.

Answer

Create a calculated field for each column.

Question 14

You are performing a cohort analysis and need to calculate the average time it takes for customers to make their second purchase. What is the most effective approach to handle this in Tableau?

Accepted Answer

Create a Level of Detail (LOD) expression. Calculating the time between events requires a combination of Level of Detail (LOD) expressions and date functions. By using a Fixed LOD to identify the first purchase date and another for the second purchase date, you can calculate the difference at the customer level. This method is essential for churn analysis and customer lifetime value studies, demonstrating proficiency in advanced data modeling and calculation techniques.

Answer

Use a simple Quick Table Calculation

Answer

Use a standard Row-Level filter

Answer

Change the data source join type

Question 15

An analyst needs to combine two tables from a local PostgreSQL database. The tables share a common identifier, but one table contains transactional rows at a granular date level while the other contains monthly aggregate targets. What joining strategy best prevents metric inflation caused by data duplication?

Accepted Answer

Create a relationship between the two tables using the common identifier field.. Aggregating or properly relating tables at different levels of detail prevents duplication. While standard joins replicate matching rows and inflate additive metrics, Relationships handle mismatched levels dynamically by querying each table at its native grain before aggregation, preserving accurate totals without requiring manual pre-aggregation steps or complex custom SQL scripts in the workspace.

Answer

Perform an inner join on the common identifier to drop any unmatched target values.

Answer

Write a custom SQL query using a full outer join and multiple window functions.

Answer

Blend the data sources by setting up a primary and secondary data connection.

Question 16

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 17

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 18

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 19

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 20

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.