- (Topic 3)
A Data Analyst has the following two tables named Orders and Returns.

The analyst needs to get the Customer ID and Customer Name for only the orders that were returned. Orders will be the leading table.
Which type of join should the analyst perform in Tableau Prep?

1. A. Left join
2. B. Unmatched only join
3. C. Inner join
4. D. Full join

Correct Answer: C

- (Topic 3)
A Data Analyst is given the following table and asked to create a flow that adds a date field to the data. This field should automatically update as new dates (months) are added to the original table.

Which technique should the analyst use as the first step to achieve this in Tableau Prep?

1. A. A wildcard search for multiple tables in the Input step
2. B. An Aggregate step to reshape the data
3. C. A Rows to Columns Pivot step
4. D. A wildcard search to pivot in the Pivot step

Correct Answer: D

- (Topic 3)
You have the following dashboard.

From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?

1. A. From the context menu of Sales over lime, select Filters and then select Enable Auto Update.
2. B. From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.
3. C. From the context menu of Detail table, select Ignore Actions.
4. D. From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

Correct Answer: B

- (Topic 3)
A Data Analyst has created a Tableau Prep flow that is ready to be used. The output will be used by a colleague to build a dashboard on Tableau Cloud or Tableau Server.
Where should the analyst output the data to?

1. A. CRM Analytics
2. B. Salesforce Data Cloud
3. C. A Tableau data extract file
4. D. A published data source

Correct Answer: D

- (Topic 3)
A Data Analyst has the following chart that shows the sum of sales made in different cities.

The analyst wants to show the average sale amount for a city when users hover their mouse over any of the bars.
What should the analyst do?

1. A. Right-click on SUM(Sales) in the Columns and select Include in Tooltip.
2. B. Drag Sales to Tooltip on the Marks card and change Aggregation to Average.
3. C. Drag Sales to Tooltip on the Marks card and modify the Tooltip text.
4. D. Right-click on SUM(Sales) in the Columns and change Aggregation to Average.

Correct Answer: B