Weekend Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

Desktop-Specialist Questions and Answers

Question # 6

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

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

By definition, Tableau displays measures over time as a ____________

A.

Packed Bubble

B.

Bar

C.

Stacked Bar

D.

Line

Full Access
Question # 9

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

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

Full Access
Question # 10

Which of the following is a discrete date part?

A.

07Mar20l7

B.

20Sep2016:9:8:8:6546

C.

01/23/2021

D.

February

Full Access
Question # 11

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

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

Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

A.

If we want a static view of the visualisation.

B.

If we want to use filters in the visualisation.

C.

If we want to interact with the visualisation.

D.

If we want to dynamically enter parameters to the visualisation.

Full Access
Question # 14

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

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

A.

The Color legend

B.

Edit in Shelf

C.

The Format menu

D.

Edit Caption

Full Access
Question # 15

You have a visualization that uses multiple types of sorting.

How can you clear all sorting of the visualization?

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.

Full Access
Question # 16

The row and column shelves contain ___________________

A.

Pills

B.

Grand Totals

C.

Filters

D.

Parameters

Full Access
Question # 17

We can join a maximum of ______ tables in Tableau

A.

16

B.

32

C.

64

D.

128

Full Access
Question # 18

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

Using the cwurData table, create a cross-tab showing the number of Publications per Country broken down by Institution, and filtered by Country to only show United Kingdown (UK). For the University of Manchester, what percent of the total publications were contributed in 2014?

A.

28.415%

B.

23.497%

C.

25.683%

D.

22.404%

Full Access
Question # 20

You have a continuous numeric measure named Sales.

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

A.

A text table

B.

A line chart

C.

A pie chart

D.

A bar chart

Full Access
Question # 21

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

What is a Tableau story point?

A.

The pane where you set the size of the story

B.

A collection of talking points to drive the story

C.

An individual sheet or dashboard in the story

D.

A collection of sheets arranged in a sequence

Full Access
Question # 23

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

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
Question # 25

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?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 26

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

Which of the following are valid ways to make the font more readable in Tableau?

A.

Decrease the font size

B.

Don't use backgrounds

C.

use a clear and readable font

D.

Make the Font color sharper / darker than the background

E.

Increase the font size

Full Access
Question # 28

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

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

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

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

A.

592,593

B.

293,202

C.

416,702

D.

336,908

Full Access
Question # 32

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

A.

Yes

B.

No

Full Access
Question # 33

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

A.

False

B.

True

Full Access
Question # 34

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

A.

is always sum

B.

depends on the context of the view

C.

is always COUNT

D.

is always AVERAGE

Full Access
Question # 35

For creating variable sized bins we use __________________

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Full Access
Question # 36

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

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.

Full Access
Question # 37

Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf. Which of the following would create a stacked bar chart?

A.

By dragging another dimension to the Rows shelf

B.

By dragging another measure to Color on the Marks card

C.

By dragging another dimension to Color on the Marks card

D.

By dragging another measure to the Columns shelf

Full Access
Question # 38

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.

A.

96.46%

B.

95.12%

C.

97.12%

D.

99.46%

Full Access
Question # 39

A union of two tables usually results in  an 

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

Full Access
Question # 40

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

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

A.

Side-by-side circles

B.

Scatter plots

C.

Heat maps

D.

Packed bubbles

Full Access
Question # 42

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

A.

True

B.

False

Full Access
Question # 43

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

You have the following visualization.

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

A.

Path on the Marks card

B.

Color on the Marks card

C.

The Columns shelf

D.

The Rows shelf

Full Access
Question # 45

Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

A.

No

B.

Yes

Full Access
Question # 46

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

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.

Full Access
Question # 47

Which of the following points are True about Viz Animations?

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

Full Access
Question # 48

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?

A.

1

B.

2

C.

3

D.

4

Full Access
Question # 49

Which of the following is not a Trend Line Model?

A.

Linear Trend Line

B.

Exponential Trend Line

C.

binomial Trend Line

D.

Logarithmic Trend Line

Full Access
Question # 50

Which of the following can help us focus on specific data without removing data in the visualization?

A.

Highlighters

B.

Sets

C.

Clusters

D.

Filters

Full Access
Question # 51

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

A.

Gantt Chart

B.

Bullet chart

C.

Histogram

D.

Treemaps

Full Access
Question # 52

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

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

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

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

What should you use to create headers in a visualization?

A.

A parameter

B.

A measure

C.

A dimension

D A filter

Full Access
Question # 57

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

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

Full Access
Question # 58

What will the following function return?

LEFT("Tableau", 3)

A.

An error

B.

Tab

C.

eau

D.

ble

Full Access
Question # 59

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?

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

Full Access
Question # 60

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

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

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

A.

Profit / Sales

B.

Sales / Profit

C.

SUM(Profit) / SUM(Sales)

D.

SUM(Sales)/SUM(Profit)

Full Access
Question # 63

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

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

A.

URL Action

B.

Filter Action

C.

Highlight Action

D.

Edit Tooltip Action

Full Access
Question # 65

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

A.

True

B.

False

Full Access
Question # 66

You are creating a combined axis chart.

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

A.

The Filter card

B.

The vertical axis in the view

C.

The Marks card

D.

The horizontal axis in the view

Full Access
Question # 67

What two methods can you use to change the font of a worksheet title? Choose two.

A.

Double-click the title in a particular view and use the dialog box.

B.

Right-click the title in a view, and then select Format Title.

C.

Select Format on the menu, and then select Font.

D.

Select Format on the menu, and then select Title and Caption.

Full Access
Question # 68

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

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

Larger image

A.

View Data

B.

Clean Data

C.

Extract Data

D.

Sort Data

Full Access
Question # 70

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 71

Which of the following are valid Dashboard size options?

A.

Range

B.

Fixed Size

C.

Automatic

D.

Scaled

Full Access
Question # 72

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

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

A.

True

B.

False

Full Access
Question # 74

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

A.

Treemaps

B.

Pie charts

C.

Histograms

D.

Area charts

Full Access
Question # 75

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

A.

68,620

B.

74,683

C.

37,455

D.

46,493

Full Access
Question # 76

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

A.

Reversed

B.

Opacity

C.

Border

D.

Stepped Color

Full Access
Question # 77

What is a story point in Tableau?

A.

A single worksheet or dashboard

B.

A collection of dashboards

C.

A collection of both worksheets and dashboards

D.

A collection of worksheets

Full Access
Question # 78

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

A.

It is continuous

B.

It is discrete

C.

It is a dimension

D.

It is a measure

Full Access
Question # 79

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

A.

Groups

B.

Calculated Fields

C.

Measures

D.

Dimensions

Full Access
Question # 80

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

A.

True

B.

False

Full Access
Question # 81

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

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

A.

A PDF copy of the workbook

B.

Background images

C.

Tableau Datasource Customization (TDC) files

D.

Extract files

E.

Custom shapes

Full Access
Question # 83

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

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

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

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

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

A.

Hide the axis

B.

Change the colours

C.

Synchronise the axis

D.

Edit the labels

Full Access
Question # 88

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

You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals.

What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?

A.

Include an Other group.

B.

Include the Summary card.

C.

Color encode the hotel chain names.

D.

Create a new view.

Full Access
Question # 90

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

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

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

A.

Boolean

B.

String

C.

Date

D.

Numeric

Full Access
Question # 93

Which of the following are true about dimensions?

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

Full Access
Question # 94

At a minimum, what do you need to create a simple scatter plot?

A.

A measure on Columns and a measure on Rows

B.

A dimension on Detail and a measure on Columns

C.

A dimension on Columns and a measure on Rows

D.

A dimension on Columns and a dimension on Rows

Full Access