Pass Tableau Desktop Specialist Exam With Real Questions and Answers

test2022-03-05T03:43:56+00:00

Tableau Desktop Specialist Certification is the most foundational one which tests the basic product knowledge about Tableau Desktop.To pass the exam, you need to score at least 750 marks out of 1000 from the 40 scored multiple-choice questions. FreeTestShare offers this Desktop Specialist practice exam with real exam questions and answers to help you know the exam topics and layout. it includes real Desktop Specialist questions and answers, which have been corrected and updated to ensure that they are true and valid.

You can practice the actual exam questions online.

Page 1 of 4

1. How does Tableau know at which level to aggregate values?

Values are always aggregated at the level of granularity of the worksheet.

Tableau doesn't aggregate values, we do!

Values are always aggregated at the level of the Date Part

Aggregation is always done by using Tableau special formulas

2. Which one of the following is a dimension?

Longitude

Measure Names

Number of records

Latitude

3. How would you calculate GDP per capita in Tableau?

SUM([GDP]/[POPULATION])

SUM([Population]/[GDP]])

SUM([GDP]*[POPULATION])

SUM([GDP]) / SUM([Population])

4. True or False: It is possible to add a field to more than one hierarchy

True

False

5. Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

$16,581

(Correct)

$147,950

$48,115

$33,768

6. Which of the following is a good reason for using a bullet graph?

Comparing the actual sales against the target sales

Analysing the trend over a given time period

Forecasting future sales

Displaying the year-on-year growth in sales

7. Is it possible to make a Measure discrete?

Yes

8. You want to add Custom shapes to your visualisation. Where can you add these new shapes?

In Downloads -> My Tableau Repository -> Shapes

In My Computer -> C: -> Tableau -> Shapes

In Program Files -> Tableau -> Shapes

In My Documents -> My Tableau Repository -> Shapes

9. Which of the following returns the Absolute Value of a given number?

ABS(Number)

CEILING(Number)

FLOOR(Number)

ZN(Number)

10. For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Random

Manual

Topological

Hierarchical

Page 2 of 4

11. What will the following function return?

LEFT("Tableau", 3)

An error

Tab

eau

ble

12. Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013.

How many months saw a Negative percent difference in Profit?

13. ________________ can only create header. _______________ will create header and axis both.

Dimensions, Measures

Measures, Dimensions

Groups, Sets

Dates, Strings

14. Which of the following would you use to connect to multiple tables in a single data source at once?

A Blend

A Hierarchy

A Set

A Join

15. ________________ is hosted by Tableau to share our visualisations publically with the world.

Tableau Reader

Tableau Desktop

Tableau Server

Tableau Public

16. You can use the __________________ in Tableau to clean / organise your data.

Data cleaner

Data manager

Data interpreter

Data organiser

17. Create a Set containing Customer Names whose Sales are GREATER than 30,000.

Which customer had the LEAST sales in this set?

Tom Ashbrook

Sanjit Engle

Penelope Sewall

Tamara Chand

18. _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

Tableau Data Extract (.tde)

Tableau Packaged Workbook (.twbx)

Tableau Bookmark (.tbm)

Tableau Workbook (.twb)

19. The row and column shelves contain ___________________

Pills

Grand Totals

Filters

Parameters

20. Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sh aring

Using the Time Series Table, create a line chart to show Sales over time.

Which Month and Year witnessed the lowest Sales?

September 2017

March 2018

December 2017

January 2018

Page 3 of 4

21. You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases.

Which of the following would BEST satisfy this requirement?

Save it as a .twm file

Save it as a .twb file

Save it as a .tds file

Save it as a .twbx file

22. The calculation [Ship Date] - [Order Date] will return _______________

Number of orders placed in that duration

Number of days between these dates

Number of unique orders placed between these dates

Number of orders shipped between these dates

23. True or False:

The Highlighting action can be disabled for the entire workbook.

True

False

24. Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map.

What was the Store count in 2017 for Texas (TX)?

Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map.

What was the Store count in 2017 for Texas (TX)?

592,593

293,202

416,702

336,908

25. If you have a dashboard and are displaying its filter, how can you rearrange it?

By clicking on the 2 lines on top and dragging the filter.

By clicking on the dropdown and dragging the filter

By clicking on the filter title and dragging it.

By clicking anywhere inside the filter and dragging it.

26. Which of the following 2 columns CANNOT be deleted in Tableau?

Measure Names

Number of Records

Measure Values

Calculated Fields

27. To connect Tableau to a CSV data source what type of connection should you use?

Spatial

Excel

Text

JSON

28. Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.

How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

29. Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Profit, State, Number of Records, Sales

Region, Country, Profit, State

Longitude, Country, State, Sales

Sales, State, Country, Profit

30. A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data.

.twbx file

.tbm file

.twb file

.tde file

Page 4 of 4

31. True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

True

False

32. Broadly speaking, after an importing a dataset in Tableau Desktop, all fields in it are broken down into _______________________

Dimensions and Measures

Rows and Columns

Labels and Values

Numbers and Headers

33. DOWNLOAD THE DATASET FROM: https://drive.google.com/drive/folders/1WXzqsrNmXVdmQ574wld4InEplyKT8RP?usp=sharing (if you haven't already)

Using the cwurData table, plot a Map to see which country had the Second highest number of patents in the Year 2013?

United States

France

United Kingdom

Canada

34. True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

rue

False

35. Which of the following is not a Trend Line Model?

Linear Trend Line

Exponential Trend Line

binomial Trend Line

Logarithmic Trend Line

36. Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?

YES, we can do this with the help of a plugin

NO, this is not currently possible in Tableau

YES, we can do this with the help of a Web-Page object

YES, we can do this with the help of Tableau Public

37. When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Red, Blue

Orange, Blue

Blue, Red

Blue, Orange