Tableau-Desktop-Found Practice Test 2 — 30 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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.