Extract optimization in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a Tableau extract with incremental refresh.

Tableau

CREATE EXTRACT [1] FROM datasource

Drag options to blanks, or click blank then click option'

AFULL

BINCREMENTAL

CLIVE

DPARTIAL

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing FULL extracts which refresh all data every time.

Selecting LIVE which does not create an extract.

Incremental extracts only add new data since the last extract, improving refresh speed.

2fill in blank

medium

Complete the code to set the extract refresh schedule to daily at midnight.

Tableau

SET EXTRACT REFRESH SCHEDULE TO [1] AT midnight

Drag options to blanks, or click blank then click option'

Aweekly

Bmonthly

Chourly

Ddaily

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing weekly or monthly which refresh less often.

Selecting hourly which refreshes too frequently.

Daily refresh at midnight ensures data is updated every day at 12 AM.

3fill in blank

hard

Fix the error in the extract filter to only include data from the last 30 days.

Tableau

FILTER EXTRACT WHERE Date >= [1]

Drag options to blanks, or click blank then click option'

ADATEADD('day', -30, TODAY())

BNOW() - 30

CTODAY() - 30

DDATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)

Attempts:

3 left

💡 Hint

Common Mistakes

Using arithmetic subtraction directly on dates which is invalid.

Using SQL syntax like DATE_SUB which Tableau does not support.

DATEADD with negative 30 days subtracts 30 days from today correctly in Tableau.

4fill in blank

hard

Fill both blanks to optimize extract size by excluding unused columns and filtering recent data.

Tableau

CREATE EXTRACT FROM datasource EXCLUDE COLUMNS [1] WHERE Date >= [2]

Drag options to blanks, or click blank then click option'

A['Comments', 'Attachments']

BDATEADD('day', -60, TODAY())

CDATEADD('month', -1, TODAY())

D['UserNotes', 'Logs']

Attempts:

3 left

💡 Hint

Common Mistakes

Excluding columns that are actually needed.

Using incorrect date functions or intervals.

Excluding unused columns like 'UserNotes' and 'Logs' reduces extract size. Filtering data from last 60 days keeps extract recent.

5fill in blank

hard

Fill all three blanks to create an optimized extract with incremental refresh, filter, and schedule.

Tableau

CREATE EXTRACT [1] FROM datasource WHERE Date >= [2] SET REFRESH SCHEDULE TO [3]

Drag options to blanks, or click blank then click option'

AINCREMENTAL

BDATEADD('day', -30, TODAY())

CDAILY

DFULL

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing full extract which refreshes all data every time.

Setting refresh schedule to something other than daily.

Incremental extract updates only new data. Filtering last 30 days reduces extract size. Daily refresh keeps data fresh.