Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Tableau
Tableau Desktop Certified Associate
Desktop-Certified-Associate
Tableau Desktop Certified Associate Questions and Answers

Pass the Tableau Desktop Certified Associate Desktop-Certified-Associate Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Desktop-Certified-Associate Premium Access

View all detail and faqs for the Desktop-Certified-Associate exam

Go to Exam

746 Students Passed

90% Average Score

96% Same Questions

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

Questions # 21:

Connect to the "Global Superstore" data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?

Options:

2012

2013

2014

2015

Answer

Explanation

Explanation:

Drop Order Date to columns, Category to Rows, and Sales to Text.

Go to Analysis -> Totals -> Show Columns Grand Total

Graphical user interface, text, application Description automatically generated

Update Total All Using to Average:

Graphical user interface, text, application Description automatically generated

Table Description automatically generated

In the year 2012, the furniture sales were more than the average sales of that year.

Questions # 22:

In which of the following scenarios you should use the blend?

Options:

The data to combine has the same structure but consists of data of different years.

The combined data will be used in many worksheets in the current workbook.

The data to combine is at a different level of detail.

All of the above.

Answer

Explanation

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.

Questions # 23:

Which of the following are valid calculations?

Options:

MAX(SUM(Profit), (Sales))

SUM([Profit]) * SUM([Quantity])

SUM([Profit]) * 1000

SUM([Profit]) * [Quantity]

Answer

B, C

Explanation

Explanation:

You cannot mix the aggregated and non-aggregated calculations.

MAX(SUM(Profit), (Sales)) -> Profit is aggregated but Sales is not.

SUM([Profit]) * [Quantity] -> Profit is aggregated but Quantity is not.

You can multiply the aggregated/non-aggregated fields with constant. That's why SUM([Profit]) * 1000, is correct.

SUM([Profit]) * SUM([Quantity]) - Both are aggregated

Questions # 24:

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

Options:

You can turn on the highlighter for any field available in your view.

Table Description automatically generated

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 want to change the format for the highlighter card after you turn it on, select Format > Highlighter.

Answer

B, C, D

Explanation

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

Questions # 25:

Connect to the "Kiva Loans - India" data source, which sector's funded amount is closest to the median of all the sectors?

Options:

Education

Clothing

Construction

Retail

Answer

Explanation

Explanation:

Drop Sector to columns and Funded Amount to Rows.

From Analytics, drop the Median with Quartiles to your view or drop the reference line, select the Median.

Your view will look like this:

Chart, bar chart Description automatically generated

Here, the Clothing funded amount is exactly similar to the Median.

Questions # 26:

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

Question # 26

Options:

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

Answer

Explanation

Explanation:

Go to Filter card options, and Select Only Relevant values

Graphical user interface, text, application Description automatically generated

Questions # 27:

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

Question # 27

Options:

The city name must be misspelled. Correct the spelling to fix the issue.

More than one city has that name. Update the data type of the field to fix this issue.

More than one city has that name. Adjust the geographic roles to fix this issue.

Click on the Reset matches button to fix this issue.

Answer

Explanation

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.

Questions # 28:

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

Options:

Measure Names

Measure Values

Number of records

None of the above

Answer

Explanation

Explanation:

By using the Measure Name field, we get multiple measures on a single axis

Chart, bar chart Description automatically generated

Questions # 29:

Connect to the "Global Superstore" data source and use the Orders table. What is the total profit earned by all the cities in Wake County, North Carolina from the year 2012 to 2014?

Options:

$527

$403

$427

$503

Answer

Explanation

Explanation:

Drop the State to the View. And drop the Country to the Filter Shelf and Select the United States.

Drop the City to the view, and add the State to the Filter shelf and select North Carolina.

Also, drop the Order Date to the Filters and select year 2012, 2013, 2014

Graphical user interface, text, application, email Description automatically generated

Now, drop the Profit field to the tooltip. As of now, your view should look like this:

A picture containing map Description automatically generated

Now, we have to find the total profit earned by all the cities in Wake County.

Drop the City field to the view and drop the state to the Filters shelf and Select North Carolina only.

Graphical user interface, text, application, chat or text message Description automatically generated

To show the County go to the Map->Map Layers.

Check County Names and County Borders.

Graphical user interface, text, application Description automatically generated

the total profit earned by all the cities in Wake County is $403.

A picture containing map Description automatically generated

Questions # 30:

Connect to the "Kiva Loans - India" data source, find out the average number of days it took to disbursed the funded amount in catering activity, and what is the total funded amount?