Tableau Desktop Specialist Exam Preparation Material

dumps2022-01-24T03:40:36+08:00

Tableau Desktop Specialist exam preparation material is good and helpful for you to take the test. We all know that there are 45 questions (40 scored, 5 unscored) in real Desktop Specialist exam, and you have 60 minutes to take the test. The required passing score of Tableau Desktop Specialist exam is 750. The test languages are English, Japanese, and so on. Free Tableau Desktop Specialist exam is below.

Page 1 of 5

1. For Bullet Graphs we need at least ____________ measures

2. True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

True

False

3. Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK).

For the University of Manchester, what percent of the total publications were contributed in 2014?

28.415%

23.497%

25.683%

22.404%

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

5. True or False:

The Highlighting action can be disabled for the entire workbook.

True

False

6. True or False: Tableau can create worksheet-specific filters

True

False

7. Which of the following chart type makes use of 'binned' data?

Gantt Chart

Bullet chart

Histogram

Treemaps

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

9. Which data type in Tableau does this icon represent?

Larger image

String

True or False

Boolean

Geographic

10. Dates in Tableau are typically treated as ______________

Dimensions

Measures

Page 2 of 5

11. Larger image

What is this entire view referred to as in Tableau?

Data pane

Analytics Pane

Summary Pane

Distribution Pane

12. True or False: Bins can be created on dimensions

False

rue

13. ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

.tbm

.tds

.tde

.twb

14. When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Discrete

Fading

Continuous

Mixed

15. How do you identify a continuous field in Tableau?

It is identified by a blue pill in the visualization

It is identified by a green pill in a visualization

It is preceded by a '=#' symbol in the data window

It is preceded by a 'Abc' symbol in the data window

16. The View Data window displays as much of the data as possible by default, up to _______________ rows.

20,000

5,000

10,000

15,000

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

Tableau Reader

Tableau Desktop

Tableau Server

Tableau Public

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

19. What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

No difference, calculated fields cannot be created in Blends

Fields used in Blends must first be aggregated

The calculated fields created in Blends cannot be edited once created

The calculated fields created in Blends cannot use more than 2 fields

20. When using Animations in a Tableau, which of the following is the default duration for animations?

0.4s

0.3s

0.5s

0.2s

Page 3 of 5

21. By definition, Tableau displays measures over time as a ____________

Packed Bubble

Bar

Stacked Bar

Line

22. When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

Regex Search

Union Search

Pattern Search

Wildcard Search

23. In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

top left bottom left

top right, bottom right

top left, bottom right

top right, bottom left

24. Which of the following are the options to export the data used to build the view / visualisations?

CSV file

PDF File

JSON format

MS Access Database

25. A field that shows average home values for the United States in 2016 is most likely :

A discrete date part dimension

A continuous date value dimension

A geographical dimension

An aggregated measure

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

Data cleaner

Data manager

Data interpreter

Data organiser

27. Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view.

Which Item Number ID made the maximum sales across all assortments?

584

901

Correct)

205

660

28. Which of the following can you add a reference line to?

Groups

Calculated Fields

Measures

Dimensions

29. Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan.

What was the average Quantity in the State of Tokyo?

3.000

3.840

3.704

3.500

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

SUM([GDP]/[POPULATION])

SUM([Population]/[GDP]])

SUM([GDP]*[POPULATION])

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

Page 4 of 5

31. How can you format numbers in Tableau as currency?

Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.

32. What does the following icon do in Tableau?

Larger image

Create a Story

Create a Story and Dashboard both

Create a Worksheet

Create a Dashboard

33. Suppose you have a bar chart. When we group by labels in a view, which of the following happens?

Nothing changes in the view, but a group is created in the Dimensions shelf.

The colours of the members selected are now the same, and different for the rest of the members.

Trick question! It is not possible to group by labels.

A new mark (bar) is created, which consolidates all members of the group.

34. True or False: It is possible to change the Geographic Role of a dimension

True

False

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

36. _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

Tableau Packaged Workbook (.twbx)

Tableau Workbook (.twb)

Tableau Data Extract (.tde)

Tableau Data Source (.tds)

37. Are animations enabled by default in Tableau?

Yes

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

39. According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

Dimension Filter

Measure Filter

Context Filter

Extract Filter

40. True or False: A reference line cannot be added from the Analytics Pane

True

False

Page 5 of 5

41. What does the box in a box plot represent?

Maximum value of the data

Minimum value of the data

The interquartile range

The median of the middle half of the data points

42. How can you change the default Tableau repository location?

By clicking on Window -> Repository Location

By clicking on Help -> Change Repository Location

By clicking on File -> Repository Location and choosing a new location

By Moving the repository location manually to wherever we want

43. Which of the following are benefits of using Data Extracts in Tableau?

Improved Performance

Ability to use the data offline

Working with freshest data at all times

Faster to work with

44. When exporting a worksheet as an image in Tableau, which of the following file formats are available?

Portable Network Graphic (.PNG)

JPEG Image (.JPG, .JPEG)

Tagged Image File Format (TIFF)

Windows Bitmap (.BMP)

45. To use a quick table calculation, which of the following programming languages do you need to know?

ython

Java

Javascript

None of these

46. Which of the following is a benefit of using a Tableau Data Source (.tds)?

To hold one or more worksheets, plus zero or more dashboards and stories.

To not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields etc

To create a single zip file that contains a workbook along with any supporting local file data and background images. This is great for sharing your work with others who don’t have access to the original data.

To create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

47. For a relative date filter, the default anchor is _________________

The current time

Today's date

The target date

The date we specify

Tableau Desktop Specialist Exam Preparation Material

Tableau Desktop Specialist Exam Preparation Material

Share this post

Leave a Reply Cancel reply

Related Posts

2022 Updated Tableau TDS-C01 Exam Actual Questions

TDA-C01 Tableau Certified Data Analyst Exam Dumps

Great Dumps for Tableau Server Certified Associate SCA-C01 Exam

TDS-C01 Tableau Desktop Specialist Dumps Questions