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

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

List of questions

Question 31

Report
Export
Collapse

Which type of sort is applied in the Ship Mode field?

Larger image

Tableau Desktop Certified Associate image Question 31 75961 09232024004713000000

Field Sort
Field Sort
Nested Sort
Nested Sort
Alphabetic Sort
Alphabetic Sort
Data Source Order
Data Source Order
Suggested answer: B

Explanation:

Refer to Nested Sort section: https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sorting_computed_howto.htm

asked 23/09/2024
Lionel Fitzgerald Gweth
44 questions

Question 32

Report
Export
Collapse

Connect to the 'Global Superstore' data source and use the Orders table. Create a view showing sales over continuous months, find out which trend line model type provides the lowest R-squared value?

Linear
Linear
Exponential
Exponential
Polynomial, Degree 2
Polynomial, Degree 2
Polynomial, Degree 3
Polynomial, Degree 3
Suggested answer: A

Explanation:

Drop Order Date to the Columns and change it to continuous month. Drop sales to the rows.

Go to Analytics and drop the trend line. Check for all trend lines, Linear is having the lowest R Square.

Tableau Desktop Certified Associate image Question 32 explanation 75962 09232024004713000000

asked 23/09/2024
Tobias Barcelos
42 questions

Question 33

Report
Export
Collapse

Connect to the 'Covid data' source. Create a line chart using continuous months and new deaths. Find the Excess Kurtosis for the sum of new deaths.

-0.56
-0.56
-0.67
-0.67
-0.69
-0.69
-0.58
-0.58
Suggested answer: B

Explanation:

Drop the Date to the columns and select the continuous month. Drop New Deaths to rows.

Click on the Show/Hide card and enable the Summary Card.

Tableau Desktop Certified Associate image Question 33 explanation 75963 09232024004713000000

You will see the Summary Card on the right, if Excess Kurtosis is not enabled, click on the drop-down and select the Excess Kurtosis.

Tableau Desktop Certified Associate image Question 33 explanation 75963 09232024004713000000

asked 23/09/2024
Subhendu Bhattacharyya
36 questions

Question 34

Report
Export
Collapse

Connect to the 'Global Superstore' data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields. Which of the following are true from the below options?

The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)
The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765
The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment
The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)
The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)
Suggested answer: A, B

Explanation:

Create a hierarchy of Segment, Category, Region and drop it into the rows.

Tableau Desktop Certified Associate image Question 34 explanation 75964 09232024004713000000

Create profit ratio calculated field:

Tableau Desktop Certified Associate image Question 34 explanation 75964 09232024004713000000

Drop the profit and profit ratio fields to the view, your view will look like this:

Tableau Desktop Certified Associate image Question 34 explanation 75964 09232024004713000000

Now let's go through each answer option.

1) The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment - The profit ratio is -142.26% which is lowest overall so it is true.

2) The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765 - It is true, the profit ratio is 2.06%, which is third-lowest.

3) The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment - False, it is having a $2,245 profit.

4) The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment - False

Note: This is an easy question but time consuming, so attempt these types of questions in the end.

asked 23/09/2024
Ida Aasvistad
35 questions

Question 35

Report
Export
Collapse

Connect to the 'Significant Volcano Eruption' data source. How many volcano eruptions took place within 30 miles of the Black Peak volcano in the Alaska Peninsula?

0
0
1
1
2
2
3
3
Suggested answer: A

Explanation:

Add the Latitude to Rows and Longitude to columns. Or double click on these fields.

Don't use Latitude (generated)/Longitude (generated) fields.

Drop Location to filter and select 'Alaska Peninsula'

Drop Name to the Label Marks card.

Your view will look like this:

Tableau Desktop Certified Associate image Question 35 explanation 75965 09232024004713000000

Use the radial selection tool to find the number of volcano eruptions that took place within 30 miles of the Black Peak volcano. You need to zoom-in first, only then you would be able to find the distance using a radial selection tool.

Tableau Desktop Certified Associate image Question 35 explanation 75965 09232024004713000000

There were no eruptions that took place with 30 miles of Black Peak.

asked 23/09/2024
Karol Ligeza
37 questions

Question 36

Report
Export
Collapse

Which of the following map layers are available in Tableau?

Neighborhoods
Neighborhoods
Points of Interest
Points of Interest
Cities Borders
Cities Borders
Area Code Labels
Area Code Labels
Suggested answer: A, B, D

Explanation:

Go to the Map -> Map Layer

Cities Borders is not valid.

Tableau Desktop Certified Associate image Question 36 explanation 75966 09232024004713000000

asked 23/09/2024
Wai Kiat Wong
34 questions

Question 37

Report
Export
Collapse

Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?

7
7
8
8
9
9
10
10
Suggested answer: B

Explanation:

First, find the distinct sports for each country:

Tableau Desktop Certified Associate image Question 37 explanation 75967 09232024004713000000

It will be created as a Measure, move this to Dimension

Get the distinct countries:

Tableau Desktop Certified Associate image Question 37 explanation 75967 09232024004713000000

drop these columns to the view, final view will look like this:

The X-axis represents a number of distinct sports. As the data set contains data from 2000 to 2012, so even if you don't include the filter, your answer would remain the same.

Tableau Desktop Certified Associate image Question 37 explanation 75967 09232024004713000000

asked 23/09/2024
Jonathan Correa
45 questions

Question 38

Report
Export
Collapse

Connect to the Olympic Athletes data source, find out the average age of players who won at least one gold medal for the country?

26.33 (Correct)
26.33 (Correct)
26.41
26.41
26.72
26.72
26.02
26.02
Suggested answer: A

Explanation:

Drop the Age to the columns and change the aggregation to AVG.

Drop Gold Medals field to filter and select All values ->

Tableau Desktop Certified Associate image Question 38 explanation 75968 09232024004713000000

Change 1 from 0.

Tableau Desktop Certified Associate image Question 38 explanation 75968 09232024004713000000

asked 23/09/2024
Mehdi BELGAS
46 questions

Question 39

Report
Export
Collapse

Connect to the 'Significant Volcano Eruption' data source. What is the interquartile range of the distribution of Total Injuries data of the 21st century (show null values at default location)?

32
32
48
48
30
30
42
42
Suggested answer: C

Explanation:

Drop year to filter shelf and select from 2000.

Tableau Desktop Certified Associate image Question 39 explanation 75969 09232024004713000000

Drop Total injuries field to rows, go to Analysis -> Aggregated Measures (Untick this, it will disaggregate the total injuries field.

Click on Show Me, and select Box and whisker Plot.

IQR = Upper hinge - Lower hinge

Tableau Desktop Certified Associate image Question 39 explanation 75969 09232024004713000000

Here IQR = 32 -2 = 30

asked 23/09/2024
Yuri Mitrofanov
44 questions

Question 40

Report
Export
Collapse

Which of the following are forecast quality metrics available in Tableau?

RMSE
RMSE
MAPE
MAPE
AISE
AISE
MASE
MASE
Suggested answer: A, B, D

Explanation:

Refer section "Quality Metrics" at https://help.tableau.com/current/pro/desktop/enus/

forecast_describe.htm

asked 23/09/2024
Ramon Lim
37 questions
Total 108 questions
Go to page: of 11
Search