ExamGecko
Home / Tableau / Desktop Certified Associate / List of questions
Ask Question

Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 6

List of questions

Question 51

Report
Export
Collapse

Tableau automatically associates continuous fields with categorical palettes.

True
True
False
False
Suggested answer: B

Explanation:

Tableau automatically associates discrete fields with categorical palettes

Refer: https://help.tableau.com/current/pro/desktop/en-us/visual_best_practices.htm

asked 23/09/2024
Dina Elizabeth Perez de Paz
42 questions

Question 52

Report
Export
Collapse

In LOD calculation, we can use fields from multiple data sources (blended data source)?

True
True
False
False
Suggested answer: B

Explanation:

Tableau Desktop Certified Associate image Question 52 explanation 75982 09232024004713000000

Here, the Location is in a primary data source, and the population field is in a secondary data source.

So the answer is FALSE.

asked 23/09/2024
Piotr Szwajkowski
39 questions

Question 53

Report
Export
Collapse

Connect to the 'Global Superstore' data source and use the Orders table. Which of the customer names are in the Top 20 by sales, calculate the profit ratio for these customers and find out who all are in the bottom 5 in profit ratio (within these customers)?

Sean Miller
Sean Miller
Raymond Buch
Raymond Buch
Art Ferguson
Art Ferguson
Bart Watters
Bart Watters
Suggested answer: A, C

Explanation:

Right Click on the Customer Name -> Create -> Set

Tableau Desktop Certified Associate image Question 53 explanation 75983 09232024004713000000

Create a calculated field:

Tableau Desktop Certified Associate image Question 53 explanation 75983 09232024004713000000

Drop the Top 20 by Sales set, Customer Name to Rows.

Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.

Tableau Desktop Certified Associate image Question 53 explanation 75983 09232024004713000000

Sort the Profit.

Tableau Desktop Certified Associate image Question 53 explanation 75983 09232024004713000000

asked 23/09/2024
Veacheslav Stasiuc
33 questions

Question 54

Report
Export
Collapse

How can we add Visualization in a tooltip?

Go to the Tooltip on the marks card, and click insert -> sheets
Go to the Tooltip on the marks card, and click insert -> sheets
Go to the Worksheet menu, click on Tooltip and click Insert -> sheets
Go to the Worksheet menu, click on Tooltip and click Insert -> sheets
Go to the Format menu, click on Tooltip and click Insert -> sheets
Go to the Format menu, click on Tooltip and click Insert -> sheets
Right Click on the view, Tooltip and add insert -> sheets
Right Click on the view, Tooltip and add insert -> sheets
Suggested answer: A, B

Explanation:

Only 1 and 2 options are correct.

For these types of questions, please take the help of the Tableau software during your exam.

asked 23/09/2024
Donnie Roach
29 questions

Question 55

Report
Export
Collapse

Connect to the 'Significant Volcano Eruption' data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?

1
1
2
2
3
3
4
4
Suggested answer: C

Explanation:

Add year and location filter as:

Tableau Desktop Certified Associate image Question 55 explanation 75985 09232024004713000000

Tableau Desktop Certified Associate image Question 55 explanation 75985 09232024004713000000

Drop Name, year, month to the rows. Change year and month to discrete from continuous.

Tableau Desktop Certified Associate image Question 55 explanation 75985 09232024004713000000

So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.

You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.

Tableau Desktop Certified Associate image Question 55 explanation 75985 09232024004713000000

asked 23/09/2024
dennis schouwenaars
35 questions

Question 56

Report
Export
Collapse

Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country. Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?

Indonesia and 95,055,669
Indonesia and 95,055,669
Japan and 96,812,000
Japan and 96,812,000
Indonesia and 9,103,406,453
Indonesia and 9,103,406,453
Japan and 9,103,406,453
Japan and 9,103,406,453
Suggested answer: A

Explanation:

Add the Country population excel sheet as a New Data Source.

Select column 1960 to 2013, click on Pivot.

Tableau Desktop Certified Associate image Question 56 explanation 75986 09232024004713000000

Rename the new fields as Year and population.

Go to Data ->Edit Blend Relationship

Click on Custom and Add

Tableau Desktop Certified Associate image Question 56 explanation 75986 09232024004713000000

Ensure the blend relationship exists in Country & Country Name, and year & year between primary and secondary data sources.

Drop the year to the filters shelf and only enter 1963.

Tableau Desktop Certified Associate image Question 56 explanation 75986 09232024004713000000

Drop Country and Number of Records / volerup(Count) field to the view.

And drop population to the view from the secondary data source. Your view will look like this:

Tableau Desktop Certified Associate image Question 56 explanation 75986 09232024004713000000

asked 23/09/2024
Tania Trif
50 questions

Question 57

Report
Export
Collapse

How to create custom territories on a map?

Create a territory from a geographic field
Create a territory from a geographic field
By using a background image on a map
By using a background image on a map
Select and group locations on a map
Select and group locations on a map
Geocode a territory field using another geographic field
Geocode a territory field using another geographic field
Suggested answer: A, C, D

Explanation:

Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_custom_territories.htm

asked 23/09/2024
Giulia Alberghi
43 questions

Question 58

Report
Export
Collapse

Using which options you can automatically add the phone layouts on your dashboard?

choose Dashboard > Add Phone Layouts to Existing Dashboards
choose Dashboard > Add Phone Layouts to Existing Dashboards
In device preview mode, check the Tableau mobile app
In device preview mode, check the Tableau mobile app
choose Dashboard > Add Phone Layouts to New Dashboards
choose Dashboard > Add Phone Layouts to New Dashboards
Select Size and then choose Phone
Select Size and then choose Phone
Suggested answer: A, C

Explanation:

Automatically add phone layouts

Two options let you automatically add phone layouts:

To create phone layouts whenever you open old dashboards that lack them, choose Dashboard > Add Phone Layouts to Existing Dashboards

To create phone layouts whenever you create a new dashboard, choose Dashboard > Add Phone Layouts to New Dashboards. (This option is on by default.)

Refer: https://help.tableau.com/current/pro/desktop/en-us/dashboards_dsd_create.htm

asked 23/09/2024
Andrea Trivisonno
31 questions

Question 59

Report
Export
Collapse

Using the Profit Analysis Dashboard twbx file, find out the 5th most profitable product in the state of New York? You can add the functionality to the dashboard.

GBC DocuBind TL300 Electric Binding System
GBC DocuBind TL300 Electric Binding System
Canon imageCLASS 2200 Advanced Copier
Canon imageCLASS 2200 Advanced Copier
Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind
Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind
HP Designjet T520 Inkjet Large Format Printer - 24' Color
HP Designjet T520 Inkjet Large Format Printer - 24' Color
Suggested answer: A

Explanation:

Select New York State, you are getting only 3 products, and not 5.

Tableau Desktop Certified Associate image Question 59 explanation 75989 09232024004713000000

You need to add State as a Context filter in the Top 5 profitable products View. For that, go to the Top 5 profitable products sheet. (click on small arrow)

Tableau Desktop Certified Associate image Question 59 explanation 75989 09232024004713000000

Select Add to Context on the State filter

Tableau Desktop Certified Associate image Question 59 explanation 75989 09232024004713000000

Tableau Desktop Certified Associate image Question 59 explanation 75989 09232024004713000000

asked 23/09/2024
Aung Zin
41 questions

Question 60

Report
Export
Collapse

Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by California State in the West region? You can add the functionality to the dashboard.

$3,251
$3,251
$3,448
$3,448
$517
$517
$987
$987
Suggested answer: C

Explanation:

Select California State from the Map

Tableau Desktop Certified Associate image Question 60 explanation 75990 09232024004713000000

Topic 2, Exam Pool B

Download the Dataset from here:

https://drive.google.com/file/d/1z7LPBQNPWHChteShl0QL3yu_JcvstLGl/view?usp=sharing

Use the above data set to answers the questions under Exam Pool B.

asked 23/09/2024
marwan albahar
33 questions
Total 108 questions
Go to page: of 11