How can you change the default Tableau repository location?

• A.By clicking on Window -> Repository Location
• B.By clicking on Help -> Change Repository Location
• C.By clicking on File -> Repository Location and choosing a new location
• D.By Moving the repository location manually to wherever we want

Correct Answer: C

According to the official Tableau documentation:
Graphical user interface, text, application Description automatically generated

Comment: *

Name: *

Email: *

Verification: *

How can you format numbers in Tableau as currency?

• A.Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
• B.Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
• C.Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.
• D.Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.

Correct Answer: A

Explanation
According to the official Tableau documentation:

Comment: *

Name: *

Email: *

Verification: *

Which of the following is the correct way to calculate Profit Ratio in Tableau?

• A.Profit / Sales
• B.Sales / Profit
• C.SUM(Profit) / SUM(Sales)
• D.SUM(Sales)/SUM(Profit)

Correct Answer: C

Explanation
THIS IS A VERY IMPORTANT QUESTION
Aggregation is an important concept to consider when creating calculated fields. A calculated field for SUM([Profit]) / SUM([Sales]) will give you a very different answer than [Profit] / [Sales], even though both formulas are valid.
If you do not provide the aggregation within the calculated field, Tableau will calculate the equation for every record ( row ) in your analysis, then aggregate the answers for all of the rows together when the calculated field is added to the view.
In simple terms, if specify the aggregation such as SUM, what Tableau will do is that it will first calculate the sum of the Profit column ( say x ), then calculate the sum of the Sales column ( say y ), and then simply apply x/y ---> This is what we expect! Perfect!
BUT, if you don't specify the aggregation, it will go to every single ROW, perform Profit / Sales, and then aggregate the answers calculated for each row. This is simply NOT what we wan't!
An example:

Comment: *

Name: *

Email: *

Verification: *

Which aggregation is available without requiring a table calculation or calculated field?

• A.Running total
• B.Standard deviation
• C.Sample covariance
• D.Percent of total

Comment: *

Name: *

Email: *

Verification: *

Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

• A.Nothing changes in the view, but a group is created in the Dimensions shelf.
• B.The colours of the members selected are now the same, and different for the rest of the members.
• C.Trick question! It is not possible to group by labels.
• D.A new mark (bar) is created, which consolidates all members of the group.

Correct Answer: D

Explanation
*Very important question*
If we select the labels in the view and then group, a new consolidated mark is created - in our case bar since we are talking about a bar chart in the question. See below:

Then on grouping, a new bar is created, and the colour of all bars remain the same.

Had we grouped by choosing the marks instead of the labels, the following would be the result:

Comment: *

Name: *

Email: *

Verification: *