Tableau-Desktop-Found Practice Test 5 — 10 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.