True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

• A.True
• B.False

Correct Answer: A

Joins combine tables by adding more columns of data across similar row structures. This can cause data loss or duplication if tables are at different levels of detail, and joined data sources must be fixed before analysis can begin.

Inner join

Left Join
Blends, unlike relationships or joins, never truly combine the data. Instead, blends query each data source independently, the results are aggregated to the appropriate level, then the results are presented visually together in the view.

Comment: *

Name: *

Email: *

Verification: *

According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

• A.Dimension Filter
• B.Measure Filter
• C.Context Filter
• D.Extract Filter

Correct Answer: D

Explanation
According to Tableau's order of operations, the Extract filter is right at the top of the hierarchy. The data filtered in the Extract is then passed on to what we see in the Data Pane. See below:

Comment: *

Name: *

Email: *

Verification: *

To use a quick table calculation, which of the following programming languages do you need to know?

• A.ython
• B.Java
• C.Javascript
• D.None of these

Correct Answer: D

You don't need to know ANY programming language to use quick table calculations!
Follow along with the steps below to learn how to apply a quick table calculation to a visualization:
1) Open Tableau Desktop and connect to the Sample-Superstore data source, which comes with Tableau.
2) Navigate to a new worksheet.
3) From the Data pane, under Dimensions, drag Order Date to the Columns shelf.
4) From the Data pane, under Dimensions, drag State to the Rows shelf.
5) From the Data pane, under Measures, drag Sales to Text on the Marks Card.
6) From the Data pane, under Measures, drag Profit to Color on the Marks Card.
7) On the Marks card, click the Mark Type drop-down and select Square.

The visualization updates to look like this:

Apply the quick table calculation
1) On the Marks card, right-click SUM(Profit) and select Quick Table Calculation > Moving Average.
Note: You can only perform quick table calculations on measures in the view.
A delta symbol appears on the field to indicate that a quick table calculation is being applied to the field. The colors in the visualization update to show the moving average of profit across the years.

Comment: *

Name: *

Email: *

Verification: *

You can use the __________________ in Tableau to clean / organise your data.

• A.Data cleaner
• B.Data manager
• C.Data interpreter
• D.Data organiser

Correct Answer: C

When you track data in Excel spreadsheets, you create them with the human interface in mind. To make your spreadsheets easy to read, you might include things like titles, stacked headers, notes, maybe empty rows and columns to add white space, and you probably have multiple tabs of data too.
When you want to analyze this data in Tableau, these aesthetically pleasing attributes make it very difficult for Tableau to interpret your data. That's where Data Interpreter can help.

Comment: *

Name: *

Email: *

Verification: *

Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.

• A.Video
• B.Text
• C.Extension
• D.Image
• E.Web Page

Correct Answer: B,C,D,E

Video is NOT a valid object type while creating dashboards in Tableau! All others are valid object types.

Comment: *

Name: *

Email: *

Verification: *