Summer Special Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

Welcome To DumpsPedia

Desktop-Specialist Sample Questions Answers

Questions 4

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 5

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

Buy Now
Questions 6

How can you change the default Tableau repository location?

Options:

A.

By clicking on Window -> Repository Location

B.

By clicking on Help -> Change Repository Location

C.

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

D.

By Moving the repository location manually to wherever we want

Buy Now
Questions 7

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.

Buy Now
Questions 8

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 9

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 10

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 11

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

Options:

A.

A parameter

B.

A measure

C.

A dimension

D.

A set

Buy Now
Questions 12

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

Buy Now
Questions 13

Data blending simulates a traditional _________________ Join

Options:

A.

Inner

B.

Right

C.

Full Outer

D.

Left

Buy Now
Questions 14

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

Buy Now
Questions 15

_________________ are 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.

Options:

A.

.twb files

B.

.tbm files

C.

.twbx files

D.

.tde files

Buy Now
Questions 16

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 17

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 18

When viewing quick table calculations, such as Percent Difference From, that use a value in the previous column, what will be the first data value in the visualization?

Options:

A.

Null

B.

The current value

C.

Zero(O)

D.

Duplicated from the nearest column

Buy Now
Questions 19

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.

Options:

A.

Remote Field Name, Field Name

B.

Local Name, Actual Name

C.

Column Name, Actual Name

D.

Local Field, Global Field

Buy Now
Questions 20

A Tableau Support case can be opened in which of the following valid ways?

Options:

A.

Using the Developer Community Forum

B.

Contacting Salesforce using their website

C.

Using the support option on the Tableau website

D.

Using the Tableau learn website

Buy Now
Questions 21

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

Buy Now
Questions 22

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 23

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

Options:

A.

Clustering

B.

Grouping

C.

Sets

D.

Union

Buy Now
Questions 24

How do you identify a continuous field in Tableau?

Options:

A.

It is identified by a blue pill in the visualization

B.

It is identified by a green pill in a visualization

C.

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

D.

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

Buy Now
Questions 25

Which of the following can you use to create a Histogram?

Options:

A.

2 measures

B.

1 measure

C.

2 dimensions

D.

1 dimension

Buy Now
Questions 26

Question 45: Skipped

You have just created a histogram and now want to be able to change the size of bins dynamically. Using which of the following will easily satisfy your requirement?

Options:

A.

Sets

B.

Groups

C.

Calculation

D.

Parameters

Buy Now
Questions 27

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 28

For Bullet Graphs we need at least ____________ measures

Options:

A.

3

B.

1

C.

2

D.

4

Buy Now
Questions 29

True or False: The Highlighting action can be disabled for the entire workbook.

Options:

A.

True

B.

False

Buy Now
Questions 30

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

Buy Now
Questions 31

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 32

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 33

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 34

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 35

For creating variable sized bins we use __________________

Options:

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Buy Now
Questions 36

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
Questions 37

Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.

How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

Options:

A.

1

B.

2

C.

3

D.

4

Buy Now
Questions 38

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?

Options:

A.

Data source Filter

B.

Extract Filter

C.

Context Filter

D.

None of the these

Buy Now
Questions 39

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

Buy Now
Questions 40

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

Options:

A.

True

B.

False

Buy Now
Questions 41

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

Buy Now
Questions 42

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

Buy Now
Questions 43

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 44

True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.

Options:

A.

True

B.

False

Buy Now
Questions 45

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

Buy Now
Questions 46

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

Buy Now
Questions 47

True or False: Sets can be created on Measures

Options:

A.

True

B.

False

Buy Now
Questions 48

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

Buy Now
Questions 49

_________________ 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

Buy Now
Questions 50

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.

Buy Now
Questions 51

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.

Buy Now
Questions 52

______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Options:

A.

Joining

B.

Blending

C.

Combining

D.

Unioning

Buy Now
Questions 53

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

Options:

A.

Tableau Server

B.

Tableau Prep

C.

Tableau Public

D.

Tableau myServer

Buy Now
Questions 54

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.

Buy Now
Questions 55

Is it possible to make a Measure discrete?

Options:

A.

No

B.

Yes

Buy Now
Questions 56

What will the following function return?

LEFT("Tableau", 3)

Options:

A.

An error

B.

Tab

C.

eau

D.

ble

Buy Now
Questions 57

Which two functionalities can you provide to consumers by adding a parameter to a visualization? Choose two.

Options:

A.

Change fields in the visualization.

B.

Download the underlying data as a CSV file.

C.

Change the results of calculations in the visualization.

D.

Create a new field in the data source.

Buy Now
Questions 58

By definition, Tableau displays measures over time as a ____________

Options:

A.

Packed Bubble

B.

Bar

C.

Stacked Bar

D.

Line

Buy Now
Questions 59

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 60

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

Options:

A.

Gantt Chart

B.

Bullet chart

C.

Histogram

D.

Treemaps

Buy Now
Questions 61

A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don’t have access to the original data.

Options:

A.

.twbx file

B.

.tbm file

C.

.twb file

D.

.tde file

Buy Now
Questions 62

Which two actions can you perform when you join tables from multiple connections? Choose two.

Options:

A.

Create a union.

B.

Use a stored procedure.

C.

Add a data source filter.

D.

Create an extract.

Buy Now
Questions 63

Options:

A.

Bullet

B.

Line

C.

Gantt

D.

Area

Buy Now
Questions 64

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 65

You are creating a combined axis chart.

Where should you drag the second measure after dragging the first measure to the Rows shelf?

Options:

A.

The Filter card

B.

The vertical axis in the view

C.

The Marks card

D.

The horizontal axis in the view

Buy Now
Questions 66

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

Buy Now
Questions 67

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 68

Which one of the following is a dimension?

Options:

A.

Longitude

B.

Measure Names

C.

Number of records

D.

Latitude

Buy Now
Questions 69

What are two outcomes when you drag a continuous date value to the Rows shelf? Choose two,

Options:

A.

The pill on the Rows shelf is green.

B.

The pill on the Rows shelf is blue.

C.

A quantitative axis is shown.

D.

The date part Is displayed as labels.

Buy Now
Questions 70

What do the colours Blue and Green represent in Tableau?

Options:

A.

Discrete and Continuous

B.

Measures and Dimensions

C.

Continuous and Discrete

D.

Dimensions and Measures

Buy Now
Questions 71

You just added this field to the Columns shelf.

What will this create?

Options:

A.

A vertical header

B.

A horizontal axis

C.

A vertical axis

D.

A horizontal header

Buy Now
Questions 72

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.

Buy Now
Questions 73

For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Options:

A.

Random

B.

Manual

C.

Topological

D.

Hierarchical

Buy Now
Questions 74

Dates in Tableau are typically treated as ______________

Options:

A.

Dimensions

B.

Measures

Buy Now
Questions 75

You have a data set that builds a union between two tables. You need to extract the data set. What should you use to extract the data set?

Options:

A.

physical tables that use a single table extract

B.

physical tables that use multiple table extracts

C.

logical tables that use a single table extract

D.

logical tables that use multiple table extracts

Buy Now
Questions 76

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 77

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

Buy Now
Questions 78

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 79

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

Options:

A.

null

B.

-1

C.

0000

D.

0

Buy Now
Questions 80

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.

Buy Now
Questions 81

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

Options:

A.

PostgreSQL

B.

SAP HANA

C.

Google Firebase

D.

Amazon Redshift

Buy Now
Questions 82

What does the box in a box plot represent?

Options:

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

Buy Now
Questions 83

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

Buy Now
Questions 84

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

Buy Now
Questions 85

Which of the following are correct ways to define a join in Tableau version 2020.3 and above?

Options:

A.

Right-click a logical table and click on open to go to the Join/Union canvas in the physical layer and add joins or unions.

B.

Double-click a physical table to go to the Join/Union canvas in the logical layer and add joins or unions.

C.

Right-click a physical table and click on open to go to the Join/Union canvas in the logical layer and add joins or unions.

D.

Double-click a logical table to go to the Join/Union canvas in the physical layer and add joins or unions.

Buy Now
Questions 86

Which of the following is a good reason for using a bullet graph?

Options:

A.

Comparing the actual sales against the target sales

B.

Analysing the trend over a given time period

C.

Forecasting future sales

D.

Displaying the year-on-year growth in sales

Buy Now
Questions 87

______________ 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

Buy Now
Questions 88

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)

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

Buy Now
Questions 91

You create the following visualization.

What is the first step to create the visual grouping of the 10 marks shown in blue?

Options:

A.

Select the desired 10 marks in the view.

B.

Create a Group on the Property Description field in the Data pane.

C.

Select the desired 10 text labels under Property Description.

D.

Create a Set on the Neighborhood field in the Data pane.

Buy Now
Questions 92

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

Options:

A.

True

B.

False

Buy Now
Questions 93

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.

Buy Now
Questions 94

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

Buy Now
Exam Code: Desktop-Specialist
Exam Name: Tableau Desktop Specialist Exam
Last Update: Jun 18, 2024
Questions: 314
$64  $159.99
$48  $119.99
$40  $99.99
buy now Desktop-Specialist