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

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

List of questions

Question 41

Report
Export
Collapse

What is the default join type when you blend two data sources?

Inner join
Inner join
Outer join
Outer join
Left outer join
Left outer join
Right join
Right join
Suggested answer: C

Explanation:

Blend is the left outer join after aggregation at the level of granularity.

asked 23/09/2024
Ankitkumar Pandya
34 questions

Question 42

Report
Export
Collapse

Which calculation will color the sales by state, while the city is on the Marks card, as shown in this view?

Larger image

Tableau Desktop Certified Associate image Question 42 75972 09232024004713000000

{SUM([Sales])}
{SUM([Sales])}
{ Exclude [City] : SUM([Sales])}
{ Exclude [City] : SUM([Sales])}
{ Exclude [State] : SUM([Sales])}
{ Exclude [State] : SUM([Sales])}
{ Exclude : SUM([Sales])}
{ Exclude : SUM([Sales])}
Suggested answer: B

Explanation:

{ Exclude [City] : SUM([Sales])} => using this calculation we can exclude the City dimension from all the dimensions present in the view. So here SUM(sales) would be the aggregation of sales in the state level only, even though city field is available in the view.

asked 23/09/2024
giorgi durglishvili
42 questions

Question 43

Report
Export
Collapse

Connect to the 'Global Superstore' data source and use the Orders table. Find out how many new customers were acquired in the year 2014?

4419
4419
5412
5412
4719
4719
5216
5216
Suggested answer: A

Explanation:

If customer first order is equal to the order date, then this is the new customer.

Create a calculated field to find the first order date:

Find If the order date is equal to the day of first purchase for that customer, flag that row as a

'New Customer'

Find the unique customers:

Drop the Order date to filter shelf and select the year 2014 to find out the new customer acquired in 2014.

Drop New Customer field to Rows and Unique customer field to Text marks card.

asked 23/09/2024
Arash Farivarmoheb
42 questions

Question 44

Report
Export
Collapse

Use custom geocoding, when you need ___________ locations to map your data.

Default
Default
States
States
User-defined
User-defined
Tableau generated
Tableau generated
Suggested answer: C

Explanation:

Custom geocoding means that you assign latitude and longitude coordinates to your locations so Tableau can plot them accurately.

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

asked 23/09/2024
J.L.M. van Loo
48 questions

Question 45

Report
Export
Collapse

Connect to the 'Global Superstore' data source and use the Orders table. Predict the profit of January 2016 using the profit data through December 2015. What is the profit value of January 2016?

$35,152
$35,152
$33,759
$33,759
$46,917
$46,917
$39,921
$39,921
Suggested answer: A

Explanation:

Drop the Orders Date to the Columns shelf and change it to the Month Date Value and drop the profit to the rows shelf. Your view will look like this:

Tableau Desktop Certified Associate image Question 45 explanation 75975 09232024004713000000

Go to the Analytics tab and drop the Forecast to your view.

Right-Click on the view, Select Forecast -> Forecast Options. Change the Ignore last to 0 months,

Tableau Desktop Certified Associate image Question 45 explanation 75975 09232024004713000000

$35,152 is the correct answer.

Tableau Desktop Certified Associate image Question 45 explanation 75975 09232024004713000000

asked 23/09/2024
Ali Alaqoul
43 questions

Question 46

Report
Export
Collapse

Why we convert a numeric measure to a dimension?

To aggregate the field
To aggregate the field
To show the labels in your view
To show the labels in your view
To use this field in LOD
To use this field in LOD
To disaggregate the field
To disaggregate the field
Suggested answer: D

Explanation:

Measures are by default aggregated. We can change measures to dimensions if we want disaggregate that field.

asked 23/09/2024
WONG CHUN KIT WONG CHUN KIT
28 questions

Question 47

Report
Export
Collapse

Connect to the 'Significant Volcano Eruption' data source. In 1899, the Dona Juana volcano erupted in Colombia. Find out which volcano in the Popayn city is the closest to Dona Juana and how many death Dona Juana volcano caused?

Purace, 55
Purace, 55
Galeras, 55
Galeras, 55
Purace, 0
Purace, 0
Galeras, 0
Galeras, 0
Suggested answer: A

Explanation:

Drop the Latitude and Longitude fields to Rows and Columns shelf respectively. Or double click on these fields.

Drop the Location field to Filter shelf, select the Location as Colombia.

Drop the Name field to the Label.

To show the cities go to the Map -> Map layer and Check the Cities.

Tableau Desktop Certified Associate image Question 47 explanation 75977 09232024004713000000

Drop the Deaths and Year fields to the Tooltip. Now your view looks like this:

Tableau Desktop Certified Associate image Question 47 explanation 75977 09232024004713000000

Zoom-in the map, you will find Purace is the nearest one in the Popayn city and Dona Juana was having 55 deaths.

Tableau Desktop Certified Associate image Question 47 explanation 75977 09232024004713000000

asked 23/09/2024
Cynthia Gutknecht
46 questions

Question 48

Report
Export
Collapse

Which of the following are true regarding the data highlighter in Tableau?

You can turn on the highlighter for any field available in your view.
You can turn on the highlighter for any field available in your view.
If you update the underlying data source for your view the data shown in the highlighter is automatically updated too.
If you update the underlying data source for your view the data shown in the highlighter is automatically updated too.
If you have multiple highlighters showing on a dashboard, only one highlighter can be active at a time.
If you have multiple highlighters showing on a dashboard, only one highlighter can be active at a time.
If you want to change the format for the highlighter card after you turn it on, select Format > Highlighter.
If you want to change the format for the highlighter card after you turn it on, select Format > Highlighter.
Suggested answer: B, C, D

Explanation:

The first option is wrong here, you can turn on the highlighter only for the discrete fields in your view.

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

asked 23/09/2024
Johny Nguyen
29 questions

Question 49

Report
Export
Collapse

Which LOD calculations can be used in Columns shelf to create this view?

Larger image

Tableau Desktop Certified Associate image Question 49 75979 09232024004713000000

{ FIXED [Category] : SUM([Profit])}
{ FIXED [Category] : SUM([Profit])}
{ FIXED [Region] : SUM([Profit])}
{ FIXED [Region] : SUM([Profit])}
{FIXED : SUM([Profit])}
{FIXED : SUM([Profit])}
{SUM([Profit])}
{SUM([Profit])}
Suggested answer: C, D

Explanation:

{ FIXED [Category] : SUM([Profit])} - It calculates the profit of each category. In our view, all the profits values are the same, so it is not the right answer.

{ FIXED [Region] : SUM([Profit])} - It calculates the profit of each region.

{SUM([Profit])} is equivalent to {FIXED : SUM([Profit])}. It is the table level scope, which means this is the profit of the entire dataset.

asked 23/09/2024
Chien-Chung Chen
36 questions

Question 50

Report
Export
Collapse

Connect to the 'Significant Volcano Eruption' data source. Using the elevations field, create bins of size 1000 and find out in which bin has the most total deaths?

0
0
1000
1000
2000
2000
3000
3000
Suggested answer: C

Explanation:

Select the 'Elevation' field from measures, and go to show me. Click on Histogram.

Right-Click on the 'Elevation (bin)' dimension and select Edit. Change the size of bins to 1000.

Tableau Desktop Certified Associate image Question 50 explanation 75980 09232024004713000000

Drop the Total Death to Label.

Tableau Desktop Certified Associate image Question 50 explanation 75980 09232024004713000000

The total number of deaths reported in the bin of 2000.

Note that the lower limit is inclusive. So 2000 bin means 2000 to 2999.

asked 23/09/2024
Suman Konda
46 questions
Total 108 questions
Go to page: of 11