Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 7
List of questions
Question 61
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Global Superstore' data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?
Explanation:
Create a Calculation to get the first alphabet of the customer name.
Now drop the First Alphabet field to Rows and Quantity field to the Text on the Marks card. Change the aggregation from SUM to AVG. Your view will look like this:
Question 62
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Global Superstore' data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?
Explanation:
Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.
Drop the City to the view, and add the State to the Filter shelf and select North Carolina.
Also, drop the Order Date to the Filters and select year 2012, 2013, 2014
Now, drop the Profit field to the tooltip. As of now, your view should look like this:
Now, we have to find the total profit earned by all the cities in Wake County.
Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.
To show the County go to the Map->Map Layers.
Check County Names and County Borders.
the total profit earned by all the cities in Wake County is $403.
Question 63
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Significant Volcano Eruption' data source. What percentage of total deaths caused by volcanoes which were having a volcano index greater than 2 and elevation greater than 5000?
Explanation:
Create a calculated field as:
Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.
Question 64
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which of the following are true regarding parameter actions?
Explanation:
While creating the parameter action, it is not mandatory to specify the aggregation.
All others are true.
Refer: https://help.tableau.com/current/pro/desktop/en-us/actions_parameters.htm
Question 65
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You are unable to join two tables because tableau throws the type mismatch error. How you can solve it most likely?
Explanation:
Use join Calculations while joining two tables.
Question 66
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
While creating which of the chart type, we turn off the stack marks from the analysis menu?
Explanation:
While creating Bar in bar chart, we turn off the stacked marks so that both the bars will start from 0.
Question 67
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table. Which join type will you use?
Explanation:
When you use a left join to combine tables, the result is a table that contains all values from the left table and corresponding matches from the right table.
Refer Join Types: https://help.tableau.com/current/pro/desktop/en-us/joining_tables.htm
Question 68
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Kiva Loans - India' data source, which sector's funded amount is closest to the median of all the sectors?
Explanation:
Drop Sector to columns and Funded Amount to Rows.
From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.
Your view will look like this:
Here, the Clothing funded amount is exactly similar to the Median.
Question 69
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
What are the types of annotations available in Tableau?
Explanation:
Question 70
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Kiva Loans - India' data source, find out the average number of days it took to disbursed the funded amount in catering activity, and what is the total funded amount?
Explanation:
Filter the Activity = Catering
Drop the activity to rows, and no of days to columns, change the aggregation to AVG.
Also, drop the Funded Amount to the Tooltip.
Question