By default, measures placed in a view are aggregated. The type of aggregation applied ______________

• A.is always sum
• B.depends on the context of the view
• C.is always COUNT
• D.is always AVERAGE

Comment: *

Name: *

Email: *

Verification: *

Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

• A.3.000
• B.3.840
• C.3.704
• D.3.500

Correct Answer: C

Explanation
Since we need to focus on 1 country -> Japan, let's filter on it first as follows:
1) Drag Country to the filter shelf, and choose only Japan. Click OK.

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:
Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.
Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.
The following is our visualisation:

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME.
Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

Comment: *

Name: *

Email: *

Verification: *

Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

• A.25.79%
• B.23.39%
• C.27.73%
• D.29.49%

Correct Answer: C

Explanation
We need to use the concept of Groups for this question. Follow along:
1) First, Drag State to the Rows shelf, and Total Expenses to the Text Mark on the Marks Shelf:

2) Now, remove the SUM aggregation from Total Expenses, and add a quick table calculation -> Percent of total:

3) Next, Select the States of New York, California and Washington -> And then click the paperclip icon:

We can see the answer already : 23.386% in the view above (even before grouping!)
4) Finally, we get the following view and our answer:

Comment: *

Name: *

Email: *

Verification: *

True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

• A.rue
• B.False

Correct Answer: B

It is possible in Tableau to use a sheet within a story directly.
Moreover, in Tableau, a story is a sequence of visualizations that work together to convey information. You can create stories to tell a data narrative, provide context, demonstrate how decisions relate to outcomes, or to simply make a compelling case.
At the same time, a story is also a collection of sheets, arranged in a sequence. Each individual sheet in a story is called a story point.

Comment: *

Name: *

Email: *

Verification: *

True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *