Tableau Desktop Certified Associate Practice Test - Questions Answers, Page 2
List of questions
Question 11
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Life Expectancy at birth' data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after 2000 for New Zealand.
Explanation:
Connect to the 'Life Expectancy at birth' excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.
Use the data Interpreter, it will correct the data.
Select the column 1960 to 2000. And Click on the Pivot option
Rename the two new columns as 'Years' and 'Life Expectancy'
Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.
Now, select column 2001 to 2013 and Select Add data to Pivot.
Select Country and Country Name field, Merge these fields.
Rename the merged field as Country.
Let's create the view.
Drop the country to the Filters and Select New Zealand. Drop the years to the columns and 'Life Expectancy' to the Text marks card. Change the aggregation to Avg (it won't make a difference here).
Right-Click on Life Expectancy -> Quick Table Calc -> Moving Average
Again, right-click on it and edit the table calculation.
Update the values as:
Result is:
Question 12
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
How to rename the Measure Names field in Tableau?
Explanation:
Measure Names is Tableau generated field, so you cannot rename it.
Question 13
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Groups can be used in a calculated field.
Explanation:
Group can be used in a calculated field
Question 14
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Using the Sales Analysis Dashboard, create a filter action that will trigger once you select any state in Sales by State View, and it should update the Profit Vs Sales view. Find out using trend lines in the Profit Vs Sales view, how much does profit increase for each dollar of sales for the California state?
Explanation:
Go to the Dashboard menu -> Actions -> Add Action -> Filter
Configure the properties as:
Ensure that West Region should be selected in the Region filter.
The final view should be:
profit increase by 0.133134 for each dollar of sales for the California state
Question 15
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Using the Sales Analysis Dashboard, If you click on any of the products, it should navigate to the All Products worksheet. How you will accomplish it?
Explanation:
Go to Dashboard->Actions and create the go to sheet action
Question 16
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Which of the following are the valid dashboard actions in Tableau?
Explanation:
Question 17
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Extract can't be created in which of the scenario?
Explanation:
A blend is worksheet-specific, so you cannot create the extract while creating a blend.
Question 18
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Global Superstore' data source and use the Orders table. Create a bar in bar chart and compare the profit against the target profit for Canada Region. Consider target profit is 30% of the sales. Which of the following sub-categories has met or exceed the target profit?
Explanation:
Drop Region at the filter and Select Canada
Drop Profit to columns and Sub-Category to Rows
Then drop the target profit to profit axis, it will create the combined axis chart.
Now drop the Measure Names field from the Rows to the Color Marks Card.
Go to the Analysis menu -> Stack Marks -> Off (so that your both profit and target profit bars will start from 0)
Tables, Labels and Copiers sub-categories has met or exceed the target profit.
Question 19
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Global Superstore' data source and use the Orders table. Create a view using Profit and Sales. Find out which sub-category is above the profit median but below the sales median value?
Explanation:
Drop Sales to columns and profit to rows, and Sub-Category to details.
Add two reference lines, one on the sales axis:
Add similarly on profit axis as well.
Out of the following options, only the Binders sub-category is above the profit median but below the sales median value.
Question 20
![Export Export](https://examgecko.com/assets/images/icon-download-24.png)
Connect to the 'Covid data' source. What is the percentage increase in the new cases from July 2020 to Jan 2021?
Explanation:
Create a filter on date field and select only July 2020 and Jan 2021.
Drop Date Month Discrete to Columns and New cases to the Text.
Right-Click on New Cases field and Quick Table Calc ->Percent Difference
Question