2023 Tableau Desktop Certified Associate Exam Dumps Questions

Tableau certification is a highly valuable and sought-after certification for IT professionals seeking to enhance their knowledge and expertise. Desktop Certified Associate exam is specifically designed to validate the skills required to configure and maintain the Tableau Desktop Certified Associate platform, which is widely used by businesses around the world. These Desktop Certified Associate exam dumps questions are specifically designed to help you prepare for the exam by testing your knowledge and providing you with valuable insights into the types of questions that you will encounter. Test free Tableau Desktop Certified Associate exam questions below.

Page 1 of 4

1. We can create variable size bins using ___________?

Groups

Calculated Fields

Sets

Hierarchies

 Loading...

2. Connect to the "Global Superstore" data source and use the Orders table. Create a view showing sales over continuous months, find out which trend line model type provides the lowest R-squared value?

Linear

Exponential

Polynomial, Degree 2

Polynomial, Degree 3

 Loading...

3. Which type of sort is applied in the Ship Mode field?

Larger image

Field Sort

Nested Sort

Alphabetic Sort

Data Source Order

 Loading...

4. Using the Regional Dashboard twbx file, consider the Obesity dashboard to find out how many counties in North Carolina are having an obesity rate that is 8% below the regional obesity rate?

3

4

5

6

 Loading...

5. Tableau automatically associates continuous fields with categorical palettes.

True

False

 Loading...

6. __________ function rounds a number to the nearest integer of equal or lesser value.

FLOOR

ROUND

CEILING

BUFFER

 Loading...

7. Use custom geocoding, when you need ___________ locations to map your data.

Default

States

User-defined

Tableau generated

 Loading...

8. Connect to the "Global Superstore" data source and use the Orders table. Find out how many new customers were acquired in the year 2014?

4419

5412

4719

5216

 Loading...

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

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.

 Loading...

10. Which LOD calculations can be used in Columns shelf to create this view? Larger image

{ FIXED [Category] : SUM([Profit])}

{ FIXED [Region] : SUM([Profit])}

{FIXED : SUM([Profit])}

{SUM([Profit])}

 Loading...

Page 2 of 4

11. Connect to the Olympic Athletes data source, find out how many countries participated in 5 different sports from 2000 to 2012?

7

8

9

10

 Loading...

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

0

1000

2000

3000

 Loading...

13. Connect to the "Global Superstore" data source and use the Orders table. Create a hierarchy of Segment, Category, Region. Create a crosstab using this hierarchy and add profit, profit ratio fields.

Which of the following are true from the below options?

The overall lowest profit ratio is of Central Asia region in Furniture Category and Corporate segment (among all the segments)

The Southern US is having the third-lowest profit ratio in Technology Category in Home Office Segment and it is having a profit value of $765

The Central Africa region is having a profit value of $10,709 in the Office Supplies category in the Corporate Segment

The overall highest profit ratio is of North Africa region in Technology Category and Corporate segment (among all the segments)

 Loading...

14. Connect to the "Education" data source.

Which college(s) average math, verbal, and writing scores are lesser than the overall 70% percentile in these subjects?

Business

Communication

Education

Public Affairs

 Loading...

15. Using the Regional Dashboard twbx file, find out the percentage of average obesity increases when 1% average increase in the physical inactivity in the New York state of the Northeast region?

0.47%

0.63%

0.57%

0.40%

 Loading...

16. Connect to the "Global Superstore" data source and use the Orders table. Find out the percentage of total sales in all categories by customers who have purchased any product which contains the word 'Avery'?

14.52%

16.86%

23.41%

19.65%

 Loading...

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

 Loading...

18. Connect to the "Significant Volcano Eruption" data source. In 1899, the Dona Juana volcano erupted in Colombia. Find out which volcano in the Popayan city is the closest to Dona Juana and how many death Dona Juana volcano caused?

Purace, 55

Galeras, 55

Purace, 0

Galeras, 0

 Loading...

19. Using the metadata grid, you can rename the remote fields.

TRUE

FALSE

 Loading...

20. Connect to the "Kiva Loans - India" data source, create a chart using the continuous disbursed month (Disbursed Time field) and sum of the loan amount, exclude the null values.

What is the skewness of this chart?

.42

.51

.48

.55

 Loading...

Page 3 of 4

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

6

8

10

12

 Loading...

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

 Loading...

23. Connect to the "Global Superstore" data source and use the Orders table. Find out the average quantity ordered by customers whose first name starts with an 'S' alphabet?

3.43

3.56

4.02

3.39

 Loading...

24. You have connected to the employee table in your data source and are adding a join on the Employee Manager table. If you would like to see all of the records from the employee table and only matching records from the employee manager table.

Which join type will you use?

Inner join

Outer join

Left join

Right join

 Loading...

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

 Loading...

26. Which of the following are the valid dashboard actions in Tableau?

URL action

Filter action

Hover action

Select action

 Loading...

27. Using the Profit Analysis Dashboard twbx file, find out the 5th most profitable product in the state of New York? You can add the functionality to the dashboard.

GBC DocuBind TL300 Electric Binding System

Canon imageCLASS 2200 Advanced Copier

Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind

HP Designjet T520 Inkjet Large Format Printer - 24" Color

 Loading...

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

 Loading...

29. Which of the following map layers are available in Tableau?

Points of Interest

Area Code Labels

Neighborhoods

Cities Borders

 Loading...

30. Connect to the "Global Superstore" data source and use the Orders table. Find out how many days in the month of May 2012 were profitable?

16

18

20

22

 Loading...

Page 4 of 4

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

 Loading...

32. In your view, you are using a background image.

How can you find the X and Y coordinates on your image?

Using custom geocoding

By annotate a point

By annotate an area

Using drop lines

 Loading...

33. Connect to the "WorldBank Data" and use the Development Indicators table. Create a relationship between the avg. birth rate and avg. death rate using scatterplot aggregated at the region level, plot death rate on Y-axis and birth rate on X-axis. Add an exponential trendline and find out how many regions are above the trend line?

3

4

5

6

 Loading...

34. Connect to the "Global Superstore" data source and find out which region was having the highest percentage of returned orders in 2013?

Western US

Southern Africa

Eastern Asia

North Africa

 Loading...

 Loading...