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

What do the colours Blue and Green represent in Tableau?

• A.Discrete and Continuous
• B.Measures and Dimensions
• C.Continuous and Discrete
• D.Dimensions and Measures

Correct Answer: A

Important question! If you selected Dimension and Measure, don't worry! It is a very common mistake. But we're here to learn aren't we?
When you connect to a new data source, Tableau assigns each field in the data source as dimension or measure in the Data pane, depending on the type of data the field contains. You use these fields to build views of your data.

Comment: *

Name: *

Email: *

Verification: *

To connect Tableau to a CSV data source what type of connection should you use?

• A.Spatial
• B.Excel
• C.Text
• D.JSON

Correct Answer: C

Explanation
Tableau recognises a CSV file as a TEXT file, and therefore it is the correct option.
The following are the steps to import a CSV file:
1) From the data connection screen, click on Text:

2) Choose the appropriate file, and click Open:

3) Finally, Tableau imports the data as shown below:

Comment: *

Name: *

Email: *

Verification: *

You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

• A.Clean the data
• B.Preview the data
• C.Create visualisations to analyze your data
• D.Rename the fields and change data types

Correct Answer: C

The Tableau workspace consists of menus, a toolbar, the Data pane, cards and shelves, and one or more sheets.
Sheets can be worksheets, dashboards, or stories. For details on dashboard or story workspaces, see Create a Dashboard or The Story Workspace.
Graphical user interface, application Description automatically generated

The main thing you do in the workspace is to create visualisations to analyze your data.
Renaming data fields, cleaning the data, previewing the data can all be done in the Data source window.

Comment: *

Name: *

Email: *

Verification: *

When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

• A.reversed
• B.stepped
• C.diverging
• D.converging

Correct Answer: C

Comment: *

Name: *

Email: *

Verification: *