[Q43-Q66] Desktop-Certified-Associate Free Update With 100% Exam Passing Guarantee [2021]

Desktop-Certified-Associate Free Update With 100% Exam Passing Guarantee [2021]

[Sep-2021] Verified Tableau Exam Dumps with Desktop-Certified-Associate Exam Study Guide

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

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
First, find the distinct sports for each country:
Graphical user interface Description automatically generated with medium confidence

It will be created as a Measure, move this to Dimension
Get the distinct countries:
Graphical user interface Description automatically generated with medium confidence

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.
Chart Description automatically generated

NEW QUESTION 44
Which of the following map layers are available in Tableau?

A. Cities Borders
B. Area Code Labels
C. Neighborhoods
D. Points of Interest

Answer: B,C,D

Explanation:
Go to the Map -> Map Layer
Cities Borders is not valid.
Graphical user interface, text, application, chat or text message Description automatically generated

NEW QUESTION 45
Connect to the "Global Superstore" data source and use the Orders table. Find out how many distinct customers have made 6 orders?

A. 0
B. 1
C. None of the above
D. 2

Answer: D

Explanation:
Find out the distinct orders for each customer
Graphical user interface, text, application Description automatically generated

Move this field from Measure to Dimension.
Drop this field to the Columns Shelf and drop customer ID to Rows, aggregate the Customer ID using CountD, and drop this field to Label as well. Your view will look like this:
Chart Description automatically generated

29 distinct customers have made 6 orders.

NEW QUESTION 46
Connect to the "World Cup Results" and use table WorldCups. Create a bar graph using the Year and Matches Played. For how many years the number of matches played was less than 70% of the median?

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
Explanation
Drop the year to the Columns and change it Discrete. Drop the matches played to the Rows.
Go to the Analytics menu, drop the Distribution band to the view. Select scope as entire table.
Value Computation should be:

Your view will look like this:

NEW QUESTION 47
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?

A. 0.294316
B. 0.167531
C. 0.133134
D. 0.180067

Answer: C

Explanation:
Go to the Dashboard menu -> Actions -> Add Action -> Filter
Configure the properties as:
Graphical user interface Description automatically generated

Ensure that West Region should be selected in the Region filter.
The final view should be:
Map Description automatically generated

profit increase by 0.133134 for each dollar of sales for the California state

NEW QUESTION 48
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?

A. Linear
B. Exponential
C. Polynomial, Degree 2
D. Polynomial, Degree 3

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.
Chart, line chart Description automatically generated

NEW QUESTION 49
Which of the following is true about spatial files?

A. You cannot join spatial data source with the non-spatial data source
B. You cannot apply filters in your view if it is creates using the spatial data source
C. You cannot create a dual-axis chart using spatial data
D. None of the above

Answer: D

Explanation:
All are false here.
Refer: https://help.tableau.com/current/pro/desktop/en-us/maps_shapefiles.htm

NEW QUESTION 50
Groups can be used in a calculated field.

A. True
B. False

Answer: A

Explanation:
Group can be used in a calculated field
Graphical user interface, text, application Description automatically generated

NEW QUESTION 51
Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?

A. North Africa
B. Western US
C. Southern Africa
D. Eastern Asia

Answer: C

Explanation:
Explanation
Create a left outer join, so that we can calculate the percentage of the returned orders

Create a calculated field "% of returned orders":

Drop the Order Date to the filters shelf and select the year 2013
Drop the Region to the rows and % of returned orders to the Text:

NEW QUESTION 52
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)?

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
Drop year to filter shelf and select from 2000.
Graphical user interface Description automatically generated

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
Graphical user interface Description automatically generated with low confidence

Here IQR = 32 -2 = 30
Topic 1, 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.

NEW QUESTION 53
Connect to the "Flight" data source and create a hierarchy as City-Airport Name-Carrier Name. Find out which combination was having the lowest number of on-time flights?

A. Orlando-Orlando International-SkyWest
B. Salt Lake City-Salt Lake City International-Mesa
C. Phoenix-Phoenix Sky Harbor International-Pinnacle
D. Boston-Logan International-SkyWest

Answer: C

Explanation:
Explanation
Create a hierarchy using City-Airport Name-Carrier Name.
Filter using Ontime Category field and select the Ontime.
Drop the hierarchy to the view and Number of flights to the Text.
Check each combination from the answers:

NEW QUESTION 54
Connect to the "Education" data source. Create a histogram using the Total score field and having a bin size of
100. Find out in which bin the students scored the highest verbal percentage? [Note: Verbal percentage should be calculated by considering how many marks scored in the verbal out of the total marks scored.]

A. 0
B. 1
C. 2
D. 3

Answer: B

Explanation:
Explanation
Create a calculated field to compute the contribution of verbal marks in percentage:

Select the Total Score field and using Show me create a histogram.
Edit the Total Score(bin) and provide the Size of bins as 100:

Drop the % Verbal field to the Label, your view will look like this:
Chart, histogram Description automatically generated

NEW QUESTION 55
To create this view, what all you have to do from the following options?
Larger image

A. Go to the border in format menu and then go to the Columns tab and update the Column Divider settings
B. Go to the border in format menu and then go to the Rows tab and update the Row Divider settings
C. Drop the measure to the color marks card
D. Add the Columns Totals on Top from Analysis Menu

Answer: B,C

Explanation:
Option 1 - It is not valid, as we are not showing Columns Totals on Top.
Option 3 - It is not valid, as we are modifying the row divider settings and not the column divider settings.
Rest are true.

NEW QUESTION 56
Connect to the "Global Superstore" data source and use the Orders table. Find out how many days in the 4th quarter of 2015 had a profit ratio greater than 25%?

A. 0
B. 1
C. 2
D. 3

Answer: D

Explanation:
Explanation
Calculate the Profit Ratio:

Create a LOD expression -> for each order date if profit ratio is greater than 25% returns 1.

Drop the Order date to Rows and drill-down it to Quarters.
Drop the profit ratio >.25 field to Text:

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

A. MAPE
B. MASE
C. RMSE
D. AISE

Answer: A,B,C

Explanation:
Explanation
Refer section "Quality Metrics" athttps://help.tableau.com/current/pro/desktop/enus/ forecast_describe.htm

NEW QUESTION 58
How to add reference lines in a view? (Select correct two answers)

A. Using Analytics pane
B. Right Click on Axis and Add Reference Line
C. Using Data Pane
D. Using Analysis Menu

Answer: A,B

Explanation:
Using Analytics pane:
Graphical user interface, application Description automatically generated

Right Click on Axis and Add Reference Line:
Graphical user interface, application Description automatically generated

NEW QUESTION 59
Connect to the "Global Superstore" data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?

A. $483,269
B. $2,263,137
C. $414,302
D. $2,385,198

Answer: A

Explanation:
Find the minimum order date for each customer
Graphical user interface, text, website Description automatically generated

Drop the order date, Min Order date, and Sales to the view
A picture containing graphical user interface Description automatically generated

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.

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

A. 26.72
B. 26.41
C. 26.02
D. 26.33
(Correct)

Answer: D

Explanation:
Drop the Age to the columns and change the aggregation to AVG.
Drop Gold Medals field to filter and select All values ->
Graphical user interface, text, application, email Description automatically generated

Change 1 from 0.
Graphical user interface, application Description automatically generated

NEW QUESTION 61
Blend the Significant Volcano Eruption dataset with the Country population dataset using year and country.
Find out which country is having 4 volcano eruptions in the year 1963 and what was the population of this country in the same year?

A. Indonesia and 95,055,669
B. Indonesia and 9,103,406,453
C. Japan and 9,103,406,453
D. Japan and 96,812,000

Answer: A

Explanation:
Add the Country population excel sheet as a New Data Source.
Select column 1960 to 2013, click on Pivot.
Graphical user interface, application Description automatically generated

Rename the new fields as Year and population.
Go to Data ->Edit Blend Relationship
Click on Custom and Add
Graphical user interface, text, application Description automatically generated

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.
Graphical user interface Description automatically generated

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:
Graphical user interface, text, application, chat or text message Description automatically generated

NEW QUESTION 62
Connect to the "Global Superstore" data source and use the Orders table. Find out the group of states(in the US) having the highest sales in 2013?

A. Texas, New Mexico, Colorado
B. California, Idaho, Nevada
C. North Carolina, South Carolina, Virginia
D. New York, Massachusetts, Rhode Island

Answer: B

Explanation:
Drop the State field to a view, you will get >1k unknown.
Drop the Country to the Filters Shelf and Select the United States, all unknowns should be gone.
Also, drop the Order Date to the Filters Shelf and choose Years as:
Graphical user interface, application Description automatically generated

Check for the Year 2013.
Drop the Sales field to the Label in the Marks card, your view should look like this:
Graphical user interface Description automatically generated with medium confidence

Now use the Lasso Selection tool from the Map tools:
Graphical user interface, diagram Description automatically generated

And create the group of states as per our answer options.
Example - for New York, Massachusetts, Rhode Island, Similarly, do for other 3 options as well.
Map Description automatically generated

Duplicate this worksheet and remove the Latitude and Longitude from the view and drop this new dimension of groups to the view. California, Idaho, Nevada is the right answer.
Graphical user interface, text, application Description automatically generated

NEW QUESTION 63
In which of the following scenarios you should use the blend?

A. The data to combine is at a different level of detail.
B. The combined data will be used in many worksheets in the current workbook.
C. All of the above.
D. The data to combine has the same structure but consists of data of different years.

Answer: A

Explanation:
Union - The data to combine has the same structure but consists of data of different years.
Blend - The data to combine is at a different level of detail.

NEW QUESTION 64
You need to create a filled map using the City field, you drop the City field to your view. And you get the location error 'Ambigious', what does it mean, and how you will fix this issue?
Larger image

A. The city name must be misspelled. Correct the spelling to fix the issue.
B. More than one city has that name. Update the data type of the field to fix this issue.
C. More than one city has that name. Adjust the geographic roles to fix this issue.
D. Click on the Reset matches button to fix this issue.

Answer: C

Explanation:
Click on the State/Province list, and select the State. So Tableau will recognize the city as part of the states in the Country/Region United States.

NEW QUESTION 65
Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all the categories in 2015 by customers who have purchased any product in the Phones sub-category in
2014? Use Customer ID.

A. 5.03%
B. 3.45%
C. 4.53%
D. 4.90%

Answer: B

Explanation:
Explanation
Approach 1 - Using Groups
Drop the Customer ID to the Rows.
Add sub-category to the filter and select phone.
Add Order date to the filter and select the year 2014.

Select all the customers and click on paper clip icon to create the group.
So here we got all the customers who have purchased any product in the Phones subcategory in 2014.
Edit the group and select Include other

Clear the filter shelf, and again add Order date to the filter and select 2015.
Drop Sales to the Text.
Add 'Percent of Total' Quick Table Calculation to the Sales field.
Your view will look like this:

Approach 2 - Using LOD
Create a LOD expressions as:

It will return 1 for the customers who have purchased any product in the Phones sub-category in 2014. For others, it will return 0.
Drop this field to the Rows and add Order date to the filter and select the year 2015.