Tableau-Desktop-Found Exploring and Analyzing Data Practice Test 2 — 15 Questions

Question 1

Refer to the exhibit. You are trying to compute a 'Percent of Total' table calculation on an existing aggregate field. Why does this error occur?

Accepted Answer

The field is already an aggregation, and the table calculation needs raw data.. Tableau's calculation engine requires a specific level of granularity to perform table calculations. If a field is already aggregated (like a custom ratio), the table calculation cannot further aggregate it without a defined scope. You must ensure that the calculation is applied to the underlying measures (e.g., SUM(Sales)) rather than a pre-aggregated field, or use the 'Compute Using' settings properly to define the scope.

Answer

The data source connection is live instead of an extract.

Answer

The field is a non-numeric string type.

Answer

The dashboard is using an outdated version of Tableau.

Question 2

When adding a reference line to a visualization, which THREE options can you use to define the line's value? (Select three)

Accepted Answer

A Constant value.. Reference lines provide visual benchmarks, which are essential for comparing current performance against targets or historical averages. By allowing users to see their data in context, reference lines make it easier to identify deviations or performance gaps. They are a foundational tool for creating effective, self-explanatory dashboards that communicate complex business goals quickly and intuitively to a broad audience of stakeholders.

Answer

A custom user-input image file.

Answer

A URL link to an external website.

Question 3

You are creating a map and want to show the distribution of Sales by State. Which geographic role should you assign to the 'State' field to ensure Tableau recognizes it as a map-able entity?

Accepted Answer

State/Province. Geographic roles tell Tableau how to interpret the strings in your data so it can link them to its internal latitude and longitude database. Without this assignment, Tableau will treat the state names as plain text. Correctly assigning these roles is a fundamental step in geospatial analysis, enabling the creation of powerful, intuitive maps that highlight regional performance and spatial trends in business data.

Answer

Country/Region

Answer

City

Answer

Zip Code

Question 4

You have a dashboard with a map and a bar chart. You want the map to filter the bar chart when a user clicks on a region. How is this achieved?

Accepted Answer

Go to Dashboard > Actions > Add Action > Filter.. Dashboard filter actions are a core feature for building interactive, user-driven analysis. They allow analysts to bridge the gap between different chart types, enabling a 'drill-around' experience. By setting a map as a source filter, you enable an intuitive, exploratory interface where users can quickly navigate through spatial data and see the corresponding, detailed performance metrics in an associated chart, increasing the dashboard's overall usability.

Answer

Drag the map sheet onto the bar chart sheet.

Answer

Use the 'Highlight' action instead of a Filter action.

Answer

Create a parameter and use it in a filter calculation.

Question 5

You have a dataset containing 'Order Date' and 'Ship Date'. You want to calculate the 'Lead Time'. What is the correct way to handle dates in this calculation?

Accepted Answer

DATEDIFF('day', [Order Date], [Ship Date]). Date math is a fundamental skill in Tableau. Using the correct functions ensures that you handle time periods accurately, including edge cases like cross-year orders. Understanding these functions allows you to build sophisticated performance metrics, such as lead time, which are critical for supply chain or sales analysis. Proper date handling prevents errors and provides accurate, reliable insights into business processes that rely on temporal efficiency.

Answer

[Ship Date] - [Order Date]

Answer

DATE_SUB([Ship Date], [Order Date])

Answer

DATEDIFF('month', [Order Date], [Ship Date])

Question 6

You are analyzing sales data and need to identify the exact threshold where profit margins shift from negative to positive across multiple regions. Which Tableau feature best allows for dynamic interaction to pinpoint this specific tipping point?

Accepted Answer

Using a Parameter. Parameters allow users to define a specific value and integrate it into calculated fields, enabling dynamic 'what-if' analysis. By creating a parameter for the profit threshold, a user can slide the value to observe precisely when regional performance transitions. This approach is essential for business stakeholders who need to explore boundaries and sensitivities within large datasets without modifying the underlying data source or creating static visualizations.

Answer

Using a Set

Answer

Using a Highlight Action

Answer

Using a Reference Band

Question 7

You have a scatter plot showing Sales vs. Profit. You want to group specific outliers to analyze their details separately. Which TWO methods allow you to create a group for these outliers? (Choose TWO)

Accepted Answer

Selecting the marks and clicking the Paperclip icon. Grouping in Tableau allows analysts to categorize marks into higher-level buckets, which is vital for isolating outliers. By selecting marks directly on the canvas or through the data pane, users can create groups that persist across the workbook. This is critical for data cleaning and focused analysis, enabling the comparison of identified anomalies against the rest of the dataset without creating complex calculated fields.

Answer

Using a Set action with a parameter

Answer

Creating a calculated field using an IF statement

Answer

Changing the mark type to Shape

Question 8

Refer to the exhibit. The Profit_Ratio is calculated correctly, but the bar chart shows the same value for all states. What is the most likely cause?

Accepted Answer

State is not present in the view. In Tableau, calculations involving aggregates must be properly partitioned. If the dimension (State) is not included in the view or the calculation is implicitly forced to a higher level of granularity, the ratio will repeat. This scenario is common when users struggle with the order of operations or the way Tableau handles aggregate-level calculations versus row-level computations, requiring adjustments to the visualization level of detail.

Answer

The calculation is using non-aggregated fields

Answer

The data source is improperly joined

Answer

The mark type is set to Automatic

Question 9

You are creating a dashboard and want to compare performance across different product categories while simultaneously seeing how the total sales change over time. Which action provides the best user experience for this?

Accepted Answer

Use a Dashboard Filter Action. Dashboard filters and actions provide interactivity that allows users to drill down or pivot between views. By setting up dashboard actions to filter one view based on selections in another, you enable exploratory analysis. This allows stakeholders to observe how specific category performance influences the global trend, making the dashboard dynamic, actionable, and focused on revealing relationships between different segments of the business data.

Answer

Create separate worksheets and put them on a dashboard without actions

Answer

Duplicate the data source for each worksheet

Answer

Apply the filter to all worksheets using the 'All Using This Data Source' option

Question 10

You are analyzing a dataset with significant null values in the 'Sales' field. Which THREE of the following actions can you take to handle these nulls during data exploration? (Choose THREE)

Accepted Answer

Use the ZN() function in a calculated field. Handling null values is a critical step in data preparation and analysis. Depending on the business context, you may want to exclude them, convert them to zero, or highlight them for investigation. Knowing these techniques ensures that reports remain accurate, as ignoring nulls or incorrectly interpreting them can lead to misleading conclusions and skewed metrics regarding total performance and regional sales contributions.

Answer

Use the Data Interpreter to automatically fill nulls

Answer

Convert the dimension to a measure

Question 11

Refer to the exhibit. What is the primary reason to hide a field in the data pane rather than deleting it?

Accepted Answer

It keeps the field available for use in existing calculations. Hiding fields is a best practice for maintaining a clean data workspace without losing the ability to reference the data later if needed. It reduces clutter in the data pane, making it easier for users to find relevant fields. Deleting is a permanent action, whereas hiding allows for potential recovery, maintaining workbook stability and data integrity for future analytical needs.

Answer

It improves the performance of the data extract

Answer

It forces Tableau to ignore the field during data refreshing

Answer

It is the only way to rename a field without breaking dependencies

Question 12

Which option in the 'Sort' dialog box allows you to sort based on the underlying measure values of a field, rather than its alphabetical name?

Accepted Answer

Field. Sorting by measure values is essential for quickly identifying top or bottom performers. Tableau's sort dialog provides clear options to switch between manual, alphabetical, and field-based sorting. Understanding how to sort by measure, especially in descending or ascending order, is a fundamental skill for data analysis as it transforms raw lists into actionable insights by highlighting the most relevant data points immediately.

Answer

Alphabetical

Answer

Manual

Answer

Nested

Question 13

When creating a dual-axis chart, which THREE steps are necessary to ensure the axes are correctly synchronized and readable? (Choose THREE)

Accepted Answer

Right-click the secondary axis and select 'Synchronize Axis'. Dual-axis charts allow for the visualization of two different measures on the same canvas, but they can be misleading if not configured correctly. Synchronizing axes ensures that the scales align properly, preventing visual misinterpretation of the relationship between the two metrics. These configuration steps are vital for maintaining the integrity of data visualizations when comparing different types of quantitative data.

Answer

Create a parameter to adjust the axis scale

Answer

Change the mark type to Pie for both measures

Question 14

You have a view with Region on Rows and Sales on Columns. You want to see the total sales for each region as well as the individual profit performance for each product. What should you do?

Accepted Answer

Drag Profit to the Detail shelf. Adding a secondary measure or a dimension to the Marks card allows for multi-faceted analysis within a single visualization. This is critical for Tableau users because it enables 'nested' analysis, where you can compare high-level regional performance alongside granular product-level details. This prevents the need for creating separate dashboards for every level of granularity, thereby streamlining the user experience and improving cross-functional data insight within one view.

Answer

Create a dashboard action

Answer

Filter out the Sales measure

Answer

Convert the view to a Map

Question 15

Which TWO of the following statements accurately describe how Tableau treats continuous vs discrete fields?

Accepted Answer

Continuous fields produce a continuous axis.. Understanding the duality of continuous and discrete fields is essential for mastering Tableau's data representation. Continuous fields create axes, while discrete fields create headers. Mastering these differences allows the analyst to control the granularity and presentation of their visualizations, ensuring the data is communicated accurately to the end-user. This knowledge prevents common pitfalls in time-series analysis and categorical segmentation within the Tableau development workflow.

Answer

Discrete fields create a continuous axis in the view.

Answer

Continuous fields always group data into distinct segments.

Answer

You cannot change a field from continuous to discrete.