Test 1

Question 1

Which table calculation returns the number of rows from the current row to the first row in the partition?

Answer 1

FIRST()

Question 2

Which table calculation returns the index of the current row in the partition, without any sorting with regard to value?

Answer 2

INDEX()

Question 3

Which table calculation returns the value of the expression in a target row, specified as a relative offset from the current row?

Answer 3

LOOKUP()

Question 4

Which table calculation might return the following rankings : 1,1,1,4,4,6,7,7,7,10?

Answer 4

RANK()

Question 5

Which table calculation might return the following rankings : 1,1,1,2,2,3,4,4,4,5?

Answer 5

RANK_DENSE()

Question 6

Which table calculation might return the following rankings : 3,3,3,5,5,6,9,9,9,10?

Answer 6

RANK_MODIFIED()

Question 7

Which table calculation might return the following rankings : 1,2,3,4,5,6,7,8,9,10?

Answer 7

RANK_UNIQUE()

Question 8

Which table calculation returns rankings as percentiles?

Answer 8

RANK_PERCENTILE()

Question 9

How do you import a custom shape into Tableau?

Answer 9

1. Save your custom shape in a new folder in My Tableau Repository/Shapes
2. Click on the Marks Card’s drop down menu and select Shape
3. Reload the shapes palette and select your new shape

Question 10

What file type is created when you save a flow?

Answer 10

.tfl

Question 11

What file type is created when you save a packaged flow?

Answer 11

.tflx

Question 12

Which formats can be used to create an output form your flow to use in Tableau Desktop?

Answer 12

1 .hyper
2 .csv
3 .xlsx

Question 13

Which file do you need to update to create a custom color palette?

Answer 13

Preferences.tps

Question 14

What data roles does Tableau Prep Builder provide?

Answer 14

1. email
2. URL
3. Geographic roles

Question 15

How do you replace a sheet in a dashboard?

Answer 15

1. Select the sheet you want to replace in the dashboard
2. Hover over the replacement sheet from the list on the left
3. Click the Swap Sheets button that appears

Question 16

How do you replace a data source?

Answer 16

1. Open a workbook that connects to the original data source
2. Select Data > New Data Source and connect to new data source
3. On the Data Source page, drag a table to the canvas to set up the data source
4. Go to the sheet tab and select Data > Replace Data Source
5. Select the Current data source and the Replacement data source from the dialog box

Question 17

How are milliseconds represented in custom date formatting?

Answer 17

.000

Question 18

What formats are available for downloading a view from a published dashboard?

Answer 18

1. Image (.png)
2. Data
3. Crosstab
4. PDF
5. PowerPoint
6. Tableau Workbook

Question 19

What are the Quick Table calculations available?

Answer 19

1. Running total
2. Difference
3. Percent difference
4. Percent of total
5. Rank
6. Percentile
7. Moving average
8. YTD total
9. Compound growth rate
10. Year of year growth
11. YTD growth

Question 20

How do you apply a quick filter to all sheets in your workbook using a related data source?

Answer 20

1. Right click field in the Filters shelf
2. Select Apply to Worksheets > All Using Related Data Sources

Question 21

What is CASE statement syntax?

Answer 21

CASE <expression>
WHEN <'value1'> THEN <'then1'>
WHEN <'value2'> THEN <'then2'>
...
[ELSE <'default'>]
END</expression>