Tableau-Desktop-Found Practice Exam 2 — 20 Questions

Question 1

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?

Accepted Answer

Box-and-whisker plot. A box-and-whisker plot is the industry standard for visualizing data distribution. It provides an immediate view of the median, quartiles, and outliers, allowing analysts to quickly understand the spread and skewness of the data. This is far more informative than a simple bar chart, which only displays the aggregate value and hides the underlying variation that is often critical for understanding data quality and reliability.

Answer

Bar chart

Answer

Pie chart

Answer

Highlight table

Question 2

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?

Accepted Answer

Standard dimension filters execute after fixed level of detail expressions in the Tableau order of operations.. Fixed level of detail expressions compute values at the specified dimensions without regard for the view's layout or standard dimension filters because fixed expressions sit higher in Tableau's order of operations than dimension filters. This architectural design allows analysts to calculate cohort metrics and overall benchmarks that remain immune to standard user filtering within the worksheet view.

Answer

Fixed LOD expressions are permanently hardcoded into the data source schema during the initial connection phase.

Answer

Fixed LOD calculations automatically convert all measures into discrete dimensions upon initial compilation.

Answer

The analyst forgot to add the region field to the Marks card as a detail attribute before applying the filter.

Question 3

What is the primary difference between a Data Extract and a Live connection in Tableau?

Accepted Answer

Extracts provide a local, optimized snapshot of the data.. A Live connection queries the source database directly each time a view is updated, ensuring data is always current but potentially slow. An Extract is a local copy of data that provides faster performance and offloads processing from the source database. Choosing between them is a fundamental decision that balances the need for real-time data against the requirement for system responsiveness.

Answer

Extracts are always faster but cannot be scheduled for refresh.

Answer

Live connections automatically aggregate data at the source.

Answer

Live connections are only available for cloud-based sources.

Question 4

What is the result of using a discrete color palette on a continuous measure?

Accepted Answer

The color is rendered as a series of distinct color steps.. A discrete color palette applied to a continuous measure creates distinct color ranges, often known as stepped colors. This allows users to categorize performance levels (e.g., Low, Medium, High) rather than using a smooth gradient. This technique is essential for making data more readable and enabling quick visual interpretation of performance thresholds, which helps stakeholders grasp complex quantitative data with minimal cognitive load during rapid review.

Answer

The measure is automatically converted into a dimension.

Answer

The visualization fails to render because measures must use continuous gradients.

Answer

The color is automatically assigned to every unique value in the dataset.

Question 5

You have a large dataset and need to improve dashboard performance while exploring trends. Which TWO actions should you take to ensure Tableau remains responsive during your analysis?

Accepted Answer

Apply a Data Source Filter. Managing data volume is critical for maintaining a fluid analytical experience. By using Data Source Filters, you reduce the initial load of irrelevant data before it hits the engine. Similarly, context filters optimize query performance by creating temporary tables that limit the scope for subsequent dependent filters. Both techniques are essential for scaling Tableau dashboards without sacrificing user interactivity or performance speed.

Answer

Convert all dimensions to measures

Answer

Increase the number of dashboard worksheets

Answer

Use live connections for all data sources

Question 6

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?

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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.