Which of the following shapes does a Heat Map use by default?

• A.Square
• B.Line
• C.Text
• D.Circle

Correct Answer: A

By default, the shape that a Heap map uses is a "Square". See below:

Comment: *

Name: *

Email: *

Verification: *

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

• A.True
• B.False

Correct Answer: A

This is true, indeed!
The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side, if there is no match.

Comment: *

Name: *

Email: *

Verification: *

Which two elements can have their values changed by using a dashboard action? Choose two.

• A.Bins
• B.Groups
• C.Sets
• D.Parameters

Comment: *

Name: *

Email: *

Verification: *

Which of the following 2 columns CANNOT be deleted in Tableau?

• A.Measure Names
• B.Number of Records
• C.Measure Values
• D.Calculated Fields

Comment: *

Name: *

Email: *

Verification: *

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

• A.5,129 and 88,872
• B.52,678 and 311,404
• C.1,807 and 34,571
• D.4,888 and 17,817

Correct Answer: D

Explanation
To reach the correct answer, follow these steps:
1) Drag Order Date (Discrete Year) to the Column shelf, and Region to the Row Shelf as shown:

2) Drag Profit to Text in the Marks Shelf as shown:

3) Click on Analysis as shown -> Totals -> SELECT ROW GRAND TOTALS
The following will be the final view:

You could also Filter by Region to only Focus on Canada, but that's your choice:

THEREFORE,
2012 = 4,888
2011 -> 2014 = 17,817

Comment: *

Name: *

Email: *

Verification: *