[May-2022 Newly Released] Desktop-Certified-Associate Dumps for Tableau Desktop Certified Associate Certified [Q45-Q61]

May 11, 2022 admin 0 Comments

5/5 - (1 vote)

[May-2022 Newly Released] Desktop-Certified-Associate Dumps for Tableau Desktop Certified Associate Certified

Updated Verified Desktop-Certified-Associate dumps Q&As – 100% Pass

What is the Salary of Tableau Desktop Certified Associate Certified Professional

India : 5021013 Rupees
United States: 67,000 USD
UK: 48850 Pounds

NO.45 Connect to the “Significant Volcano Eruption” data source. Create a histogram using field Death and having a bin size of 500. Find out which country reported 9 deaths in the bin of 0-500?

United States

Chile

Japan

Indonesia

Explanation
Select the measure “Death” and go to the Show Me and Click on Histogram When we are binning the measure, it will create the dimension, so you get a new dimension as Death (bin).
Right-click on this and click on Edit. Update the size of bins to 500.
Graphical user interface, application Description automatically generated

Drop the Country to the color, so our view will look like this:
Chart Description automatically generated

Now drop the Country to the filter and select 4 countries mentioned in our options.
Hover the bar, it shows the United States has reported 9 deaths.
Chart Description automatically generated

NO.46 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.41

26.72

26.02

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

NO.47 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?

1000

2000

3000

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

Drop the Total Death to Label.
Chart, histogram Description automatically generated

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.

NO.48 In Forecast, what is the shaded region?

forecast model

exponential smoothing

prediction interval

none of these

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

NO.49 Connect to the “Global Superstore” data source and use the Orders table. Find out how many products from the Office Supplies category are in the Top 10 most profitable product list?

Explanation
First, create a set using the Product Name. Select the Top condition as:
Drop this Set to the filters shelf and select IN only.

Drop this Set to the filters shelf and select IN only.

Drop the Category, Top 10 profitable products and Product Name to the view:

NO.50 Which of the following are true regarding custom geocoding and data blending?

Using custom geocoding, you can plot your own locations on a map but it is not true while using data blending

In data blending, you can use any data but custom geocoding requires text file based data

Using custom geocoding, you can create new geographic hierarchies but it is not true while using data blending

You can create new geographic roles both in data blending and custom geocoding

Refer to the quick comparison of data blending and custom geocoding –
https://help.tableau.com/current/pro/desktop/en-us/maps_customgeocode_datablend.htm

NO.51 Connect to the “Flight” data source and find out which carrier was having the highest percentage of delayed flights in 2013?

JetBlue

Frontier

ExpressJet

American

Explanation
Create the calculated field:

Drop the carrier name to the view and % of delayed flights to text.
We only have 2013 data, so filter won’t make a difference:

NO.52 Connect to the “Significant Volcano Eruption” data source. How many volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year?

Add year and location filter as:
Graphical user interface, application Description automatically generated

Graphical user interface, text, application Description automatically generated

Drop Name, year, month to the rows. Change year and month to discrete from continuous.
A picture containing chart Description automatically generated

So, 3 volcano eruptions took place in Luzon island of the Philippines in the 21st century in the first six months of each year.
You can also use the map view to get the results, here I added the month filter as well and drop the count of records to the text.
Map Description automatically generated

NO.53 Which of these chart types are primarily used to compare measures against goals?

Bar-in-Bar Chart

Histogram

Bullet graphs

Pareto chart

Explanation
Bar-in-Bar Chart and bullet graphs both are used to compare the measures against goals.

NO.54 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.67

-0.69

-0.58

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

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

NO.55 In a combined axis chart, using which field we get multiple measures on a single axis?

Measure Names

Measure Values

Number of records

None of the above

By using the Measure Name field, we get multiple measures on a single axis Chart, bar chart Description automatically generated

NO.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%?

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:

NO.57 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?

6.58%

0.27%

3.45%

5.61%

Create a calculated field as:
Graphical user interface, text, application Description automatically generated

Drop this field to Rows and Total Death to the Columns. And Select the Quick Table Calculation-> Percent of Total.
Graphical user interface, application Description automatically generated

Graphical user interface, application, table, Word Description automatically generated

NO.58 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?

Go to Dashboard->Actions and create the go to URL action

Go to Dashboard->Actions and create the go to sheet action

Go to Dashboard->Actions and create the Highlight action

Right-click on the view, go to format, and provide the URL.

Go to Dashboard->Actions and create the go to sheet action
Graphical user interface, application Description automatically generated

NO.59 When it is recommended to create multiple table extracts?

If incremental refresh is configured

If we are using extract filters to limit the data

If row-level security needs to be enforced

None of the above

It is recommended to create multiple table extracts when row-level security needs to be enforced.
Refer:
https://www.tableau.com/about/blog/2018/10/you-can-now-choose-multiple-table-storage-extracts-94776

NO.60 I have a view that shows the top 5 countries as per the sales, I also have a region filter, but most of the region filter values we don’t need. For example – We don’t have any country which is part of the Eastern Europe region. So we want to hide all those regions which are not valid here. How to do it?
Larger image

You will select Exclude Values in a filter card options

You will select Only Relevant Values in a filter card options

You will select Format filter and Set Control in a filter card options

You will select Wild card match in a filter card options

Go to Filter card options, and Select Only Relevant values
Graphical user interface, text, application Description automatically generated

NO.61 Connect to the “Global Superstore” data source and use the Orders table. Create a filter on a product name to find out the top 10 profitable products. Create a crosstab to show these products along with profit value. Now filter this chart to show only the products from the European market. What is the 10th most profitable product?

Belkin Router, USB

Cisco Smart Phone, Full Size

Nokia Smart Phone, with Caller ID

Bush Classic Bookcase, Pine

Explanation
Drop the Product Name to the filters and Select Top 10 based on Sum of Profit.

Drop the Product Name to the Rows and Profit to the Text.
Drop the Market to the filter and select the Europe.
Your view will look like this:

Here, you are getting only 9 products.
Add Market filter to the context so that the Product Name dimension filter will be executed after the Market filter.