Question 1

You have the following chart that sorts states by the number of products each state has purchased.Which formula should you use to include a number with the position of each state within each region?

Options :

A : FIRST ()

B : INDEX ()

C : WINDOW_SUM(SUM ([Quantity]))

D : LOOKUP (SUM ([Quantity]))

Answer: B

Question 2

You have been assigned a task to recreate a chart that compares the profit of each region to the overall average profit across all regions. What steps would you follow in Tableau to accomplish this?

Options :

A : Add a Reference Line by right-clicking on the profit axis, select Add Reference Line, and choose Average for the entire table.

B : Add a Reference Line by right-clicking on the region axis, select Add Reference Line, and choose Average for the entire table.

C : Right-click the profit axis, select Add Reference Line, and set the scope to Per Region and value toTotal Average.

D : Drag Profit onto the Columns shelf, then right-click on the chart and select Add Trend Line to display the overall average profit.

Answer: A

Question 3

What is the method for organizing related fields in the Data Pane to improve the structure and accessibility of your data in Tableau?

Options :

A : Using Groups

B : Creating Folders

C : Sorting Fields Alphabetically

D : Applying Filters

Answer: B

Question 4

Add an exponential trendline to the chart and find out how many regions are above the trend line?

Options :

A : 3

B : 4

C : 5

D : 6

Answer: B

Question 5

I need to show the correlation between profit and sales, broken down by Customer ID and Category. How can I create a following chart that visualizes this relationship?

Options :

A : Drop Sales to Rows, Profit to Columns, Customer ID to Color, Category to Detail

B : Drop Sales to Columns, Profit to Rows, Customer ID to Detail, Category to Color

C : Drop Sales to Rows, Profit to Columns, Customer ID to Size, Category to Color

D : Drop Sales to Columns, Profit to Rows, Customer ID to Color, Category to Legend

Answer: B

Free Analytics-DA-201 Mock Exam – Practice Online Confidently

Buying Options: