Question 1

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

Question 2

What is the default join type when you blend two data sources?

Options :

A : Inner join

B : Outer join

C : Left outer join

D : Right join

Answer: C

Question 3

You have the following dashboard that contains two sheets.You want to minimize the whitespace between the sheets. What should you configure?

Options :

A : The background

B : The position

C : The padding

D : The size

E : The border

Answer: C

Question 4

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 5

Connect to the "Education" data source. Analyze the Math score and create 3 categories. If the score is less than 500 then consider the student as 'Low Performer'. If the score is greater than or equal to 500 but less than 600 then call it 'Average Performer'. If the score is greater than or equal to 600 then 'High Performer'. Find out the percentage of Average Performers in males?

Options :

A : 32.38%

B : 42.84%

C : 32.25%

D : 44.33%

Answer: D

Confidently Practice Online with Free Analytics-DA-201 Exam Cram

Buying Options: