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

[May-2022 Newly Released] Desktop-Certified-Associate Dumps für Tableau Desktop Certified Associate Certified [Q45-Q61]

Mai 11, 2022 admin 0 Kommentare

5/5 - (1 Abstimmung)

[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

NR. 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

Erläuterung
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 Beschreibung automatisch generiert

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 Beschreibung automatisch generiert

NR. 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
(Richtig)

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 ->
Grafische Benutzeroberfläche, Text, Anwendung, E-Mail Beschreibung automatisch erstellt

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

NR. 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.

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

forecast model

exponential smoothing

prediction interval

none of these

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

NR. 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?

Erläuterung
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

NR. 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

Erläuterung
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:

NR. 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

Grafische Benutzeroberfläche, Text, Anwendung Automatisch generierte Beschreibung

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

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

Bar-in-Bar Chart

Histogramm

Bullet graphs

Pareto-Diagramm

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

NR. 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

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

Measure Names

Measure Values

Number of records

Keiner der oben genannten Punkte

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

Erläuterung
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:

NR. 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:
Grafische Benutzeroberfläche, Text, Anwendung Automatisch generierte Beschreibung

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

NR. 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

NR. 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

Keiner der oben genannten Punkte

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

NR. 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
Grafische Benutzeroberfläche, Text, Anwendung Automatisch generierte Beschreibung

NR. 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

Erläuterung
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.