Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Tableau > Knowledge Based Questions > Flashcards

Knowledge Based Questions Flashcards

1
Q

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

A

A join

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Tableau can create worksheet-specific filters

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does the box in a box plot represent

A

The range of the middle half of the data points

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Number of days between them

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is wrong with this if statement:

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

A

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

[shipping mode] = “Delivery Truck”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

All rows from both tables are returned in an INNER JOIN

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

SUM is a table calculation

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Clustering

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Which of the following is used to assess trend line significance

A

p-value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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?

A

Context filters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which of the following are generated fields in Tableau?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Pareto charts combine the following element

A

…

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Bullet graphs combine bar charts and reference lines

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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?

A

Tableau reader

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

LEFT JOIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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

A

Change the join condition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

______ is a tendency to increase or decrease over time

A

Trend

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

Box Plot

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Context filters are executed after data source filters

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

A

Continuous field, Measure values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

Gantt charts are useful for

A

Displaying duration of events or activities over time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

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.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

You can combine multiple worksheets in a single dashboard

A

True

38
Q

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

A

Device designer

39
Q

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

A

URL

40
Q

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

A

A JOIN

41
Q

What is the use of data interpreter option in Tableau

A

To structure the unstructured data

42
Q

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

A

Data Interpreter and Union

43
Q

When to use extract option in Tableau

A

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

44
Q

To add cross data source join _____ must be specified

A

Primary and foreign key

45
Q

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?

A

Standard

46
Q

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

A

SUM(sales/quantity)

47
Q

Which columns you cannot delete in Tableau

A

Measure Names and Measure Values

48
Q

You cannot change a dimension to continuous

A

True

49
Q

You cannot create bins of measures

A

False

50
Q

Latitude and longitude are Tableau generated fields

A

True

51
Q

We can use measure names in creating custom column

A

False

52
Q

For bullet graph, you need ____ dimensions

A

0 or more

53
Q

For creating line chart, what is required

A

Continuous field

54
Q

What is the colour of attribute in Tableau?

A

Blue

55
Q

In shelf calculated columns are ______

A

Worksheet specific

56
Q

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

A

Blue, orange

57
Q

A dimension is a field that typically holds

A

Discrete qualitative data

58
Q

Dates are typically treated as ____

A

Dimensions

59
Q

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

A

Geographic

60
Q

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

A

Pareto Chart

61
Q

Which of the following charts uses binned data?

A

Histogram

62
Q

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

A

Discrete

63
Q

When might you want to use a context filter?

A

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

64
Q

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

A

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

65
Q

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

A

False

66
Q

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?

A

Hierarchy

67
Q

All rows from both tables are returned in an INNER JOIN

A

False

68
Q

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

A

True

69
Q

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.

A

True

70
Q

What is the colour of Discrete Measures in Tableau

A

Blue

71
Q

For Bullet Graphs we need at least _____ times

A

2

72
Q

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

A

Bullet Graph

73
Q

Which Aggregate Function is used to calculate Distinct Count?

A

COUNTD()

74
Q

Which is an LOD function

A

INCLUDE, EXCLUDE, FIXED

75
Q

Which is not an action out of below?

A

Tooltip

76
Q

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

A

Tableau Desktop

77
Q

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

A

different, Google sheet

78
Q

Which is not a new feature in Tableau 10

A

Now you can blend data from different data sources

79
Q

Below is an example of continuous field (by default)

A

Date

80
Q

Which is a false statement about Parameters

A

Parameters can’t be used in calculation

81
Q

Which is not a filter

A

Tooltip filter

82
Q

Parameters can be used in

A

Tooltip

83
Q

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

A

SQL

84
Q

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

A

ABS()

85
Q

How is data stored in a .tde file?

A

Column wise

86
Q

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

A

False

87
Q

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

A

Axis

88
Q

Link to data is shown in which tab

A

Data source page

89
Q

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

A

False

90
Q

Which chart is used to show the interquartile range in Tableau

A

Box chart

91
Q

Sorting can be done at the following levels

A

Data source order, alphabetic, field, and manual

92
Q

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

A

Calculated Field

Tableau (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions