Question 1

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Options :

A : False

B : True

Answer: B

Question 2

https://help.tableau.com/current/pro/desktop/en-gb/actions_highlight.htm

Options :

A : No

B : Yes

Answer: B

Question 3

True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

Options :

A : True

B : False

Answer: A

Question 4

You are analyzing sales data stored in a SQL Server database and corresponding sales targets maintained in an Excel spreadsheet. The sales data includes fields such as ‘Transaction ID’, ‘Product ID’, ‘Sale Date’, and ‘Amount’, while the sales targets include ‘Region’, ‘Quarter’, and ‘Target Amount’. There is no direct common field between these two data sources.Given the lack of a direct common field, which approach would allow you to analyze actual sales against targets in Tableau? Note: Do not make any assumptions.

Options :

A : Utilize Tableau’s cross-database join feature to combine the data sources without requiring a common field.

B : Perform a cross-database join using a calculated field to create a common key between the two data sources.

C : Use a data blend by manually defining a relationship through a common field, such as ‘Region’ or ‘Product ID’.

D : Create a new data source that combines both datasets externally, introducing a common field for blending.

Answer: D

Question 5

Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Options :

A : Brazil

B : Peru

C : Argentina

D : Mexico

Answer: D