Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Tableau Desktop-Specialist Tableau Desktop Specialist Exam Exam Practice Test

Tableau Desktop Specialist Exam Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

Relationships are represented by __________________ and operate at the ____________________.

Options:

A.

noodles, logical layer

B.

noodles, physical layer

C.

Venn diagrams, physical layer

D.

Venn diagrams, logical layer

Question 2

Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Options:

A.

To support additional functionality such as count distinct

B.

Fast to create

C.

Help improve performance

D.

To have access to the freshest possible data at all times

Question 3

You have a dashboard that shows car rental statistics by city, including a field named Car Dropoff City in the view. A URL action in the dashboard uses as the URL target.

When you click Salt Lake City in the view, to where will the URL action direct you?

Options:

A.

https://en.wikipedia.org/wiki/

B.

https://en.wikipedia.org/wiki/

C.

https://en.wikipedia.org/wiki/Salt.LakeXity

D.

https://en.wikipedia.org/wiki/Salt+Lake+City+Car+Dropoff+City

Question 4

A dual axis chart is useful for comparing two measures that___________.

Options:

A.

have different scales

B.

have little in common

C.

are Table Calculations

D.

are aggregated Dimensions

Question 5

Which two analytics options are available for a scatter plot view? Choose two.

Options:

A.

Forecast

B.

Totals IS

C.

Reference lines

D.

Trend lines

Question 6

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 7

Which of the following are stored in a .tds file? Choose 3.

Options:

A.

Data Connection information

B.

Visualizations

C.

Calculated Fields

D.

Data Extracts

E.

Metadata edits

Question 8

What is a story point in Tableau?

Options:

A.

A single worksheet or dashboard

B.

A collection of dashboards

C.

A collection of both worksheets and dashboards

D.

A collection of worksheets

Question 9

Most viewers scan content starting at the _____________ of a page.

Options:

A.

top left

B.

center

C.

bottom left

D.

bottom right

E.

top right

Question 10

You have the following visualization.

Where should you place a field named Region to show multiple distinct lines on the same axis?

Options:

A.

Path on the Marks card

B.

Color on the Marks card

C.

The Columns shelf

D.

The Rows shelf

Question 11

Which of the following are valid ways to trigger actions for a Dashboard?

Options:

A.

Hover

B.

Click

C.

Select

D.

Menu

E.

Double click

Question 12

What are two benefits of using a live connection to a data source as compared to an extract? Choose two.

Options:

A.

Alive connection to a database server requires less network overhead than an extract.

B.

A workbook connected to a live connection will have fresher data than a workbook connected to an extract.

C.

A live connection reduces the amount of memory used on a client computer as compared to an extract.

D.

A live connection is always faster than an extract.

Question 13

Which three statements accurately describes the capabilities of dashboard actions? Choose three.

Options:

A.

Can be set to dynamically update when a workbook opens

B.

Can be set to Filter, Highlight, or Go to URL

C.

Can be set to run on Hover, Select, or Menu

D.

Can be set to be triggered on a data value

E.

Can have multiple source and target sheets

Question 14

Dimensions containing ____________ and ____________  values cannot be continuous.

Options:

A.

Boolean

B.

Date

C.

Date and Time

D.

String

Question 15

Which two elements can have their values changed by using a dashboard action? Choose two.

Options:

A.

Bins

B.

Groups

C.

Sets

D.

Parameters

Question 16

Which of the following options best describe measures?

Options:

A.

They are categorical, qualitative

B.

They are categorical, quantitative

C.

They are numerical, qualitative

D.

They are numerical, quantitative

Question 17

True or False: It is not possible to blend axes for multiple measures into a single axis

Options:

A.

False

B.

True

Question 18

Creating a scatter plot requires a minimum of how many measures?

Options:

A.

2

B.

4

C.

1

D.

3

Question 19

Which of the following lets you group related dashboard items together so you can quickly position them?

Options:

A.

Layout Extensions

B.

Layout Blanks

C.

Layout Containers

D.

Layout positioners

Question 20

When you connect to a new data source, all worksheets that previously referred to the original data source now refer to the new data source. If the new data source does not have the same field names as the original workbook, the fields are marked with an exclamation point 

. Which feature helps us fix this issue?

Options:

A.

Replace References

B.

Fix Metadata

C.

Renaming

D.

Aliases

Question 21

True or False: Sets can be created on Measures

Options:

A.

True

B.

False

Question 22

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

Options:

A.

Number of orders placed in that duration

B.

Number of days between these dates

C.

Number of unique orders placed between these dates

D.

Number of orders shipped between these dates

Question 23

DOWNLOAD THE DATASET FROM: (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?

Options:

A.

United States

B.

France

C.

United Kingdom

D.

Canada

Question 24

Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

Options:

A.

68,620

B.

74,683

C.

37,455

D.

46,493

Question 25

When should you use a relationship instead of a join for two data sets?

Options:

A.

The data sets include similar data aggregated up to the highest level.

B.

The data sets include similar data aggregated at different levels of detail.

C.

The data sets are in two separate tables within a single spreadsheet.

D.

To use both data sets across multiple sheets in a visualization.

Question 26

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

Options:

A.

0.4s

B.

0.3s

C.

0.5s

D.

0.2s

Question 27

How does Tableau know at which level to aggregate values?

Options:

A.

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

B.

Tableau doesn't aggregate values, we do!

C.

Values are always aggregated at the level of the Date Part

D.

Aggregation is always done by using Tableau special formulas

Question 28

For creating variable sized bins we use __________________

Options:

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Question 29

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.

Options:

A.

rue

B.

False

Question 30

What is the minimum amount of RAM recommended for any production use of Tableau Server?

Options:

A.

8GB

B.

16GB

C.

32GB

D.

64GB

Question 31

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

Options:

A.

Data cleaner

B.

Data manager

C.

Data interpreter

D.

Data organiser

Question 32

What are three benefits of using an extract as compared to a live connection to a data source? Choose three.

Options:

A.

A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.

B.

Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.

C.

A live connection to a data source provides the best performance for data connections.

D.

An extract reduces the amount of data stored on a client computer as compared to a live data connection.

E.

Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.

Question 33

What are two use cases for a story? Choose two.

Options:

A.

Provide additional editing and interactive capabilities to your audience.

B.

Present a data narrative to lead your audience to your conclusions.

C.

Assemble a sequenced analysis to share with collaborators.

D.

To allow for easier exporting to Power Point.

Question 34

Which of the following are valid Layout Container types when using Dashboards in Tableau?

Options:

A.

Vertical Container

B.

Diagonal Container

C.

Horizontal Container

D.

Split Container

Question 35

__________ is a technique in Tableau which will identify marks with similar characteristics

Options:

A.

Clustering

B.

Grouping

C.

Sets

D.

Union

Question 36

Question 30: Skipped

Using the CoffeeChain table, create a scatter plot of Profit (x-axis) vs Sales (y-axis) broken down by State. Add a Linear trend line to the view. What is its R-squared value?

Options:

A.

0.783262

B.

0.739284

C.

0.759329

D.

0.748472

Question 37

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

Options:

A.

Profit, State, Number of Records, Sales

B.

Region, Country, Profit, State

C.

Longitude, Country, State, Sales

D.

Sales, State, Country, Profit

Question 38

When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section?

Options:

A.

Monitor, Default, Phone, Tablet

B.

Phone, Tablet, Laptop, Desktop

C.

Default, Phone, Tablet, Desktop

D.

Phone, Monitor, Laptop, Default

Question 39

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

Options:

A.

True

B.

False

Question 40

Which of the following are valid Dashboard size options?

Options:

A.

Range

B.

Fixed Size

C.

Automatic

D.

Scaled

Question 41

You have a continuous numeric measure named Sales.

Which chart type is created when you double-click the Sales measure?

Options:

A.

A text table

B.

A line chart

C.

A pie chart

D.

A bar chart

Question 42

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

Options:

A.

592,593

B.

293,202

C.

416,702

D.

336,908

Question 43

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

Options:

A.

Portable Network Graphic (.PNG)

B.

JPEG Image (.JPG, .JPEG)

C.

Tagged Image File Format (TIFF)

D.

Windows Bitmap (.BMP)

Question 44

What are two correct methods for creating a visual group? Choose two.

Options:

A.

Select marks in the view.

B.

Click the drop-down arrow from the top of the Data pane.

C.

Right-click a dimension in the Data pane.

D.

Drag a dimension onto another dimension in the Data pane.

Question 45

The default path for all supporting files, data sources, icons, logs etc is in ______________________

Options:

A.

Documents -> Tableau Files

B.

Documents -> Tableau

C.

Documents -> My Tableau Repository

D.

Downloads -> Tableau Support Files

Question 46

What are two correct methods to change the data type of a field? Choose two.

Options:

A.

From the Data Source tab, click on the drop-down menu of the field.

B.

From the Data pane, click on the drop-down menu of the field.

C.

From the Data Source tab, click the data type icon of the field.

D.

From the Data pane, select and hold the field.

Question 47

You have a scatter plot visualization.

What should you do to configure the visualization as a density map?

Options:

A.

Change the mark shape of the view.

B.

Change the mark type of the view.

C.

Create a custom color palette.

D.

Select heat maps from Show Me.

Question 48

Which three elements are included in a packaged workbook (.twbx)? Choose three.

Options:

A.

A PDF copy of the workbook

B.

Background images

C.

Tableau Datasource Customization (TDC) files

D.

Extract files

E.

Custom shapes

Question 49

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

Options:

A.

Tableau Packaged Workbook (.twbx)

B.

Tableau Workbook (.twb)

C.

Tableau Data Extract (.tde)

D.

Tableau Data Source (.tds)

Question 50

When field names in the Union do not match, then:

Options:

A.

An error is raised and both fields are dropped from the resulting Union

B.

Only one field name is present in the Union with null values

C.

Only one field name is present in the Union with correct values since Tableau automatically corrects field name mismatch

D.

Both field names are present in the Union, but contain several null

values

Question 51

You have a workbook that contains one data source and you need to combine data from another database. What should you do first?

Options:

A.

Create an extract.

B.

Add a new connection.

C.

Add a new data source from the data source canvas.

D.

Edit the existing connection.

Question 52

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

Options:

A.

20,000

B.

5,000

C.

10,000

D.

15,000

Question 53

What are two requirements to combine two tables by using a union? Choose two.

Options:

A.

Related fields must have matching data types.

B.

Related fields must have different names.

C.

The tables must come from different connections.

D.

The tables must have the same number of fields.

Question 54

Which of the following are true about Dashboards in Tableau?

Options:

A.

Floating items can be layered over other objects

B.

Tiled items don't overlap

C.

A bar chart can be used a floating item

D.

None of these

Question 55

Which type of date filter can you use to choose a range of dates based on TODAY ()?

Options:

A.

Range of dates

B.

Relative dates

C.

Ending date

D.

Starting date

Question 56

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

Options:

A.

Region, Country, Profit, State

B.

Sales, State, Country, Profit

C.

Profit, State, Number of Records, Sales

D.

Longitude, Country, State, Sales

Question 57

Which of the following fields would be best used as Dimensions?

Options:

A.

Profit

B.

Names

C.

Categories

D.

Sales

Question 58

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

Options:

A.

True

B.

False

Question 59

Download the Dataset from:

Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

Options:

A.

September 2017

B.

March 2018

C.

December 2017

D.

January 2018

Question 60

Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Options:

A.

25.79%

B.

23.39%

C.

27.73%

D.

29.49%

Question 61

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Options:

A.

Yes

B.

No

Question 62

What allows you to drill up or down in the level of detail (LOD)?

Options:

A.

Bins

B.

Groups

C.

Hierarchies

D.

Sets

Question 63

Is SUM a table calculation?

Options:

A.

Yes

B.

No

Question 64

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

Options:

A.

Improved Performance

B.

Ability to use the data offline

C.

Working with freshest data at all times

D.

Faster to work with

Question 65

In order to avoid any confusions, what should you do after creating a Dual-axis chart?

Options:

A.

Hide the axis

B.

Change the colours

C.

Synchronise the axis

D.

Edit the labels

Question 66

The icon associated with the field that has been grouped is a ______________

Options:

A.

Paper Clip

B.

Globe

C.

Intersection

D.

=#

Question 67

As a general best practice, how many categories can a pie chart display effectively?

Options:

A.

2 to 5

B.

3 to 5

C.

2 to 8

D.

3 to 7

Question 68

Using the atheletes table:

i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1)

ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark. (Sheet 2)

Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?

(Ignore any nulls / unknowns)

Options:

A.

76.25

B.

65.67

C.

68.77

D.

4.87

Question 69

What should you use to apply bold text formatting to rows or columns independent of each other?

Options:

A.

Text on the Marks card

B.

The Field Format Font pane

C The Rows tab or the Columns tab on the Format Font pane

C.

The Sheets tab on the Format Font pane

Question 70

What is a Tableau story point?

Options:

A.

The pane where you set the size of the story

B.

A collection of talking points to drive the story

C.

An individual sheet or dashboard in the story

D.

A collection of sheets arranged in a sequence

Question 71

Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other?

Options:

A.

Right click on Rows or Columns, and choose format. In the Font

option click on Bold.

B.

Select Text Label on the Marks Card, choose Rows or Columns, and then

select Bold.

C.

Choose Format then Font from the Menu bar, and select Bold under the

Header option

D.

Choose Format from the Menu bar, select Row or Column, and

then select Bold under the header option

Question 72

Which of the following are FALSE about Joins?

Options:

A.

Joins can be defined at the time of query dynamically

B.

May drop unmatched measure values

C.

They are displayed with Venn diagram icons between physical tables

D.

Joined tables are never merged into a single table.

E.

They are a more dynamic way than relationships to combine data

Question 73

Which action describes the process for changing a measure so that it automatically aggregates an average instead of a sum?

Options:

A.

Right-click the field in the Data pane and select Default Properties to change it.

B.

Add the field to the view, right-click the axis, and select Format to change it.

C.

Right-click the field in the Data pane and select Change Data Type to change it.

D.

Right-click and drag the field into the view to change it.

Question 74

What is the default behavior of Tableau when you add a measure to the view?

Options:

A.

You are prompted to add an aggregation.

B.

An aggregation is applied that is independent of the context of the view.

C.

The measure is added disaggregated.

D.

An aggregation is applied that varies depending on the context of the view.

Question 75

You have the following visualization.

You need to show how Internet Usage values change from year-to-year as a percentage. Which quick table calculation should you apply to the Internet Usage field?

Options:

A.

Compound A. growth rate

B.

Percent difference

C.

Difference

D.

Percentile

Question 76

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

Options:

A.

CSV file

B.

PDF File

C.

JSON format

D.

MS Access Database

Question 77

Which of the following are valid ways to Bold the Tooltip content in Tableau?

Options:

A.

Click on Analysis, Tooltip options, and select bold.

B.

Click on Tooltip in the Marks card, and select bold.

C.

Click on Worksheet in the Menu bar, followed by Tooltip and select

the bold option

D.

Right click, click format and then under the default worksheet

formatting, choose Tooltip and make it bold.

Question 78

You want to provide additional information when hovering over a field in the Data pane as shown in the following exhibit.

What should you configure for the field?

Options:

A.

An alias

B.

A header label

C.

A hierarchy

D.

A default comment

Question 79

Data blending simulates a traditional _________________ Join

Options:

A.

Inner

B.

Right

C.

Full Outer

D.

Left

Question 80

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

Options:

A.

True

B.

False

Question 81

Dates in Tableau are typically treated as ______________

Options:

A.

Dimensions

B.

Measures

Question 82

We can join a maximum of ______ tables in Tableau

Options:

A.

16

B.

32

C.

64

D.

128

Question 83

Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

Options:

A.

1 , 4

B.

2 , 2

C.

2 , 3

D.

1 , 2

Question 84

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

Options:

A.

Spatial

B.

Excel

C.

Text

D.

JSON

Question 85

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

Options:

A.

top left bottom left

B.

top right, bottom right

C.

top left, bottom right

D.

top right, bottom left

Question 86

Which of the following is a valid way to create Sets in Tableau?

Options:

A.

In the Data pane, right-click a dimension and select Create > Set.

B.

In the Tableau Main Menu, Choose Worksheet and select Create > Set

C.

In the Tableau Main Menu, choose Dashboard and select Create > Set

D.

In the Data pane, right-click a measure and select Create > Set.

Question 87

How can you format numbers in Tableau as currency?

Options:

A.

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

B.

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

C.

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

D.

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

Question 88

True or False: When relating tables, the fields that define the relationships must have the same data type.

Options:

A.

True

B.

False

Question 89

Which of the following describes the best way to change the formatting at a workbook level?

Options:

A.

Right click anywhere in the view, choose format, and then specify the

formatting in the new Format workbook pane.

B.

It is only possible to specify formatting at a worksheet level, not at the

workbook level.

C.

Click on Text in the Marks card, choose format, and then specify the

formatting in the new Format workbook pane.

D.

Choose Format from the menu on top and then specify the

formatting in the new Format workbook pane.

Question 90

Which of the following are required to create a trend line?

Options:

A.

2 measures on opposing axes, or a date and a measure on

opposing axes.

B.

1 measure, or a date and a dimension on opposing axes.

C.

1 measure only

D.

2 dimensions, or a date and a dimension on opposing axes.

Question 91

Which of the following are valid ways of Grouping Data?

Options:

A.

Using Marks in the view

B.

Using Labels in the View

C.

From the Analytics Pane

D.

From the Dimensions Shelf

Question 92

True or False : Bins can be created on dimensions

Options:

A.

False

B.

True

Question 93

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

Options:

A.

Tableau Data Extract (.tde)

B.

Tableau Packaged Workbook (.twbx)

C.

Tableau Bookmark (.tbm)

D.

Tableau Workbook (.twb)

Question 94

You have the following visualization.

Which set type is created when you select the Create Set option?

Options:

A.

A fixed set

B.

A dynamic set

C.

A Top N set

D.

A combined set