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 2 out of 4 pages

Viewing questions 11-20 out of questions

Questions # 11:

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

Options:

Answer

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:

Questions # 12:

To create a choropleth map, your data source should include the following types of information?

Options:

Quantitative or qualitative values

Location names or custom polygons

Background image

Custom Territories

Answer

A, B

Explanation

Explanation:

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

Questions # 13:

In LOD calculation, we can use fields from multiple data sources (blended data source)?

Options:

True

False

Answer

Explanation

Explanation:

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

Here, the Location is in a primary data source, and the population field is in a secondary data source.

So the answer is FALSE.

Questions # 14:

To create this view, what all you have to do from the following options?

Larger image

Question # 14

Options:

Add the Columns Totals on Top from Analysis Menu

Go to the border in format menu and then go to the Rows tab and update the Row Divider settings

Go to the border in format menu and then go to the Columns tab and update the Column Divider settings

Drop the measure to the color marks card

Answer

B, D

Explanation

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.

Questions # 15:

Connect to the "Global Superstore" data source and find out which 'Customer Name' (ignore the customer ID) has returned the highest percentage of his\her orders?

Options:

Michael Oakman

Daniel Lacy

Greg Tran

Yoseph Carroll

Answer

Explanation

Explanation:

Left join the Orders and Returns table

Diagram Description automatically generated

Number of orders returned will be order ID from the returns table divide by total orders

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

Drop the customer name and ret order field in the view.

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

Questions # 16:

Extract can't be created in which of the scenario?

Options:

When you perform cross-database joins

When you perform the blend

When you perform the union

When you perform the traditional join

Answer

Explanation

Explanation:

A blend is worksheet-specific, so you cannot create the extract while creating a blend.

Questions # 17:

Connect to the Olympic Athletes data source, which athlete won at least one gold in 2008 Olympics and then won at least 4 golds in 2012 Olympics.

Options:

Missy Franklin

Usain Bolt

Dana Vollmer

Michael Phelps

Answer

Explanation

Explanation:

Find out how many gold medals each athlete won in the 2008 Olympics

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

Drop Athlete to Rows and 2008 golds to the Text. Drop gold medals to the view. Your view will look like this:

Graphical user interface, text, application Description automatically generated

Now we need work on "won at least 4 golds in 2012 Olympics"

Drop years to filters and select 2012.

Drop Gold Medals to filter and mention 4 in range of values (as we need to find athletes who won at least 4 gold medals)

Graphical user interface Description automatically generated

Final view:

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

Questions # 18:

How to create custom territories on a map?

Options:

Create a territory from a geographic field

By using a background image on a map

Select and group locations on a map

Geocode a territory field using another geographic field

Answer

A, C, D

Explanation

Explanation:

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

Questions # 19:

Connect to the "Covid data" source. What is the percentage increase in the new cases from July 2020 to Jan 2021?

Options:

118.50%

125%

113.50%

98%

Answer

Explanation

Explanation:

Create a filter on date field and select only July 2020 and Jan 2021.

Graphical user interface, application Description automatically generated

Drop Date Month Discrete to Columns and New cases to the Text.

Right-Click on New Cases field and Quick Table Calc ->Percent Difference

Graphical user interface, application Description automatically generated

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

Questions # 20:

Using the Profit Analysis Dashboard twbx file, find out the profit recorded in October 2016 by California State in the West region? You can add the functionality to the dashboard.