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

Explanation
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: *

How does Tableau know at which level to aggregate values?

• A.Values are always aggregated at the level of granularity of the worksheet.
• B.Tableau doesn't aggregate values, we do!
• C.Values are always aggregated at the level of the Date Part
• D.Aggregation is always done by using Tableau special formulas

Correct Answer: A

In Tableau, you can aggregate measures or dimensions, though it is more common to aggregate measures.
Whenever you add a measure to your view, an aggregation is applied to that measure by default. The type of aggregation applied varies depending on the context of the view.
When you add a measure to the view, Tableau automatically aggregates its values. Sum, average, and median are common aggregations; for a complete list, see List of Predefined Aggregations in Tableau.
The current aggregation appears as part of the measure's name in the view. For example, Sales becomes SUM(Sales). Every measure has a default aggregation which is set by Tableau when you connect to a data source. You can view or change the default aggregation for a measure-see Set the Default Aggregation for a Measure.
You can change the aggregation for a measure in the view from its context menu:

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid ways to add Totals to a view?

• A.Using the Data Pane
• B.Using the Analytics Pane
• C.From the Analysis Tab in the Menu bar on top
• D.Using the Marks shelf

Correct Answer: B,C

To add totals to a view using the Analytics pane:

Also, you can add totals from the Analytics tab in the Menu above:

Comment: *

Name: *

Email: *

Verification: *

What is the one most important thing you should do after creating a Dual-axis chart?

• A.Synchronise the axis
• B.Change the colours
• C.Edit the labels
• D.Hide the axis

Correct Answer: A

Explanation
After creating a dual axis chart, make sure to synchronise their axis since they both might not be having the same y-axis.

To align the two axes in a dual axes chart to use the same scale, right-click (control-click on Mac) the secondary axis, and select Synchronize Axis. This aligns the scale of the secondary axis to the scale of the primary axis.
In this example, the Sales axis is the secondary axis and the Profit axis is the primary axis.
If you would like to change which axis is the primary, and which axis is the secondary, select the field on the Columns or Rows shelf that is the secondary, and drag it in front of the primary field on the shelf until you see an orange triangle appear.
In this example, you can select the SUM(Sales) field on the Rows shelf, and drag it in front of the SUM(Profit) field. The Sales axis is now the primary and the Profit axis is the secondary.

Comment: *

Name: *

Email: *

Verification: *

How can you change the Default Aggregation for a measure in Tableau?

• A.By changing its properties manually every time we need to use it
• B.By right clicking the dimension -> Default properties and choosing Aggregation
• C.By right clicking the measure -> Default properties and choosing Aggregation
• D.By double clicking on the measure, and then choosing Window -> Default Aggregation

Correct Answer: C

According to the official Tableau documentation:

Dimensions don't have aggregation properties, and adding properties manually each time defeats the whole DEFAULT aggregation purpose. Window tab doesn't have any default aggregation option!

Comment: *

Name: *

Email: *

Verification: *