ExamGecko
Home / Tableau / TDS-C01 / List of questions
Ask Question

Tableau TDS-C01 Practice Test - Questions Answers, Page 7

List of questions

Question 61

Report
Export
Collapse

True or False: A reference line cannot be added from the Analytics Pane

True
True
False
False
Suggested answer: B

Explanation:

You can add a reference line to any continuous axis in the view.

To add a reference line:

Drag Reference Line from the Analytics pane into the view. Tableau shows the possible destinations. The range of choices varies depending on the type of item and the current view.

In a simple case, the drop target area offers three options:

Tableau TDS-C01 image Question 61 explanation 76404 09232024004744000000

asked 23/09/2024
Allam Sunandhareddy
34 questions

Question 62

Report
Export
Collapse

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

True
True
False
False
Suggested 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.

Tableau TDS-C01 image Question 62 explanation 76405 09232024004744000000

asked 23/09/2024
Lipon Uddin
39 questions

Question 63

Report
Export
Collapse

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

ython
ython
Java
Java
Javascript
Javascript
None of these
None of these
Suggested answer: D

Explanation:

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.

Tableau TDS-C01 image Question 63 explanation 76406 09232024004744000000

The visualization updates to look like this:

Tableau TDS-C01 image Question 63 explanation 76406 09232024004744000000

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.

Tableau TDS-C01 image Question 63 explanation 76406 09232024004744000000

asked 23/09/2024
Miguel Villanueva
33 questions

Question 64

Report
Export
Collapse

Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Profit, State, Number of Records, Sales
Profit, State, Number of Records, Sales
Region, Country, Profit, State
Region, Country, Profit, State
Longitude, Country, State, Sales
Longitude, Country, State, Sales
Sales, State, Country, Profit
Sales, State, Country, Profit
Suggested answer: D

Explanation:

Since Sales is a measure, it can easily be depicted via size.

To drill down and change the level of detail, Country is the correct choice since it will contain STATE. We can then depict the various states by different shapes such as circle, square etc.

Finally, the Profit can be depicted via a color! Eg - Red for poor and green for excellent profits!

asked 23/09/2024
Alvaro Alejandro Zorrilla Tello
29 questions

Question 65

Report
Export
Collapse

When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Red, Blue
Red, Blue
Orange, Blue
Orange, Blue
Blue, Red
Blue, Red
Blue, Orange
Blue, Orange
Suggested answer: D

Explanation:

When using a Blend, the primary data source appears with a BLUE tick-mark and the secondary data source appears with a ORANGE tick-mark.

See below:

Tableau TDS-C01 image Question 65 explanation 76408 09232024004744000000

asked 23/09/2024
Juan Pablo Mateos Ornelas
46 questions

Question 66

Report
Export
Collapse

True or False: Context Filters are executed after Data Source filters

True
True
False
False
Suggested answer: A

Explanation:

THIS IS A VERY IMPORTANT QUESTION

To answer this question, you need to understand Tableau's Order of Operations. See below and remember this always:

Tableau TDS-C01 image Question 66 explanation 76409 09232024004744000000

asked 23/09/2024
AshokBabu Kumili
43 questions

Question 67

Report
Export
Collapse

For a relative date filter, the default anchor is _________________

The current time
The current time
Today's date
Today's date
The target date
The target date
The date we specify
The date we specify
Suggested answer: B

Explanation:


asked 23/09/2024
Ian Wilson
45 questions

Question 68

Report
Export
Collapse

True or False: To concatenate fields, they must be of same data type

True
True
False
False
Suggested answer: A

Explanation:

Yes! To concatenate fields, they must be of same data type. However, there is a workaround which we can use - Type casting. See below:

Tableau TDS-C01 image Question 68 explanation 76411 09232024004744000000

Here, State and City are Strings, but Postal Code? Nope. It's an Integer. So we can simply use the STR() function to convert it into a String, and hence the entire equation becomes valid!

asked 23/09/2024
Thomas Kringel
37 questions

Question 69

Report
Export
Collapse

Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

3.000
3.000
3.840
3.840
3.704
3.704
3.500
3.500
Suggested answer: C

Explanation:

Since we need to focus on 1 country -> Japan, let's filter on it first as follows:

1) Drag Country to the filter shelf, and choose only Japan. Click OK.

Tableau TDS-C01 image Question 69 explanation 76412 09232024004744000000

2) Read the Question Carefully, we need to break down the visualisation by Region, then by Country, and then by State. So let's do that:

Drag Region to the column shelf, followed by Country. Drill down into Country to include states as well.

Then drag Quantity to the Row Shelf, and change the Aggregation to AVERAGE.

The following is our visualisation:

Tableau TDS-C01 image Question 69 explanation 76412 09232024004744000000

Now that you think of it, EVEN IF YOU REMOVE THE REGION, THE ANSWER REMAINS THE SAME. Such elements will be present in the actual exam too, just to make the question sound a little difficult, but actually it is pretty straightforward :)

asked 23/09/2024
Bartosz Szewczyk
37 questions

Question 70

Report
Export
Collapse

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)?

Brazil
Brazil
Peru
Peru
Argentina
Argentina
Mexico
Mexico
Suggested answer: D

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:

Tableau TDS-C01 image Question 70 explanation 76413 09232024004744000000

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:

Tableau TDS-C01 image Question 70 explanation 76413 09232024004744000000

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

Tableau TDS-C01 image Question 70 explanation 76413 09232024004744000000

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

Tableau TDS-C01 image Question 70 explanation 76413 09232024004744000000

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*

Tableau TDS-C01 image Question 70 explanation 76413 09232024004744000000

Clearly, Mexico has the highest Shipping Delay!

asked 23/09/2024
Jeonghoon Park
29 questions
Total 318 questions
Go to page: of 32