FREE Tableau Connecting & Preparing Data Questions and Answers

Question 1

A business analyst is working with a sales dataset in a wide format, where each column represents a different month (e.g., 'Jan Sales', 'Feb Sales', 'Mar Sales').
To effectively analyze sales trends over time, the data needs to be restructured so that all monthly sales figures are in a single column and the month names are in another.
Which Tableau feature should the analyst use on the Data Source page to achieve this transformation?

Accepted Answer

Pivot

Answer

Split

Answer

Data Interpreter

Answer

Join

Question 2

You are connecting to an Excel file that was formatted for human readability. It includes a title in the first row, a blank row for spacing, and then the actual data table with headers. When you connect to this file in Tableau, the fields are not correctly identified. Which feature should you use first to automatically clean up this type of extraneous formatting?

Accepted Answer

Data Interpreter

Answer

Create Calculated Field

Answer

Union

Answer

Manage Metadata

Question 3

An analyst needs to combine sales data from a corporate SQL database with sales targets stored in a separate Google Sheet. Which method is most appropriate for combining these two disparate data sources within Tableau for analysis on a single worksheet?

Accepted Answer

Data Blending

Answer

Join

Answer

Union

Answer

Relationship

Question 4

A Tableau user needs to build a dashboard for a high-traffic sales floor where monitoring real-time data is critical. The underlying database is powerful and updated every few seconds. Which type of data connection should be used to ensure the dashboard reflects the most current information without manual intervention?

Accepted Answer

Live Connection

Answer

Extract with a scheduled refresh every minute

Answer

Published Data Source

Answer

Saved Data Source (.tds)

Question 5

After connecting to a data source, you notice a field named 'Cust_ID' which represents the customer identification number. To improve clarity for other users of the data source, you want to change its name to 'Customer ID' within Tableau. This action is an example of:

Accepted Answer

Managing Metadata

Answer

Creating a Calculated Field

Answer

Splitting a Column

Answer

Creating a Hierarchy

Question 6

Which of the following scenarios is the primary reason to use a Tableau Extract over a Live Connection?

Accepted Answer

When you need to reduce the query load on a production database and improve dashboard performance

Answer

When the underlying data changes constantly and requires real-time analysis

Answer

When the dataset is very small and the source database is extremely fast

Answer

When you need to combine tables from two different databases