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

Exact2Pass Menu

Question # 4

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

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

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?

A.

October

B.

September

C.

July

D.

June

Full Access
Question # 7

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

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

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

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

Full Access
Question # 10

How can you change the default Tableau repository location?

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

Full Access
Question # 11

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

Which of these is NOT a type of Quick Filter available in Tableau?

A.

Wildcard Match

B.

Multiple Values (dropdown)

C.

Regex Match

D.

Single Value (slider)

Full Access
Question # 13

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

A.

join

B.

blend

C.

concatenate

D.

union

Full Access
Question # 14

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

A.

Discrete value, Continuous Value

B.

Geographic Value, Discrete Value

C.

Continuous Value, Discrete Value

D.

Longitude, Latitude

Full Access
Question # 15

Which type of filter affects a fixed Level of Detail (LOD) expression?

A.

Table calculation filter

B.

Measure filter

C.

Context filter

D.

Dimension filter

Full Access
Question # 16

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

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.

Full Access
Question # 17

Which statement accurately describes a join?

A.

Away to combine multiple Tableau workbooks using similar data sources

B.

A combination of rows appended from different tables that have the same column names

C.

Away to combine table columns in relational databases by using shared values

D.

A combination of columns appended from different tables that have similar values

Full Access
Question # 18

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

_________________ 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

A.

Union

B.

Data Joining

C.

Data segregation

D.

Data Blending

Full Access
Question # 20

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

How can you format an axis as Bold in Tableau?

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.

Full Access
Question # 22

Using the CoffeeChain table, create a chart to see the monthly Percent difference change in Profit, from the beginning of 2012 to the end of 2013. How many months saw a Negative percent difference in Profit?

A.

9

B.

7

C.

10

D.

8

Full Access
Question # 23

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

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

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

A.

Groups

B.

Calculated Fields

C.

Measures

D.

Dimensions

Full Access
Question # 26

_____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

A.

Tableau Data Extract (.tde)

B.

Tableau Packaged Workbook (.twbx)

C.

Tableau Bookmark (.tbm)

D.

Tableau Workbook (.twb)

Full Access
Question # 27

Which statement accurately describes aliases?

A.

You can create an alias for a discrete measure.

B.

You can create an alias for a continuous dimension.

C.

When you assign an alias, the name changes in the database.

D.

You can assign an alias to a field member before creating a visualization.

Full Access
Question # 28

For creating variable sized bins we use __________________

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Full Access
Question # 29

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

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

According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

A.

Dimension Filter

B.

Measure Filter

C.

Context Filter

D.

Extract Filter

Full Access
Question # 32

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

A.

8GB

B.

16GB

C.

32GB

D.

64GB

Full Access
Question # 33

Which of the following are FALSE about Joins?

A.

Joins can be defined at the time of query dynamically

B.

May drop unmatched measure values

C.

They are displayed with Venn diagram icons between physical tables

D.

Joined tables are never merged into a single table.

E.

They are a more dynamic way than relationships to combine data

Full Access
Question # 34

What are two requirements to combine two tables by using a union? Choose two.

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.

Full Access
Question # 35

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

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

A.

Region, Country, Profit, State

B.

Sales, State, Country, Profit

C.

Profit, State, Number of Records, Sales

D.

Longitude, Country, State, Sales

Full Access
Question # 37

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

A.

Gantt Chart

B.

Bullet chart

C.

Histogram

D.

Treemaps

Full Access
Question # 38

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

A.

the full color range

B.

a diverging palette

C.

a sequential palette

D.

a categorical palette

Full Access
Question # 39

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

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

Full Access
Question # 40

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

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

A.

Default Field Properties

B.

Copy of any local file-based data

C.

Calculated Fields

D.

Data Source Type

Full Access
Question # 42

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

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

The calculation [Ship Date] - [Order Date] will return _______________

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

Full Access
Question # 45

Which mark type is used in a highlight table?

A.

Text

B.

Square

C.

Polygon

D.

Area

Full Access
Question # 46

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

How can you format numbers in Tableau as currency?

A.

Right-click a measure or axis in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

B.

Right-click on the data source used in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

C.

Right-click a dimension in the view and select Format. Then in the Format pane, click the Numbers drop-down menu.

D.

Right-click on the Sheet name and select Format. Then in the Format pane, click the Numbers drop-down menu.

Full Access
Question # 48

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

You create the following visualization.

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

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.

Full Access
Question # 50

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

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.

A.

True

B.

False

Full Access
Question # 52

What is the default behavior of Tableau when you add a measure to the view?

A.

You are prompted to add an aggregation.

B.

An aggregation is applied that is independent of the context of the view.

C.

The measure is added disaggregated.

D.

An aggregation is applied that varies depending on the context of the view.

Full Access
Question # 53

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

Dates in Tableau are typically treated as ______________

A.

Dimensions

B.

Measures

Full Access
Question # 55

You want to save a view as an image that you can paste into a Microsoft Word document. Which two statements accurately describe exporting a view as an image? Choose two.

A.

Default exports include everything in the view, including Tableau fonts.

B.

The default export format is TIFF.

C.

The default export format is PNG.

D.

The exported image is a vector-based file that embeds the Tableau fonts.

Full Access
Question # 56

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

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

A.

2 measures

B.

1 measure

C.

2 dimensions

D.

1 dimension

Full Access
Question # 58

How can you create a packaged data source?

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.

Full Access
Question # 59

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

A.

True

B.

False

Full Access
Question # 60

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

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

Dimensions containing ____________ and ____________  values cannot be continuous.

A.

Boolean

B.

Date

C.

Date and Time

D.

String

Full Access
Question # 63

Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

A.

Yes

B.

No

Full Access
Question # 64

Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system’s web browser?

A.

YES, we can do this with the help of a plugin

B.

NO, this is not currently possible in Tableau

C.

YES, we can do this with the help of a Web-Page object

D.

YES, we can do this with the help of Tableau Public

Full Access
Question # 65

True or False: Trend lines can only be used with numeric or date fields

A.

True

B.

False

Full Access
Question # 66

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

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

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

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

You want to update the font of an entire workbook.

What should you use to configure the default fonts?

A.

The Formal Font pane

B.

The Format Workbook pane

C.

Field labels

D.

Titles and captions

Full Access
Question # 71

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

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

True or False: Sets can be created on Measures

A.

True

B.

False

Full Access
Question # 74

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

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.

Full Access
Question # 75

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

A.

Profit

B.

Names

C.

Categories

D.

Sales

Full Access
Question # 76

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

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

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

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

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

A.

Boolean

B.

String

C.

Date

D.

Numeric

Full Access
Question # 81

Tableau will automatically create a hierarchy for which two kinds of data? Choose two.

A.

Date & Time

B.

Date

C.

Geographic

D.

String

Full Access
Question # 82

True or False: Context Filters are executed after Data Source filters

A.

True

B.

False

Full Access
Question # 83

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

How can you change the Default Aggregation for a measure in Tableau?

A.

By changing its properties manually every time we need to use it

B.

By right clicking the dimension -> Default properties and choosing Aggregation

C.

By right clicking the measure -> Default properties and choosing Aggregation

D.

By double clicking on the measure, and then choosing Window -> Default Aggregation

Full Access
Question # 85

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

A.

Dynamic Paramaters

B.

Viz Animations

C.

Buffer Calculations

D.

Set Control

Full Access
Question # 86

What is the one critical difference between normal calculated fields, and the calculated fields created after Data blending?

A.

No difference, calculated fields cannot be created in Blends

B.

Fields used in Blends must first be aggregated

C.

The calculated fields created in Blends cannot be edited once created

D.

The calculated fields created in Blends cannot use more than 2 fields

Full Access
Question # 87

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

True or False: Tableau can create worksheet-specific filters

A.

True

B.

False

Full Access
Question # 89

You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

A.

Save it as a .twm file

B.

Save it as a .twb file

C.

Save it as a .tds file

D.

Save it as a .twbx file

Full Access
Question # 90

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

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

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

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

A.

role, type

B.

Data type, Value

C.

type, role

D.

dimension, measure

Full Access
Question # 94

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