Pass the Tableau Desktop Specialist TDS-C01 Questions and answers with ExamsMirror

Explanation

It is possible to join a maximum of 32 tables in Tableau!

You can change the device layout of a dashboard by using the Dashboard pane or the Dashboard menu. The Dashboard pane allows you to select a device type and customize the layout for that device. The Dashboard menu allows you to create a new device layout or copy an existing one. The Format menu and the Layout pane do not have options for changing the device layout1

Explanation

This question is directly from the Official Tableau Desktop Specialist exam guide.

Since we are talking about the AVERAGE home values for the United States in 2016, the question is directly offering us a hint that the answer has something to do with aggregation and that too the values tell us that we're working with MEASURES.

Date part and Date values don't really make much sense given the question, and neither does geography.

Therefore, the answer naturally is "An aggregated measure".

Explanation

Tableau auto-generates :

1 Dimension - Measure Names

4 Measures - Latitude, Longitude, Number of records, Measure Values

Starting with Tableau 2020.2, every table in a data source has a Count field, in the form of NameofTable(Count). The table count field is an automatically generated, calculated field. (THIS IS NOT PRESENT IN VERSION 2020.1 ON WHICH THE EXAM IS CURRENTLY BASED)

According to the official Tableau documentation:

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!

According to the [Tableau Desktop Specialist Exam Guide], an incremental refresh only adds rows that are new, based on a specified column and value. A full refresh replaces all the extracted data with the data in the underlying data source. A full refresh is usually very slow, especially for large extracts. An incremental refresh can take less time, depending on how many new rows are added. A full refresh does not need to be configured, it is the default option for extracts in Tableau. An incremental refresh can be run from both Tableau Desktop and Tableau Server.

Explanation

VERY IMPORTANT QUESTION FOR THE EXAM, PAY ATTENTION

1) To find the number of days between order date and shipping date, we will make use of a calculated field:

In the data pane, click on the dropdown arrow, and choose create calculated field.

Let's name this calculated field "ShippingDelay" (you can name it anything you want :) )

2) Use the DATEDIFF() function, and pass it the arguments as follows:

'day' depicts that we want to calculate the number of DAYS between the two dates. The first argument is 'start_date' which is the ORDER_DATE (day the order was placed), the second argument is 'end_date', which is the SHIP_DATE (date the order was shipped). So by subtracting as follows: SHIP_DATE - ORDER_DATE, we can find the delay in shipping.

Click OK.

3) You should now have a new measure as follows:

4) Phew! The hard part is done! Now let's filter by Market to include only LATAM:

5) Drag Country to the view, and the new calculated field 'ShippingDelay' to SIZE on the Marks Shelf as follows:

*You can also click on Show Text Labels to be sure that you're choosing the Largest value*

Clearly, Mexico has the highest Shipping Delay!

Explanation

When using a Percent difference, Tableau calculates what the percent change has occured as compared to the last data value. BUT, for the first data value, there is no previous value to compare it to. Hence, it appears as NULL.

Explanation

It is possible to open a Tableau support case by visiting the following link : https://www.tableau.com/support/case