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

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

So the answer is FALSE.

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.

Only 1 and 2 options are correct.

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

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.

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:

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

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

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

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.