Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 6
List of questions
Question 51
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Tableau automatically associates continuous fields with categorical palettes.
Explanation:
Tableau automatically associates discrete fields with categorical palettes
Refer: https://help.tableau.com/current/pro/desktop/en-us/visual_best_practices.htm
Question 52
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
In LOD calculation, we can use fields from multiple data sources (blended data source)?
Explanation:
Here, the Location is in a primary data source, and the population field is in a secondary data source.
So the answer is FALSE.
Question 53
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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)?
Explanation:
Right Click on the Customer Name -> Create -> Set
Create a calculated field:
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.
Sort the Profit.
Question 54
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
How can we add Visualization in a tooltip?
Explanation:
Only 1 and 2 options are correct.
For these types of questions, please take the help of the Tableau software during your exam.
Question 55
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Add year and location filter as:
Drop Name, year, month to the rows. Change year and month to discrete from continuous.
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.
Question 56
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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?
Explanation:
Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.
Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add
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.
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:
Question 57
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
How to create custom territories on a map?
Explanation:
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_custom_territories.htm
Question 58
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Using which options you can automatically add the phone layouts on your dashboard?
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
Question 59
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
Explanation:
Select New York State, you are getting only 3 products, and not 5.
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)
Select Add to Context on the State filter
Question 60
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
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.
Explanation:
Select California State from the Map
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.
Question