Tableau-Desktop-Found Connecting to and Preparing Data Practice Test 3 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

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 2

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 3

Which of the following describes the purpose of a 'Data Extract' in Tableau?

Accepted Answer

To improve performance and enable local access.. Data extracts are local, optimized snapshots of data that allow Tableau to store data in a highly compressed and performant .hyper format. By moving data from a source (like a slow database) into an extract, you significantly improve query speed and offload processing from the source system. This is an essential technique for ensuring that end users have a fast, responsive dashboard experience, regardless of the latency of the underlying source.

Answer

To keep data updated in real-time.

Answer

To automatically join different data sources.

Answer

To increase the security of the data connection.

Question 4

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 5

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 6

When you have a large dataset that is slow to load, what is the 'first' step you should take to improve performance in Tableau?

Accepted Answer

Hide unused columns and apply a data source filter.. Minimizing data before it reaches the dashboard is the fundamental rule of Tableau performance. By excluding unnecessary columns and applying data source filters early, you reduce the workload on both the local environment and the underlying database. These initial steps are the most impactful, as they prevent unnecessary data from being processed and stored, leading to a much snappier user experience in the final interactive dashboards.

Answer

Add a dashboard filter.

Answer

Create a hide/unhide dashboard action.

Answer

Increase the number of CPU cores on the machine.

Question 7

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 8

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 9

You are creating a data source that combines a large Sales table with a smaller Regions mapping table. You want to ensure that only rows from the Sales table that have a corresponding match in the Regions table are kept. Which join type should you use?

Accepted Answer

Inner Join. An inner join is the appropriate choice when you only want to return records that have matching values in both tables. This filtering behavior is essential for cleaning data where incomplete or unmatched records could skew performance metrics or create null values that interfere with visualization aggregations, ensuring the dataset remains focused only on valid, mapped geographic regions.

Answer

Left Join

Answer

Right Join

Answer

Full Outer Join

Question 10

When connecting to an Excel file with multiple sheets, you need to combine the data into a single table structure using the Data Source tab. Which feature allows you to stack these sheets vertically if they share the same column headers?

Accepted Answer

Union. The Union feature in Tableau is designed specifically to combine tables with the same structure by appending rows from one table to the bottom of another. This is critical for users who receive periodic extracts—such as monthly sales reports—that need to be analyzed as a single continuous time series without manually merging files in Excel before connecting to Tableau.

Answer

Join

Answer

Relationship

Answer

Data Blending

Question 11

Which file type should you use if you want to save a Tableau data source that includes the connection information and the underlying data in a single compressed file?

Accepted Answer

.tdsx. A Tableau Packaged Data Source (.tdsx) encapsulates the data connection parameters along with the actual data file itself. This is highly beneficial for portability, as it allows users to share a complete, self-contained dataset with colleagues who may not have access to the original underlying database or local file, ensuring the workbook remains fully functional without broken connections.

Answer

.tds

Answer

.twb

Answer

.tde

Question 12

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 13

You are connecting to a large database and only need a small subset of the data based on a specific geographic region. How can you limit the amount of data brought into Tableau?

Accepted Answer

Use a Data Source Filter.. Using a Data Source Filter allows you to restrict the data at the connection level, meaning only the relevant subset is loaded into Tableau's memory. This is a critical performance optimization technique, as it prevents the unnecessary processing of large volumes of irrelevant data, resulting in faster dashboard load times and a more streamlined user experience for regional-specific reporting tasks.

Answer

Use a Context Filter.

Answer

Use a Global Filter.

Answer

Use a Hide field option.

Question 14

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 15

Refer to the exhibit. You are trying to create a calculated field for sales performance. Why is this formula failing?

Accepted Answer

Mixing aggregate and non-aggregate fields is illegal.. In Tableau, you cannot mix aggregate and non-aggregate values in a calculation unless all non-aggregate fields are wrapped in an aggregation function. This ensures that the calculation is performed consistently across the entire dataset. Recognizing this rule is vital for creating accurate ratios and percentages, as calculations that mix grains often result in unexpected errors or logically incorrect outputs that can ruin dashboards.

Answer

The fields must be joined in the physical layer first.

Answer

Calculations cannot reference dimension fields.

Answer

The data source requires a live connection.