Hot Vendors

Question # 4

A field that shows average home values for the United States in 2016 is most likely :

A.

A discrete date part dimension

B.

A continuous date value dimension

C.

A geographical dimension

D.

An aggregated measure

Question # 5

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

Question # 6

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?

A.

Data source Filter

B.

Extract Filter

C.

Context Filter

D.

None of the these

Question # 7

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

A.

True

B.

False

Question # 8

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

Question # 9

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

Question # 10

For creating variable sized bins we use __________________

A.

Calculated Fields

B.

Table Calculations

C.

Sets

D.

Groups

Question # 11

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%

Question # 12

Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

A.

3.000

B.

3.840

C.

3.704

D.

3.500

Question # 13

By definition, Tableau displays measures over time as a ____________

A.

Packed Bubble

B.

Bar

C.

Stacked Bar

D.

Line

Question # 14

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

Question # 15

True or False: LEFT JOIN returns all rows from the left table, with the matching rows in the right table

A.

True

B.

False

Question # 16

_____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

A.

Tableau Packaged Workbook (.twbx)

B.

Tableau Workbook (.twb)

C.

Tableau Data Extract (.tde)

D.

Tableau Data Source (.tds)

Question # 17

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

Question # 18

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

Question # 19

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

Question # 20

What term is used to describe the following picture? A.

Larger image

B.

Parameter

C.

Set

D.

Hierarchy

E.

Group

Question # 21

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

Question # 22

Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

A.

Brazil

B.

Peru

C.

Argentina

D.

Mexico  