Tableau-Desktop-Found Practice Test 10 — 10 Questions

Question 1

You have connected to a database and need to combine two tables based on a shared ID, but you also need to ensure that no records are lost from the 'Primary' table. Which join type should you use?

Accepted Answer

Left Join.. A left join is the correct choice to preserve all rows from the primary table. It ensures that every record from the left table is included in the resulting set, regardless of whether a matching record exists in the right table. This is critical for data completeness in reporting, especially when you are counting base events and need to see where data might be missing from secondary lookup or reference tables.

Answer

Full Outer Join.

Answer

Inner Join.

Answer

Cross Join.

Question 2

A user needs to understand the core difference between a live connection and an extract in Tableau. Which scenario best dictates the use of an extract?

Accepted Answer

When you need to perform complex calculations on a large dataset without impacting database performance.. Extracts are snapshots of data that improve performance for large datasets by moving the processing load from the source database to the local Tableau engine. Choosing between live and extract connections is a foundational skill for optimizing dashboard responsiveness. Understanding this distinction ensures that users balance the need for real-time data accuracy with the necessity of maintaining a performant, stable user experience during high-concurrency reporting scenarios.

Answer

When the underlying data source requires real-time updates every second.

Answer

When the data source is a small, static CSV file with no performance issues.

Answer

When you want to ensure that security permissions are applied directly at the database level for every view.

Question 3

When creating a dual-axis chart to compare two different measures with significantly different scales, what must you do to ensure the visualization accurately reflects the data?

Accepted Answer

Synchronize the axes. Synchronizing axes is essential when comparing two measures on a dual-axis chart. Without synchronization, the visual representation can be misleading, as the scale for one measure might be significantly different from the other, making it appear that two data points are related when they are not. Ensuring they share a common scale allows for honest, accurate interpretation of trends across both measures.

Answer

Change both marks to bars

Answer

Remove the secondary axis

Answer

Add a trend line to the chart

Question 4

You have a scatter plot showing 'Sales' vs 'Profit'. You want to see the trend line for each 'Region'. What is the most straightforward way to achieve this?

Accepted Answer

Drag Region to the Color shelf. Adding a dimension to the Color shelf automatically partitions the view, which applies the trend line logic to each color-coded segment. This is the most efficient way to compare trends across multiple categories simultaneously. Understanding how marks cards and shelves interact to segment data is a core skill for Tableau users performing comparative analysis on multidimensional datasets.

Answer

Create individual trend line files

Answer

Apply a filter to the Trend Line

Answer

Use a Table Calculation for trends

Question 5

Which TWO of the following statements correctly describe the behavior of the 'Data Interpreter' in Tableau?

Accepted Answer

It can identify and remove extra headers from Excel files.. Data Interpreter is a powerful tool for cleaning messy spreadsheets before analysis. It identifies sub-tables, removes headers, and cleans up formatting issues automatically. Understanding when to use it saves significant time during data preparation. This knowledge is essential for Tableau practitioners, as it prevents errors stemming from poorly structured raw data and ensures that downstream calculations are performed on clean, properly formatted, and reliable data sets.

Answer

It automatically joins multiple data sources into a single logical model.

Answer

It permanently alters the original source file on the user's hard drive.

Answer

It is only available for data sources connected via a live connection.

Question 6

What is the purpose of the 'Relationships' feature in Tableau's logical layer?

Accepted Answer

To create a flexible, multi-table logical model.. Relationships are dynamic, flexible connections that allow Tableau to join data sources intelligently based on the fields used in a visualization. By preserving the original tables, they prevent data loss (fan-out) and enable context-aware aggregations. Understanding this is essential for modern Tableau users, as it simplifies data modeling compared to the traditional, more rigid physical join methods that often caused data duplication.

Answer

To physically merge two tables into one.

Answer

To force a strict inner join on all fields.

Answer

To replace the need for data extracts.

Question 7

Which feature allows you to quickly view the underlying data of a specific mark in your visualization without leaving the current sheet?

Accepted Answer

The 'View Data' option in the Tooltip or Right-click context menu.. The 'View Data' window is a critical tool for data validation and exploration. It allows users to see the specific records that constitute a single mark or a selection of marks. This feature is essential for debugging calculated fields and verifying that the data being visualized matches the expectations of the business logic, providing immediate feedback during the dashboard building process.

Answer

The Data Interpreter tool in the Data Source tab.

Answer

The Annotations menu in the Worksheet toolbar.

Answer

The 'Describe' button in the Data pane sidebar.

Question 8

A user is attempting to calculate the percentage of total sales per region. Why is a Table Calculation chosen over a standard calculated field?

Accepted Answer

They perform calculations on the aggregate visual data. Table calculations operate on the aggregate data in the current visualization, making them ideal for calculations that rely on the view's layout. This is essential for comparative analysis, such as running totals or percentages of totals. Understanding that these calculations depend on the hierarchy and sorting of the viz prevents common errors where users expect static results that don't change with filtering.

Answer

They are computed before the data is filtered

Answer

They allow for writing back data to the database

Answer

They are faster than standard calculations

Question 9

Refer to the exhibit. Why is the 'Revenue' field failing to aggregate as a sum?

Accepted Answer

The field contains non-numeric characters like symbols.. Tableau requires numerical data types to perform mathematical aggregations like 'Sum' or 'Average'. When a field contains currency formatting characters (like the dollar sign or commas), Tableau often imports it as a string. Because strings cannot be mathematically summed, the aggregate function is disabled. Converting the field to a numeric type, or cleaning the string to remove symbols, is the standard requirement for correcting this common data import error.

Answer

The currency formatting is set to a locale that isn't supported.

Answer

The data source requires a live connection for aggregation.

Answer

Tableau automatically treats all revenue fields as dimensions.

Question 10

You are creating a report to track monthly revenue. You notice that some months have missing data points in the database. What is the most effective way to ensure these months appear on the axis with a value of zero?

Accepted Answer

Enable 'Show Missing Values' and use ZN().. Handling missing data is a common challenge in time-series analysis. By enabling 'Show Missing Values' on the date pill, Tableau generates the missing temporal headers. However, simply showing the headers does not create data points. Using the ZN() function on the measure ensures that these newly generated time buckets are treated as zero rather than null, preventing gaps in line charts and ensuring accurate cumulative calculations like running totals.

Answer

Use the ZN() function on the measure.

Answer

Filter out nulls using a calculated field.

Answer

Join the dataset to a calendar table.