Get Started Desktop-Certified-Associate Exam [year] Dumps Tableau PDF Questions [Q15-Q29]

Desktop-Certified-Associate Tableau

admin • April 22, 2022

Get Started Desktop-Certified-Associate Exam [year] Dumps Tableau PDF Questions [Q15-Q29]

4/5 - (1 vote)

Get Started: Desktop-Certified-Associate Exam [year] Dumps Tableau PDF Questions

Desktop-Certified-Associate Premium Exam Engine pdf Download

NEW QUESTION 15
How can we add Visualization in a tooltip?

Go to the Tooltip on the marks card, and click insert -> sheets

Go to the Worksheet menu, click on Tooltip and click Insert -> sheets

Go to the Format menu, click on Tooltip and click Insert -> sheets

Right Click on the view, Tooltip and add insert -> sheets

Only 1 and 2 options are correct.
For these types of questions, please take the help of the Tableau software during your exam.

NEW QUESTION 16
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

NEW QUESTION 17
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.]

900

1000

1500

1600

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

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:
Map Description automatically generated

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.
A picture containing chart Description automatically generated

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

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

0.180067

0.294316

0.133134

0.167531

NEW QUESTION 20
Connect to the “Global Superstore” data source and use the Orders table. Create a map that shows the number of unique customers in Australia. Find the state of Queensland. Which neighboring state has the minimum number of unique customers?

Northern Territory

South Australia

New South Wales

Australian Capital Territory

Explanation
Drop the country field to the view and also to the filter and select Australia.
Drop the State to the detail marks card.
Create the Unique Customer field to the Label.

Your view will look like this:

Northern Territory has the minimum unique customers – 19.

NEW QUESTION 21
Connect to the “Global Superstore” data source and use the Orders table. Create a box-plots to show the sales distribution for each ship mode. Which of the following ship modes have the same median?

First Class

Same Day

Second Class

Standard Class

Explanation
Drop the Sales to the Rows and disaggregate the values. (Go to Analysis -> uncheck Aggregate measures) From Show Me, Select Box and Whisker plots. And drop the Ship mode to the columns.

Hover on each of the boxes:

Median for the First Class and Same Day ship modes are 84.

NEW QUESTION 22
Connect to the “Global Superstore” data source and use the Orders table. Which of the customer names are in the Top 20 by sales, calculate the profit ratio for these customers and find out who all are in the bottom 5 in profit ratio (within these customers)?

Sean Miller

Raymond Buch

Art Ferguson

Bart Watters

Explanation
Right Click on the Customer Name -> Create -> Set
Graphical user interface, text, application Description automatically generated

Create a calculated field:
Graphical user interface Description automatically generated

Drop the Top 20 by Sales set, Customer Name to Rows.
Drop Sales and Profit Ratio to the view. Format the profit ratio so it will show the percentage.
Graphical user interface, text, application, chat or text message Description automatically generated

Sort the Profit.
Table Description automatically generated

NEW QUESTION 23
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

NEW QUESTION 24
Connect to the “Life Expectancy at birth” data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after
2000 for New Zealand.

78.56

78.286

78.03

78.303

Connect to the “Life Expectancy at birth” excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.
Graphical user interface, application Description automatically generated

Use the data Interpreter, it will correct the data.
Graphical user interface, text, application Description automatically generated

Select the column 1960 to 2000. And Click on the Pivot option
Graphical user interface, text, application Description automatically generated

Rename the two new columns as ‘Years’ and ‘Life Expectancy’
Graphical user interface, application Description automatically generated

Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.
Graphical user interface, text, application, email Description automatically generated

Now, select column 2001 to 2013 and Select Add data to Pivot.
A picture containing graphical user interface Description automatically generated

Select Country and Country Name field, Merge these fields.
Graphical user interface, application Description automatically generated

Rename the merged field as Country.
Let’s create the view.
Drop the country to the Filters and Select New Zealand. Drop the years to the columns and ‘Life Expectancy’ to the Text marks card. Change the aggregation to Avg (it won’t make a difference here).
Right-Click on Life Expectancy -> Quick Table Calc -> Moving Average
Again, right-click on it and edit the table calculation.
Graphical user interface, application Description automatically generated

Update the values as:
Graphical user interface, application, Word Description automatically generated

Result is:
Graphical user interface, application, Word Description automatically generated

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

Boston-Logan International-SkyWest

Orlando-Orlando International-SkyWest

Phoenix-Phoenix Sky Harbor International-Pinnacle

Salt Lake City-Salt Lake City International-Mesa

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 26
What are the types of annotations available in Tableau?

Mark

Point

Circle

Area

Graphical user interface, application, table Description automatically generated

NEW QUESTION 27
Connect to the “WorldBank Data” and use the Development Indicators table. Create a country map of the Europe and Central Asia region. Find out which neighboring country of Romania is having a greater average GDP per capita than Romania?

Ukraine

Serbia

Hungary

Bulgaria

Explanation
Drop the Country field to the view.
Drop the Region to the filters shelf and select Europe & Central Asia.
Drop the GDP per capita to the label and change the aggregation to Avg.

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

None of the above

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 29
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

$33,759

$46,917

$39,921

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

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