Labour Day Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

Desktop-Specialist Tableau Desktop Specialist Exam Questions and Answers

Questions 4

With the Marks card drop-down menu set to Automatic, a line chart will be created whenever you place what on the Rows shelf and the Columns shelf?

Options:

A.

Measures on one shelf, and a date dimension on the other

B.

Zero or more dimensions on one shelf, and 2 or more measures on the other

C.

A date dimension followed by a continuous measure on one shelf

D.

Zero or more measures on one shelf, and 2 or more dimensions on the other

Buy Now
Questions 5

Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

Options:

A.

96.46%

B.

95.12%

C.

97.12%

D.

99.46%

Buy Now
Questions 6

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

Buy Now
Questions 7

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

Options:

A.

Spatial

B.

Excel

C.

Text

D.

JSON

Buy Now
Questions 8

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

Options:

A.

True

B.

False

Buy Now
Questions 9

True or False: Sets can be created on Measures

Options:

A.

True

B.

False

Buy Now
Questions 10

You need to access options to change a dimension's color palette.

In addition to the Marks card, what else can you use?

Options:

A.

The Color legend

B.

Edit in Shelf

C.

The Format menu

D.

Edit Caption

Buy Now
Questions 11

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

Options:

A.

Clustering

B.

Grouping

C.

Sets

D.

Union

Buy Now
Questions 12

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

Options:

A.

In Downloads -> My Tableau Repository -> Shapes

B.

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

C.

In Program Files -> Tableau -> Shapes

D.

In My Documents -> My Tableau Repository -> Shapes

Buy Now
Questions 13

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

Buy Now
Questions 14

The row and column shelves contain ___________________

Options:

A.

Pills

B.

Grand Totals

C.

Filters

D.

Parameters

Buy Now
Questions 15

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.

Buy Now
Questions 16

Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region?

Options:

A.

Measure Filters

B.

Context Filters

C.

Extract Filters

D.

Dimension Filters

Buy Now
Questions 17

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.

Buy Now
Questions 18

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

Options:

A.

Number of Records

B.

Measure Names

C.

Measure Values

D.

Calculated Fields

Buy Now
Questions 19

What are two use cases for creating hierarchies from the Data pane? Choose two.

Options:

A.

To organize related fields together

B.

To create faster-performing queries

C.

To concatenate all fields into a single field

D.

To add drilldown functionality for fields

Buy Now
Questions 20

How can you create a packaged data source?

Options:

A.

From the Worksheet menu, select Export, and then select Data.

B.

From the Data pane, right-click the data connection, and then select Add to Saved Data Sources.

C.

From the File menu, select Share.

D.

From the File menu, select Save As.

Buy Now
Questions 21

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

Buy Now
Questions 22

True or False : Bins can be created on dimensions

Options:

A.

False

B.

True

Buy Now
Questions 23

Which of the following is NOT a new feature introduced in Tableau 2020.1?

Options:

A.

Dynamic Paramaters

B.

Viz Animations

C.

Buffer Calculations

D.

Set Control

Buy Now
Questions 24

To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs

Options:

A.

parameters

B.

sets

C.

values

D.

inputs

Buy Now
Questions 25

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%

Buy Now
Questions 26

Which two options can you use to change the device layout of a dashboard? Choose two.

Options:

A.

The Dashboard pane

B.

The Format menu

C.

The Dashboard menu

D.

The Layout pane

Buy Now
Questions 27

Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through 2014, respectively?

Options:

A.

5,129 and 88,872

B.

52,678 and 311,404

C.

1,807 and 34,571

D.

4,888 and 17,817

Buy Now
Questions 28

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

Options:

A.

True

B.

False

Buy Now
Questions 29

Dragging a ______________ to colour creates distinct colours for each item whereas dragging a ______________ to colour creates a gradient

Options:

A.

Discrete value, Continuous Value

B.

Geographic Value, Discrete Value

C.

Continuous Value, Discrete Value

D.

Longitude, Latitude

Buy Now
Questions 30

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.

Buy Now
Questions 31

Desktop-Specialist Question 31

You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

Options:

A.

Clean the data

B.

Preview the data

C.

Create visualisations to analyze your data

D.

Rename the fields and change data types

Buy Now
Questions 32

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

Buy Now
Questions 33

The Shape option is available for which two views? Choose two.

Options:

A.

Side-by-side circles

B.

Scatter plots

C.

Heat maps

D.

Packed bubbles

Buy Now
Questions 34

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

Buy Now
Questions 35

Which of the following are true about dimensions?

Options:

A.

They contain contain numeric, quantitative values

B.

They contain qualitative values (such as names, dates, or

geographical data)

C.

They affect the level of detail in the view

D.

Dates are mostly placed in dimensions by default for relational

data sources

Buy Now
Questions 36

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

Buy Now
Questions 37

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

Buy Now
Questions 38

What does it imply if a field has a blue background?

Options:

A.

It is continuous

B.

It is discrete

C.

It is a dimension

D.

It is a measure

Buy Now
Questions 39

If you see the following Filter, then you're working with _______________________

Larger image

Desktop-Specialist Question 39

Options:

A.

Grouped Dates

B.

Date Functions

C.

Date Parts

D.

Date Values

Buy Now
Questions 40

Which of the following are interactive elements that can be added to a dashboard for users?

Options:

A.

URL Action

B.

Filter Action

C.

Highlight Action

D.

Edit Tooltip Action

Buy Now
Questions 41

What are two use cases for creating hierarchies from the Data pane? Choose two.

Options:

A.

To concatenate all fields into a single field

B.

To add drilldown functionality for fields

C.

To create faster-performing queries

D.

To organize related fields together

Buy Now
Questions 42

You may create a context filter to:

Options:

A.

To create a dependent filter

B.

Improve performance

C.

To replace a data source filter

D.

Create a dependent numerical or top N filter

Buy Now
Questions 43

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

Options:

A.

ABS(Number)

B.

CEILING(Number)

C.

FLOOR(Number)

D.

ZN(Number)

Buy Now
Questions 44

What does the following marker/icon do in Tableau?

Desktop-Specialist Question 44

Options:

A.

Format the Legends

B.

Edit the Colors

C.

Toggle the highlighting on/off.

D.

Highlight the largest value

Buy Now
Questions 45

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

Buy Now
Questions 46

Options:

A.

Bullet

B.

Line

C.

Gantt

D.

Area

Buy Now
Questions 47

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

Buy Now
Questions 48

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.

Buy Now
Questions 49

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

Buy Now
Questions 50

For creating variable sized bins we use __________________

Options:

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Buy Now
Questions 51

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

Options:

A.

Paper Clip

B.

Globe

C.

Intersection

D.

=#

Buy Now
Questions 52

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.

Buy Now
Questions 53

What statement correctly describes a requirement to create a reference line in Tableau?

Options:

A.

One of the axis must contain a dimension.

B.

One of the axis must contain an aggregated measure.

C.

The reference line must be created on a continuous axis.

D.

The reference line must be paired with a date field.

Buy Now
Questions 54

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

Buy Now
Questions 55

Which of the following are valid objects when creating a dashboard in Tableau? Choose 4.

Options:

A.

Video

B.

Text

C.

Extension

D.

Image

E.

Web Page

Buy Now
Questions 56

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

Buy Now
Questions 57

Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Options:

A.

Yes

B.

No

Buy Now
Questions 58

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

Buy Now
Questions 59

True or False: Enabling any other type of sort (Field, alphabetic, or Nested) clears the manual sort we create.

Options:

A.

True

B.

False

Buy Now
Questions 60

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

Options:

A.

Tableau Reader

B.

Tableau Desktop

C.

Tableau Server

D.

Tableau Public

Buy Now
Questions 61

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

Buy Now
Questions 62

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

Options:

A.

True

B.

False

Buy Now
Questions 63

Which of the following are valid ways to copy a worksheet visualisation as an image?

Options:

A.

By simply clicking Control + V on the keyboard

B.

By clicking on Worksheet in the Tableau Main Menu above, and choosing Copy->Image

C.

Using the Marks shelf and choosing Copy->Image

D.

By right clicking on the worksheet visualisation and selecting Copy->Image

Buy Now
Questions 64

Which of the following are valid options to define the scope of a reference line? Choose 3.

Options:

A.

Pane

B.

Table

C.

Section

D.

Window

E.

cell

F.

Axis

Buy Now
Questions 65

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.

Buy Now
Questions 66

How can you add color to marks in the view in Tableau?

Options:

A.

Click on Data in the main menu above, and click on choose color.

B.

From the Data pane, drag a field to Color on the Marks card.

C.

In the column/row shelf, right click the field and click on edit in shelf to select the color.

D.

From the Analytics pane, drag a model to Color on the Marks card.

Buy Now
Questions 67

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

Buy Now
Questions 68

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

Buy Now
Questions 69

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

Buy Now
Questions 70

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

Buy Now
Questions 71

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

Buy Now
Questions 72

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

Buy Now
Questions 73

Which two filter modes can you use with continuous filters? Choose two.

Options:

A.

Multiple Values

B.

Special

C.

Range of Values

D.

Single Values

Buy Now
Questions 74

You want to update the font of an entire workbook.

What should you use to configure the default fonts?

Options:

A.

The Formal Font pane

B.

The Format Workbook pane

C.

Field labels

D.

Titles and captions

Buy Now
Questions 75

When is an axis created for the visualisation in Tableau?

Options:

A.

When we drag a measure to the row/column shelf

B.

When we drag a dimension to the row/column shelf

C.

When we drag a discrete field to the row/column shelf

D.

When we drag a continuous field to the row/column shelf

Buy Now
Questions 76

Which of the following is not a Trend Line Model?

Options:

A.

Linear Trend Line

B.

Exponential Trend Line

C.

binomial Trend Line

D.

Logarithmic Trend Line

Buy Now
Questions 77

You have the following visualization.

Desktop-Specialist Question 77

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

Buy Now
Questions 78

What is the one most important thing you should do after creating a Dual-axis chart?

Options:

A.

Synchronise the axis

B.

Change the colours

C.

Edit the labels

D.

Hide the axis

Buy Now
Questions 79

Which of the following is a discrete date part?

Options:

A.

07Mar20l7

B.

20Sep2016:9:8:8:6546

C.

01/23/2021

D.

February

Buy Now
Questions 80

How would you calculate GDP per capita in Tableau?

Options:

A.

SUM([GDP]/[POPULATION])

B.

SUM([Population]/[GDP]])

C.

SUM([GDP]*[POPULATION])

D.

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

Buy Now
Questions 81

By default, measures placed in a view are aggregated. The type of aggregation applied ______________

Options:

A.

is always sum

B.

depends on the context of the view

C.

is always COUNT

D.

is always AVERAGE

Buy Now
Questions 82

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.

Buy Now
Questions 83

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.

Buy Now
Questions 84

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

Options:

A.

False

B.

True

Buy Now
Questions 85

True or False: All rows from both tables are returned in an INNER JOIN

Options:

A.

True

B.

False

Buy Now
Questions 86

What are two ways to share a dashboard as an image file? Choose two.

Options:

A.

Export Image on the Dashboard menu

B.

Export on the Worksheet menu

C.

Copy Formatting on the Format menu

D.

A dashboard export button

Buy Now
Questions 87

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

Options:

A.

A Blend

B.

A Hierarchy

C.

A Set

D.

A Join

Buy Now
Questions 88

Which of the following are compelling reasons to use a Stacked Bar Chart?

Options:

A.

To visualize parts of a whole

B.

To easily visualize trends over time

C.

To be able to visualize complex information with fewer bars /

marks

D.

To visualize each discrete category using a separate bar.

Buy Now
Questions 89

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

Options:

A.

2

B.

4

C.

1

D.

3

Buy Now
Questions 90

Which one of the following is a dimension?

Options:

A.

Longitude

B.

Measure Names

C.

Number of records

D.

Latitude

Buy Now
Questions 91

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

Buy Now
Questions 92

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

Buy Now
Questions 93

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?

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

Buy Now
Questions 94

Which of the following URL prefixes are permitted when creating a URL Action in Tableau?

Options:

A.

SMTP

B.

FTP

C.

HTTPS

D.

HTTP

Buy Now
Exam Code: Desktop-Specialist
Exam Name: Tableau Desktop Specialist Exam
Last Update: Apr 30, 2024
Questions: 314

PDF + Testing Engine

$66.4  $165.99

Testing Engine

$46  $114.99
buy now Desktop-Specialist testing engine

PDF (Q&A)

$42  $104.99
buy now Desktop-Specialist pdf