March Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > Tableau > Tableau Desktop Specialist > TDS-C01

TDS-C01 Tableau Desktop Specialist Exam Question and Answers

Question # 4

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?

A.

Clean the data

B.

Preview the data

C.

Create visualisations to analyze your data

D.

Rename the fields and change data types

Full Access
Question # 5

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

A.

top left

B.

center

C.

bottom left

D.

bottom right

E.

top right

Full Access
Question # 6

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

A.

2

B.

4

C.

1

D.

3

Full Access
Question # 7

When creating a date filter in Tableau, to what does Anchor refer?

A.

The mid-point in the range of displayed dates.

B.

The date in a relative-date filter to which you anchor a unit of time.

C.

The date in a range-of-dates filter to which you anchor units of time.

D.

The latest date in the data source that can be found.

Full Access
Question # 8

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

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.

Full Access
Question # 9

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

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.

Full Access
Question # 10

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

A.

2 to 5

B.

3 to 5

C.

2 to 8

D.

3 to 7

Full Access
Question # 11

From which three locations can you sort a visualization? Choose three.

A.

The Worksheet menu

B.

Tooltip on the Marks card

C.

DCA header

D.

The Analysis menu

E.

An axis

F.

Afield label

Full Access
Question # 12

You just added this field to the Columns shelf.

What will this create?

A.

A vertical header

B.

A horizontal axis

C.

A vertical axis

D.

A horizontal header

Full Access
Question # 13

Which two types of aggregations can be applied to string fields? Choose two.

A.

Sum

B.

Count Distinct

C.

Average

D.

Minimum

Full Access
Question # 14

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

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.

Full Access
Question # 15

What does the box in a box plot represent?

A.

Maximum value of the data

B.

Minimum value of the data

C.

The interquartile range

D.

The median of the middle half of the data points

Full Access
Question # 16

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

A.

False

B.

True

Full Access
Question # 17

If you use a percent difference Quick Table Calculation, what value will be the first data value?

A.

null

B.

-1

C.

0000

D.

0

Full Access
Question # 18

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

A.

Hide all unused fields.

B.

Aggregate data for visible dimensions

C.

Compute Calculations Now.

D.

Append Data from Files

E.

Apply a filter.

Full Access
Question # 19

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?

A.

Measure Filters

B.

Context Filters

C.

Extract Filters

D.

Dimension Filters

Full Access
Question # 20

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

A.

Multiple Values (drop-down)

B.

At most

C.

Wildcard Match

D.

Range of Values

Full Access
Question # 21

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

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.

Full Access
Question # 22

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.

A.

reversed

B.

stepped

C.

diverging

D.

converging

Full Access
Question # 23

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

A.

Data Cleanliness

B.

Data granularity

C.

Data connectivity

D.

Data LOD

Full Access
Question # 24

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

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

Full Access
Question # 25

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

A.

Data cleaner

B.

Data manager

C.

Data interpreter

D.

Data organiser

Full Access
Question # 26

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

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.

Full Access
Question # 27

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

A.

CSV file

B.

PDF File

C.

JSON format

D.

MS Access Database

Full Access
Question # 28

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

A.

20,000

B.

5,000

C.

10,000

D.

15,000

Full Access
Question # 29

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

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.

Full Access
Question # 30

You create a visualization by first adding a measure to rows. Next, you add a dimension wilh 11 members to columns.

Assuming that all the dimensions have a non-zero value, how many marks are in the view before and after the dimension is added?

A.

1 before and 2 after

B.

1 before and 12 after

C 1 before and 11 after

C.

2 before and 11 after

Full Access
Question # 31

Which of the following are valid use-cases for the 'Manage Metadata' functionality?

A.

To clean and automatically fix the data issues in our data source

B.

To see the field name in the original data source

C.

To view all hidden fields

D.

To see the table a field belongs to

Full Access
Question # 32

If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

A.

Improve query performance

B.

To make the context filter a dependent filter

C.

To help clean the data

D.

To include only the data of interest

Full Access
Question # 33

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

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

Full Access
Question # 34

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

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.

Full Access
Question # 35

Which aggregation is available without requiring a table calculation or calculated field?

A.

Running total

B.

Standard deviation

C.

Sample covariance

D.

Percent of total

Full Access
Question # 36

What does the following icon do in Tableau?

Larger image

A.

Create a Story

B.

Create a Story and Dashboard both

C.

Create a Worksheet

D.

Create a Dashboard

Full Access
Question # 37

If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

A.

sort the measures

B.

disaggregate the measures

C.

break-down the measures

D.

aggregate the measures

E.

split the measures

Full Access
Question # 38

Which of the following would you use to edit the Shape, colour, and Text of your visualisations?

A.

Marks Card

B.

Data Pane

C.

Filter Shelf

D.

Analytics Pane

Full Access
Question # 39

A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

A.

Go to Hyperlink

B.

Go to Web page

C.

Go to URL

D.

Go to Sheet

Full Access
Question # 40

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 https://en.wikipedia.org/wiki/ as the URL target.

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

Full Access
Question # 41

When is an axis created for the visualisation in Tableau?

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

Full Access
Question # 42

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?

A.

An alias

B.

A header label

C.

A hierarchy

D.

A default comment

Full Access
Question # 43

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

A.

1 , 4

B.

2 , 2

C.

2 , 3

D.

1 , 2

Full Access
Question # 44

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.

A.

Regex Search

B.

Union Search

C.

Pattern Search

D.

Wildcard Search

Full Access
Question # 45

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

A.

Measure Names

B.

Number of Records

C.

Measure Values

D.

Calculated Fields

Full Access
Question # 46

In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.

A.

An incremental refresh only adds rows that are new

B.

A full refresh must be configured. An incremental refresh is the default extract in Tableau.

C.

An incremental refresh can only be run from Tableau Server.

D.

A full refresh is usually very slow. An incremental refresh can take less time.

E.

A full refresh replaces all the extracted data with the data in the underlying data source.

Full Access
Question # 47

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

A.

.tds

B.

.tdex

C.

.hyper

D.

.twbx

Full Access
Question # 48

Which three statements accurately describe dimensions? Choose three.

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

Full Access
Question # 49

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?

A.

0.783262

B.

0.739284

C.

0.759329

D.

0.748472

Full Access
Question # 50

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

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.

Full Access
Question # 51

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

A.

Layout Extensions

B.

Layout Blanks

C.

Layout Containers

D.

Layout positioners

Full Access
Question # 52

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

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.

Full Access
Question # 53

Are animations enabled by default in Tableau?

A.

No

B.

Yes

Full Access
Question # 54

What is created by a calculated field that has a formula of SUM(Sales)/SUM(Profit)?

A.

A parameter

B.

A measure

C.

A dimension

D.

A set

Full Access
Question # 55

How would you calculate GDP per capita in Tableau?

A.

SUM([GDP]/[POPULATION])

B.

SUM([Population]/[GDP]])

C.

SUM([GDP]*[POPULATION])

D.

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

Full Access
Question # 56

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

A.

Forecast

B.

Totals IS

C.

Reference lines

D.

Trend lines

Full Access
Question # 57

Which of the following is NOT a valid official data source in Tableau Desktop?

A.

PostgreSQL

B.

SAP HANA

C.

Google Firebase

D.

Amazon Redshift

Full Access
Question # 58

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

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.

Full Access
Question # 59

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

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.

Full Access
Question # 60

Which of the following sets would you use to compare the members?

A.

None of these

B.

Dynamic Sets

C.

Static Sets

D.

Combined Sets

Full Access
Question # 61

In which situation should you save a workbook as a PDF document?

A.

Your users have Tableau Desktop but not Tableau Reader.

B.

You want document users to be able to filter and sort the views.

C.

Your analysis does not require a live connection to a data source.

D.

You need paper copies of the workbook.

Full Access
Question # 62

When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

A.

Remote Field Name, Field Name

B.

Local Name, Actual Name

C.

Column Name, Actual Name

D.

Local Field, Global Field

Full Access
Question # 63

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

A.

parameters

B.

sets

C.

values

D.

inputs

Full Access
Question # 64

When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

A.

Data source Filter

B.

Extract Filter

C.

Context Filter

D.

None of the these

Full Access
Question # 65

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

A.

SMTP

B.

FTP

C.

HTTPS

D.

HTTP

Full Access
Question # 66

Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

A.

111,060

B.

1,461

C.

112,256

D.

1,222

Full Access
Question # 67

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

Larger image

A.

Grouped Dates

B.

Date Functions

C.

Date Parts

D.

Date Values

Full Access
Question # 68

For which of the following charts, does the Size option on the Marks card not work?

A.

Gantt Chart

B.

Bar Chart

C.

Tree Map

D.

Pie Chart

Full Access
Question # 69

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?

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

Full Access
Question # 70

For a relative date filter, the default anchor is _________________

A.

The current time

B.

Today's date

C.

The target date

D.

The date we specify

Full Access
Question # 71

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

A.

Tom Ashbrook

B.

Sanjit Engle

C.

Penelope Sewall

D.

Tamara Chand

Full Access
Question # 72

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

A.

Spatial

B.

Excel

C.

Text

D.

JSON

Full Access
Question # 73

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

A.

Bins

B.

Groups

C.

Hierarchies

D.

Sets

Full Access
Question # 74

Which of the following are True for Measure Names?

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.

Full Access
Question # 75

How does Tableau know at which level to aggregate values?

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

Full Access
Question # 76

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)

A.

76.25

B.

65.67

C.

68.77

D.

4.87

Full Access
Question # 77

While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.

A.

padding

B.

margining

C.

tiling

D.

spacing

Full Access
Question # 78

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

A.

.tbm

B.

.tds

C.

.tde

D.

.twb

Full Access
Question # 79

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

A.

True

B.

False

Full Access
Question # 80

Which statement accurately describes creating a group by selecting headers in a view?

A.

A new group updates the aliases from the selected headers.

B.

The grouped dimension is added to Color.

C.

The grouped dimension replaces the original dimension field on Rows or Columns.

D.

A newly created group only exists in the current view.

Full Access
Question # 81

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

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

Full Access
Question # 82

_______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

A.

Tableau Server

B.

Tableau Prep

C.

Tableau Public

D.

Tableau myServer

Full Access
Question # 83

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

A.

Dimensions and Measures

B.

Rows and Columns

C.

Labels and Values

D.

Numbers and Headers

Full Access
Question # 84

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

A.

True

B.

False

Full Access
Question # 85

Which of the following calculations DO NOT need a quick table calculation?

A.

Variance

B.

Rank

C.

Moving Average

D.

Standard Deviation

Full Access
Question # 86

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?

A.

$16,581

B.

(Correct)

C.

$147,950

D.

$48,115

E.

$33,768

Full Access
Question # 87

You can create _______________ for members in a dimension so that their labels appear differently in the view.

A.

parameters

B.

duplicates

C.

copies

D.

aliases

Full Access
Question # 88

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

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

Full Access
Question # 89

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

A.

0.4s

B.

0.3s

C.

0.5s

D.

0.2s

Full Access
Question # 90

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?

A.

October

B.

September

C.

July

D.

June

Full Access
Question # 91

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

A.

Pareto Chart

B.

Pie Chart

C.

Gantt Chart

D.

Stacked Bar Chart

Full Access
Question # 92

For creating variable sized bins we use __________________

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Full Access
Question # 93

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

A.

Portable Network Graphic (.PNG)

B.

JPEG Image (.JPG, .JPEG)

C.

Tagged Image File Format (TIFF)

D.

Windows Bitmap (.BMP)

Full Access
Question # 94

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

A.

Profit, State, Number of Records, Sales

B.

Region, Country, Profit, State

C.

Longitude, Country, State, Sales

D.

Sales, State, Country, Profit

Full Access