Connect to the "Global Superstore" data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?

• A.2012
• B.2013
• C.2014
• D.2015

Correct Answer: A

Drop Order Date to columns, Category to Rows, and Sales to Text.
Go to Analysis -> Totals -> Show Columns Grand Total
Graphical user interface, text, application Description automatically generated

Update Total All Using to Average:
Graphical user interface, text, application Description automatically generated

Table Description automatically generated

In the year 2012, the furniture sales were more than the average sales of that year.

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Global Superstore" data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?

• A.Belkin Router, USB
• B.Cisco Smart Phone, Full Size
• C.Nokia Smart Phone, with Caller ID
• D.Bush Classic Bookcase, Pine

Correct Answer: D

Explanation
Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.

Drop the Product Name to the Rows and Profit to the Text.
Drop the Market to the filter and select the Europe.
Your view will look like this:

Here, you are getting only 9 products.
Add Market filter to the context so that the Product Name dimension filter will be executed after the Market filter.

View:

Comment: *

Name: *

Email: *

Verification: *

How the ATTR() is defined in Tableau?

• A.IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE "*" END
• B.IF MIN ([dimension]) = MAX ([dimension]) THEN MAX ([dimension]) ELSE "*" END
• C.IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE MAX ([dimension]) END
• D.IF MIN ([dimension]) = MAX ([dimension]) THEN MIN ([dimension]) ELSE NULL END

Comment: *

Name: *

Email: *

Verification: *

Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values. What is the skewness of this chart?

• A..42
• B..51
• C..48
• D..55

Correct Answer: A

Enable the Summary Card from Show/Hide menu as shown:
Skewness is .42
Graphical user interface, chart Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

You have connected to an excel sheet that has two tables "orders" and "returns". You need to create a data extract and store it as Multiple Tables. But multiple tables option is greyed out. What is the possible reason for this?

• A.It will only be enabled once you perform the union
• B.It will only be enabled once you perform the join
• C.It will only be enabled once you perform the data blending
• D.It will only be enabled once you save the visualization to Tableau Server

Correct Answer: B

Explanation
Select the Extract connection and click on Edit as shown:

If you have single table on the canvas, then Multiple tables option remain disabled:

If you create a join, only then Multiple tables option will be enabled:

Comment: *

Name: *

Email: *

Verification: *