Tableau Data Connections and Preparation Questions and Answers

Question 1

A business analyst is working with an Excel spreadsheet that contains multiple sub-tables, titles, and footers.
When connecting this file to Tableau, the data appears disorganized.
Which Tableau feature should the analyst use to automatically identify and clean the dataset?

Accepted Answer

Data Interpreter

Answer

Data Blending

Answer

Pivot

Answer

Relationships

Question 2

You are combining two tables in Tableau. The first table contains sales transaction data at a daily level, and the second contains monthly sales targets. To avoid duplicating the monthly target for every daily transaction, which data combination method is most appropriate and flexible?

Accepted Answer

Relationships

Answer

Inner Join

Answer

Full Outer Join

Answer

Union

Question 3

A data source has survey results where each question is a separate column (e.g., 'Q1_Satisfaction', 'Q2_Recommendation', 'Q3_Timeliness'). To analyze this data effectively, you need to transform these columns into two fields: one for the 'Question' and one for the 'Response'. Which data preparation action should you perform?

Accepted Answer

Pivot

Answer

Split

Answer

Merge

Answer

Union

Question 4

When working with data in the Data Source page, which of the following is NOT considered a metadata management task in Tableau?

Accepted Answer

Filtering out a specific category of data

Answer

Changing a field's data type from Number to String

Answer

Creating a new calculated field

Answer

Renaming a data field

Question 5

An analyst needs to combine data from a published Tableau Server data source with a local Excel file. A join is not possible. Which method should be used to bring data from both sources into a single worksheet?

Accepted Answer

Data Blending

Answer

Union

Answer

Relationship

Answer

Cross-database join

Question 6

Which of the following best describes the primary difference between a live connection and a Tableau data extract?

Accepted Answer

Extracts create a static subset of data, which can improve performance and enable offline work.

Answer

Live connections are always faster than extracts because they don't require data ingestion.

Answer

Live connections store the data within the Tableau workbook file (.twb).

Answer

Extracts can only be created from file-based data sources like Excel and CSV.

A business analyst is working with an Excel spreadsheet that contains multiple sub-tables, titles, and footers.When connecting this file to Tableau, the data appears disorganized.Which Tableau feature should the analyst use to automatically identify and clean the dataset?

A business analyst is working with an Excel spreadsheet that contains multiple sub-tables, titles, and footers.
When connecting this file to Tableau, the data appears disorganized.
Which Tableau feature should the analyst use to automatically identify and clean the dataset?