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

Tableau Desktop Specialist Exam Question and Answers

Tableau Desktop Specialist Exam

Last Update May 2, 2024
Total Questions : 314

We are offering FREE Desktop-Specialist Tableau exam questions. All you do is to just go and sign up. Give your details, prepare Desktop-Specialist free exam questions and then go for complete pool of Tableau Desktop Specialist Exam test questions that will help you more.

Desktop-Specialist pdf

Desktop-Specialist PDF

$35  $99.99
Desktop-Specialist Engine

Desktop-Specialist Testing Engine

$42  $119.99
Desktop-Specialist PDF + Engine

Desktop-Specialist PDF + Testing Engine

$56  $159.99
Questions 1

What are three geographic roles that you can assign to a field? Choose three.

Options:

A.  

Address

B.  

Time zone

C.  

City

D.  

Country

E.  

Airport

Discussion 0
Questions 2

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.

Discussion 0
Questions 3

To display data that has both negative and positive quantitative values, Tableau Desktop will display marks by using__________________as the default.

Options:

A.  

the full color range

B.  

a diverging palette

C.  

a sequential palette

D.  

a categorical palette

Discussion 0
Questions 4

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

Discussion 0
Questions 5

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

Options:

A.  

Measure Names

B.  

Number of Records

C.  

Measure Values

D.  

Calculated Fields

Discussion 0
Questions 6

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

Options:

A.  

Dimensions, Measures

B.  

Measures, Dimensions

C.  

Groups, Sets

D.  

Dates, Strings

Discussion 0
Questions 7

You need to uniformly change the size for all marks in a view.

What should you do?

Options:

A.  

Select Label on the Marks card and then select Alignment.

B.  

Use the Fit dropdown menu on the toolbar.

C.  

Select Format on the menu, and then select Cell Size.

D.  

Select Size on the Marks card and use the slider to adjust the size

Discussion 0
Questions 8

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

Options:

A.  

Data cleaner

B.  

Data manager

C.  

Data interpreter

D.  

Data organiser

Discussion 0
Questions 9

True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Options:

A.  

True

B.  

False

Discussion 0
Questions 10

A Tableau Data Source File (.tds) contains which of the following?

Options:

A.  

Default Field Properties

B.  

Copy of any local file-based data

C.  

Calculated Fields

D.  

Data Source Type

Discussion 0
Questions 11

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

Options:

A.  

8GB

B.  

16GB

C.  

32GB

D.  

64GB

Discussion 0
Questions 12

When creating a histogram in Tableau, to what does bin size refer?

Options:

A.  

The minimum number of axis ticks in the view.

B.  

The range of the continuous measure counted in each bin.

C.  

The count distinct (COUNTD) of items on either axis.

D.  

The maximum number of marks in the view.

Discussion 0
Questions 13

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

Options:

A.  

Groups

B.  

Calculated Fields

C.  

Measures

D.  

Dimensions

Discussion 0
Questions 14

Which of the following is a discrete date part?

Options:

A.  

07Mar20l7

B.  

20Sep2016:9:8:8:6546

C.  

01/23/2021

D.  

February

Discussion 0
Questions 15

Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format.

Options:

A.  

.tds

B.  

.tdex

C.  

.hyper

D.  

.twbx

Discussion 0
Questions 16

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

Discussion 0
Questions 17

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

Discussion 0
Questions 18

For creating variable sized bins we use __________________

Options:

A.  

Calculated Fields

B.  

Table Calculations

C.  

Sets

D.  

Groups

Discussion 0
Questions 19

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

Options:

A.  

Bins

B.  

Groups

C.  

Sets

D.  

Parameters

Discussion 0
Questions 20

_________________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don’t allow relationships or joins

Options:

A.  

Union

B.  

Data Joining

C.  

Data segregation

D.  

Data Blending

Discussion 0
Questions 21

Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Options:

A.  

using 2 measures

B.  

using 2 dimensions

C.  

using 2 dimensions and 3 measures

D.  

using 1 measure

Discussion 0
Questions 22

How can you format an axis as Bold in Tableau?

Options:

A.  

By choosing the axis and selecting Command/Control + B on your keyboard

B.  

By right clicking on the axis, choosing Edit Axis, and then setting its font to bold.

C.  

By right clicking on the axis, choosing format, and then setting its font to bold.

D.  

By clicking on Format on the main menu bar, choosing field labels, and setting it to bold.

Discussion 0
Questions 23

When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Options:

A.  

reversed

B.  

stepped

C.  

diverging

D.  

converging

Discussion 0
Questions 24

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.

Discussion 0
Questions 25

How can you set the default properties of a field to Currency?

Options:

A.  

From the Data pane, configure the number format of the field.

B.  

From the Format menu, configure the Font settings

C.  

From the Format menu, configure the Field Labels settings.

D.  

From the Data pane, configure the data type of the field.

Discussion 0
Questions 26

For Bullet Graphs we need at least ____________ measures

Options:

A.  

3

B.  

1

C.  

2

D.  

4

Discussion 0
Questions 27

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%

Discussion 0
Questions 28

When creating an extract, what are three options for specifying how much data to extract? Choose three.

Options:

A.  

Hide all unused fields.

B.  

Aggregate data for visible dimensions

C.  

Compute Calculations Now.

D.  

Append Data from Files

E.  

Apply a filter.

Discussion 0
Questions 29

You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

Options:

A.  

join

B.  

blend

C.  

concatenate

D.  

union

Discussion 0
Questions 30

Which one of the following is a dimension?

Options:

A.  

Longitude

B.  

Measure Names

C.  

Number of records

D.  

Latitude

Discussion 0
Questions 31

Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

Options:

A.  

It only adds rows that are new since the previous refresh.

B.  

There is no difference, both are the same when using extracts. They are

different when using live connections.

C.  

It replaces all of the contents in the extract

D.  

They can only be used with large datasets

Discussion 0
Questions 32

Which of the following points are True about Viz Animations?

Options:

A.  

Sequential animations take more time but make complex changes

clearer by presenting them step-by-step

B.  

They can be turned on for certain worksheets only

C.  

Animations work well with maps, polygons, and density marks in web

browsers

D.  

It is possible to turn them on for the entire workbook at once

Discussion 0
Questions 33

Which statement accurately describes an extract when the Physical Tables option is selected?

Options:

A.  

Data is limited to only the Top N of data for the connection.

B.  

All the data is tolled up to the current visible fields.

C.  

An individual table is created for each physical table in the extract.

D.  

Data shown in the Data pane is separated based on the table type.

Discussion 0
Questions 34

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

Discussion 0
Questions 35

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 36

Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Options:

A.  

Brazil

B.  

Peru

C.  

Argentina

D.  

Mexico

Discussion 0
Questions 37

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

Discussion 0
Questions 38

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

Discussion 0
Questions 39

Which three statements accurately describe dimensions? Choose three.

Options:

A.  

Contain qualitative values

B.  

Affect the level of detail in the view

C.  

Contain numeric, quantitative values

D.  

Can be continuous or discrete

E.  

Affect the formatting options in the view

Discussion 0
Questions 40

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

Discussion 0
Questions 41

Larger image

What is this view referred to as in Tableau?

Options:

A.  

Analytics Pane

B.  

Window Pane

C.  

Data Pane

D.  

Dimensions & Measures

Discussion 0
Questions 42

What are three options to change the scope of a reference line? Choose three.

Options:

A.  

Per Pane

B.  

Fill Above

C.  

Entire Table

D.  

Maximum

E.  

Per Cell

Discussion 0
Questions 43

Which two types of fields appear blue? Choose two.

Options:

A.  

Continuous measures

B.  

Discrete measures

C.  

Continuous dimensions

D.  

Discrete dimensions

Discussion 0
Questions 44

We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop.

Options:

A.  

Tableau Reader

B.  

Tableau Online

C.  

Tableau Server

D.  

Tableau Desktop

Discussion 0
Questions 45

Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

Options:

A.  

Treemaps

B.  

Pie charts

C.  

Histograms

D.  

Area charts

Discussion 0
Questions 46

What should you use to create headers in a visualization?

Options:

A.  

A parameter

B.  

A measure

C.  

A dimension

D A filter

Discussion 0
Questions 47

Which two filter modes can you use with dimension filters? Choose two

Options:

A.  

Multiple Values (drop-down)

B.  

At most

C.  

Wildcard Match

D.  

Range of Values

Discussion 0
Questions 48

What will the following function return?

LEFT("Tableau", 3)

Options:

A.  

An error

B.  

Tab

C.  

eau

D.  

ble

Discussion 0
Questions 49

What term is used to describe the following picture?

Options:

A.  

Larger image

B.  

Parameter

C.  

Set

D.  

Hierarchy

E.  

Group

Discussion 0
Questions 50

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

Discussion 0
Questions 51

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

Discussion 0
Questions 52

What does the following icon do in Tableau?

Larger image

Options:

A.  

Create a Story

B.  

Create a Story and Dashboard both

C.  

Create a Worksheet

D.  

Create a Dashboard

Discussion 0
Questions 53

Which of the following charts types always includes bars sorted in descending order?

Options:

A.  

Pareto Chart

B.  

Pie Chart

C.  

Gantt Chart

D.  

Stacked Bar Chart

Discussion 0
Questions 54

Which of the following are valid Dashboard size options?

Options:

A.  

Range

B.  

Fixed Size

C.  

Automatic

D.  

Scaled

Discussion 0
Questions 55

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

Options:

A.  

Gantt Chart

B.  

Bullet chart

C.  

Histogram

D.  

Treemaps

Discussion 0
Questions 56

True or False: When you drag additional tables to the logical layer canvas, Tableau automatically attempts to create the relationship based on existing key constraints and matching fields to define the relationship. If it can't determine the matching fields, then relating these tables is not possible.

Options:

A.  

True

B.  

False

Discussion 0
Questions 57

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

Options:

A.  

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

B.  

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

C.  

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.

D.  

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.

Discussion 0
Questions 58

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?

Options:

A.  

$16,581

B.  

(Correct)

C.  

$147,950

D.  

$48,115

E.  

$33,768

Discussion 0
Questions 59

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

Options:

A.  

Bins

B.  

Groups

C.  

Hierarchies

D.  

Sets

Discussion 0
Questions 60

Which of the following situations describe the best reason to use a union?

Options:

A.  

You have two tables with similarly named columns of data that you want to combine.

B.  

You have two data sets with similar data types for which you want to find only distinct values.

C.  

You have two tables with differently named columns of data that you want to combine.

D.  

You have two data sets saved in different formats that you want to unify into a single format.

Discussion 0
Questions 61

By default, what does Tableau do when you connect to a data source?

Options:

A.  

Creates an extract of the data

B.  

Creates a live connection to the data

C.  

Loads your actual file into Tableau

D.  

Sorts the data in descending order

Discussion 0
Questions 62

A union of two tables usually results in  an 

Options:

A.  

decrease in the number of rows

B.  

increase in the number of rows

C.  

decrease in the number of columns

D.  

increase in the number of columns

Discussion 0
Questions 63

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

Options:

A.  

Red, Blue

B.  

Orange, Blue

C.  

Blue, Red

D.  

Blue, Orange

Discussion 0
Questions 64

How can you MANUALLY assign geographic roles to a dimension from the data pane?

Options:

A.  

Edit the config file in My Documents -> MyTableauRepository for a quick fix

B.  

Right click it -> Geographic role -> and then assign the appropriate geographic role

C.  

Edit the data source manually for a quick resolution

D.  

Right click it -> Edit Default properties -> Assign geographic roles

Discussion 0
Questions 65

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

Discussion 0
Questions 66

Which of the following are True for Measure Names?

Options:

A.  

It contains all the measures in your data, collected into a single field with continuous values.

B.  

When you add it to a view, all of the measure names appear as row or column headers in the view.

C.  

When working with a text table showing Profit for each Category,

when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves.

D.  

It contains the names of all measures in your data, collected into a single field with discrete values.

Discussion 0
Questions 67

You have the following string value: Sales Data.

Which calculated field produces an output of Sales?

Options:

A.  

LTRIM("Sales Data")

B.  

LEFT ("Sales Data", 5)

C.  

LEFT ("Sales Data")

D.  

RTRIM( "Sales Data")

Discussion 0
Questions 68

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

Discussion 0
Questions 69

Which of the following is the correct way to calculate Profit Ratio in Tableau?

Options:

A.  

Profit / Sales

B.  

Sales / Profit

C.  

SUM(Profit) / SUM(Sales)

D.  

SUM(Sales)/SUM(Profit)

Discussion 0
Questions 70

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.

Options:

A.  

Regex Search

B.  

Union Search

C.  

Pattern Search

D.  

Wildcard Search

Discussion 0
Questions 71

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?

Options:

A.  

3.000

B.  

3.840

C.  

3.704

D.  

3.500

Discussion 0
Questions 72

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

Discussion 0
Questions 73

You have a visualization that uses multiple types of sorting.

How can you clear all sorting of the visualization?

Options:

A.  

Right-click a sorted field, and then select Clear Sort.

B.  

From the Dashboard menu, select Clear.

C.  

From the Header label, select the sort icon.

D.  

From the Worksheet menu, select Clear, and then select Sorts.

Discussion 0
Questions 74

What are two examples of a date value?

Choose two.

Options:

A.  

2020-05-01

B.  

December

C.  

Wednesday

D.  

January 1.1995

Discussion 0
Questions 75

Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Options:

A.  

October

B.  

September

C.  

July

D.  

June

Discussion 0
Questions 76

What are two methods for renaming a field in a visualization? Choose two.

Options:

A.  

From the Data pane, click and hold on the field until the name is editable.

B.  

From the Data pane, use the field's drop-down menu and select Rename.

C.  

From the Format menu, select Field Labels.

D.  

From the Data pane, right-click the field and select Replace References.

Discussion 0
Questions 77

True or False : Bins can be created on dimensions

Options:

A.  

False

B.  

True

Discussion 0
Questions 78

What is the following icon in the Data pane used to do?

Larger image

Options:

A.  

View Data

B.  

Clean Data

C.  

Extract Data

D.  

Sort Data

Discussion 0
Questions 79

True or False: You get different filtering options for categorical and quantitative data

Options:

A.  

True

B.  

False

Discussion 0
Questions 80

Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?

Options:

A.  

If dragged to row shelf : 14 marks ; If dragged to column shelf : 7

marks

B.  

If dragged to row shelf : 7 marks ; If dragged to column shelf : 14 marks

C.  

If dragged to row shelf : 14 marks ; If dragged to column shelf : 14 marks

D.  

If dragged to row shelf : 7 marks ; If dragged to column shelf : 7 marks

Discussion 0
Questions 81

By definition, Tableau displays measures over time as a ____________

Options:

A.  

Packed Bubble

B.  

Bar

C.  

Stacked Bar

D.  

Line

Discussion 0
Questions 82

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.

Discussion 0
Questions 83

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

Options:

A.  

Profit

B.  

Names

C.  

Categories

D.  

Sales

Discussion 0
Questions 84

You need to invert the color intensity of a quantitative range. Which option should you use?

Options:

A.  

Reversed

B.  

Opacity

C.  

Border

D.  

Stepped Color

Discussion 0
Questions 85

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

Discussion 0
Questions 86

______________ refers to the level of detail for a piece of data, wherever you are looking.

Options:

A.  

Data Cleanliness

B.  

Data granularity

C.  

Data connectivity

D.  

Data LOD

Discussion 0
Questions 87

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?

Options:

A.  

9

B.  

7

C.  

10

D.  

8

Discussion 0
Questions 88

The option to create bins is available for which type of field?

Options:

A.  

Boolean

B.  

String

C.  

Date

D.  

Numeric

Discussion 0
Questions 89

When using a data source that has relationships, how can you add a join between two or more tables?

Options:

A.  

From the Tables pane, double-click a table.

B.  

From the Tables pane, drag a table directly on top of an existing logical table.

C.  

From the Connections pane, select Add.

D.  

Double-click a logical table in the canvas.

Discussion 0
Questions 90

You view the relationship canvas shown in the following exhibit.

What does Migrated Data indicate?

Options:

A.  

The workbook was created in previous version of Tableau Desktop.

B.  

The data was imported from Tableau Server.

C.  

The data was recently saved as a packaged data source.

D.  

The workbook was downloaded from Tableau Online.

Discussion 0
Questions 91

Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Options:

A.  

Tom Ashbrook

B.  

Sanjit Engle

C.  

Penelope Sewall

D.  

Tamara Chand

Discussion 0
Questions 92

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

Discussion 0
Questions 93

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.

Discussion 0
Questions 94

Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________.

Options:

A.  

role, type

B.  

Data type, Value

C.  

type, role

D.  

dimension, measure

Discussion 0