Which Sub-Category had the least Profit in the Office Supplies category?

• A.Fasteners
• B.Labels
• C.Envelopes
• D.Binders

Correct Answer: A

Explanation
To reach the correct answer, follow the steps below:

1) Drag Category, and sub-category to the row shelf. Drag Profit to the Column shelf
2) Click the Sort-ascending icon as shown above, to sort the profits from least to greatest as shown:
Click the 'Show mark labels icon'

As we can see, Fasteners has the least Profit in the Office Supplies Category, and hence is our correct answer!

Comment: *

Name: *

Email: *

Verification: *

Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

• A.YES, we can do this with the help of a plugin
• B.NO, this is not currently possible in Tableau
• C.YES, we can do this with the help of a Web-Page object
• D.YES, we can do this with the help of Tableau Public

Correct Answer: C

Explanation
To interactively display information from the web INSIDE a dashboard, you can use a URL action with a web page object.
For example, you might have a dashboard that shows profits by country. In addition to showing the profit data in your dashboard, you also want to display supplemental information about the countries from a web site.

Comment: *

Name: *

Email: *

Verification: *

Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

• A.1 , 4
• B.2 , 2
• C.2 , 3
• D.1 , 2

Comment: *

Name: *

Email: *

Verification: *

True or False: All rows from both tables are returned in an INNER JOIN

• A.True
• B.False

Correct Answer: B

Explanation
The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns.
Consider 2 tables "Orders" and "Customers".
If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!

Comment: *

Name: *

Email: *

Verification: *

Which of the following calculations DO NOT need a quick table calculation?

• A.Variance
• B.Rank
• C.Moving Average
• D.Standard Deviation

Correct Answer: A

Explanation
For Standard Deviation and Variance, we don't need to use quick table calculations, since they are available by default. See below:

However, as seen in the types of quick table calculations available in Tableau, Rank and Moving Average belong to only this category.

Comment: *

Name: *

Email: *

Verification: *