Knowledge Based Questions

Question 1

To connect to multiple tables in a single data source at one time, what must be specified?

Answer 1

A join

Question 2

Tableau can create worksheet-specific filters

Answer 2

True

Question 3

What does the box in a box plot represent

Answer 3

The range of the middle half of the data points

Question 4

The interquartile range is the difference between the 2nd and 3rd quantiles

Answer 4

False

Question 5

The median is the number separating the lower half of the data from the higher half. It is the same as the 50th percentile or the 2nd quartile.

Answer 5

True

Question 6

The calculation [ship date] - [order date] will return

Answer 6

Number of days between them

Question 7

What is wrong with this if statement:

IF Sales > 100 AND “Delivery Truck” THEN 0 END

Answer 7

There should be a clause for “Delivery Truck” e.g.

[shipping mode] = “Delivery Truck”

Question 8

What will the function LEFT(3, “Tableau”) return?

Answer 8

Error

Question 9

All rows from both tables are returned in an INNER JOIN

Answer 9

False

Question 10

LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Answer 10

True

Question 11

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.

Answer 11

True

Question 12

The term “addressing” refers to the direction of a calculation

Answer 12

True

Question 13

SUM is a table calculation

Answer 13

False

Question 14

The benefits of creating a Tableau data extract include improving performance and allowing offline access to the data

Answer 14

True

Question 15

The metadata grid displays the fields in your data source in columns

Answer 15

False

Question 16

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

Answer 16

Clustering

Question 17

Which of the following is used to assess trend line significance

Answer 17

p-value

Question 18

If you would like your Top N or Bottom N set to change depending on what filter choices are changed, what type of filter should use?

Answer 18

Context filters

Question 19

Sorts can break the dimension hierarchy. In other words, Tableau will rearrange any the headers of the fields that appear to the left of the sorted field.

Answer 19

False

Question 20

Which of the following are generated fields in Tableau?

Answer 20

Number of Records, Measure Names, Measure Values, Longitude & Latitude

Question 21

Pareto charts combine the following element

Answer 21

…

Question 22

Bullet graphs combine bar charts and reference lines

Answer 22

True

Question 23

You want to email a packaged workbook containing a Tableau dashboard to a coworker who does not have a license for Tableau Desktop. Which application will allow her to view the dashboard you send via email?

Answer 23

Tableau reader

Question 24

A visual best practice is that if you are using a colour gradient to represent a continuous variable which can be negative or positive, you could use a single colour range

Answer 24

False

Question 25

The AVG function does nit treat null values as zeros. Rather, the AVG function ignores null values.

Answer 25

TRUE

Question 26

An aggregated calculation can be multiplied by a non-aggregated constant

Answer 26

True

Question 27

When using a ____ join the result is a table that contains all values from the LEFT table and corresponding matches from the right table.

Answer 27

LEFT JOIN

Question 28

If you see duplicate data after doing a join you may be able to eliminate the duplication by which of the following?

Answer 28

Change the join condition

Question 29

______ is a tendency to increase or decrease over time

Answer 29

Trend

Question 30

Which of the following graph types provide information on the distribution of a continuous measure?

Answer 30

Box Plot

Question 31

Positive Skewness means the extreme values are to the right, while negative skewness means the extreme values are to the left.

Answer 31

True

Question 32

When you sort data in a hierarchy, Tableau rearranges headers that appear before the sorted field.

Answer 32

False

Question 33

Context filters are executed after data source filters

Answer 33

True

Question 34

Tableau displays an axis when you drop this onto the Rows or Columns shelf.

Answer 34

Continuous field, Measure values

Question 35

Gantt charts are useful for

Answer 35

Displaying duration of events or activities over time

Question 36

Bins acts as a containers that summarise data for a specific range of values. Without using a calculated field, Tableau’s bin feature allows you to create variable sized bins.

Answer 36

False

Question 37

You can combine multiple worksheets in a single dashboard

Answer 37

True

Question 38

If a dashboard is difficult to view on a smartphone, you can use the ____ designer to create a phone-specific view of your dashboard

Answer 38

Device designer

Question 39

A ____ action allows Tableau to open a page on an external website

Answer 39

URL

Question 40

To connect to multiple tables in a single data source at one time, what must be specified.

Answer 40

A JOIN

Question 41

What is the use of data interpreter option in Tableau

Answer 41

To structure the unstructured data

Question 42

While using custom SQL option during data connection, which options get disable/removed from data page?

Answer 42

Data Interpreter and Union

Question 43

When to use extract option in Tableau

Answer 43

When you want to embed data inside Tableau file AND when you want to share the file without sharing the data connection information

Question 44

To add cross data source join _____ must be specified

Answer 44

Primary and foreign key

Question 45

If I changed the layout of worksheet from standard to fit entire view and next I changed the chart using show me, what will be the layout of the worksheet?

Answer 45

Standard

Question 46

What is the correct way to calculate price of a product?

Answer 46

SUM(sales/quantity)

Question 47

Which columns you cannot delete in Tableau

Answer 47

Measure Names and Measure Values

Question 48

You cannot change a dimension to continuous

Answer 48

True

Question 49

You cannot create bins of measures

Answer 49

False

Question 50

Latitude and longitude are Tableau generated fields

Answer 50

True

Question 51

We can use measure names in creating custom column

Answer 51

False

Question 52

For bullet graph, you need ____ dimensions

Answer 52

0 or more

Question 53

For creating line chart, what is required

Answer 53

Continuous field

Question 54

What is the colour of attribute in Tableau?

Answer 54

Blue

Question 55

In shelf calculated columns are ______

Answer 55

Worksheet specific

Question 56

What is the colour tick mark on primary and secondary data source

Answer 56

Blue, orange

Question 57

A dimension is a field that typically holds

Answer 57

Discrete qualitative data

Question 58

Dates are typically treated as ____

Answer 58

Dimensions

Question 59

The globe icon next to a field means that field is _____

Answer 59

Geographic

Question 60

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

Answer 60

Pareto Chart

Question 61

Which of the following charts uses binned data?

Answer 61

Histogram

Question 62

If a field has a blue background, that means that the field is ____

Answer 62

Discrete

Question 63

When might you want to use a context filter?

Answer 63

First apply a filter and then show the Top N or Bottom N elements

Question 64

This type level of detail expression computes total sales for the region, regardless of what dimensions are shown in the view

Answer 64

{ FIXED [Region] : SUM([Sales])}

Question 65

Adding a dimension to the row or column shelf will filter your data

Answer 65

False

Question 66

Suppose that your data has a dimension called “Product Category”, which has the values “Furniture”, “Office Supplies”, and “Technology.” Which of the following should you use to combine Furniture and Office Supplies into a single category?

Answer 66

Hierarchy

Question 67

All rows from both tables are returned in an INNER JOIN

Answer 67

False

Question 68

LEFT JOIN returns all rows from the left table, with the matching rows in the right table

Answer 68

True

Question 69

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.

Answer 69

True

Question 70

What is the colour of Discrete Measures in Tableau

Answer 70

Blue

Question 71

For Bullet Graphs we need at least _____ times

Answer 71

2

Question 72

Which graph is the best to show comparison between Actual and Target measure

Answer 72

Bullet Graph

Question 73

Which Aggregate Function is used to calculate Distinct Count?

Answer 73

COUNTD()

Question 74

Which is an LOD function

Answer 74

INCLUDE, EXCLUDE, FIXED

Question 75

Which is not an action out of below?

Answer 75

Tooltip

Question 76

______ is used to distribute these interactive workbooks and/or reports to the right audience

Answer 76

Tableau Desktop

Question 77

Tableau 10 new feature can Join data from ______ data source(s) and can connect to ______

Answer 77

different, Google sheet

Question 78

Which is not a new feature in Tableau 10

Answer 78

Now you can blend data from different data sources

Question 79

Below is an example of continuous field (by default)

Answer 79

Date

Question 80

Which is a false statement about Parameters

Answer 80

Parameters can’t be used in calculation

Question 81

Which is not a filter

Answer 81

Tooltip filter

Question 82

Parameters can be used in

Answer 82

Tooltip

Question 83

Which language does Tableau support for data manipulation while importing the dataset

Answer 83

SQL

Question 84

Which of the following returns an Absolute value of a given number

Answer 84

ABS()

Question 85

How is data stored in a .tde file?

Answer 85

Column wise

Question 86

If blending is applied, then is it necessary to drop common field in a view containing fields of two different data sources on which blending is applied

Answer 86

False

Question 87

If we drop 2 measures in rows/columns, what will be the output

Answer 87

Axis

Question 88

Link to data is shown in which tab

Answer 88

Data source page

Question 89

Null values are counted along with other items in a column while using the COUNT function

Answer 89

False

Question 90

Which chart is used to show the interquartile range in Tableau

Answer 90

Box chart

Question 91

Sorting can be done at the following levels

Answer 91

Data source order, alphabetic, field, and manual

Question 92

How to use parameter value to filter the view in worksheet?

Answer 92

Calculated Field