Live vs extract connections in Tableau - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the connection type for a Tableau data source.

Tableau

connection_type = "[1]"

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

Acached

Blive

Coffline

Dextract

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'extract' which stores data locally instead of querying live.

Using 'offline' which is not a Tableau connection type.

In Tableau, a live connection means the data is queried directly from the source in real time.

2fill in blank

medium

Complete the code to set the extract refresh schedule in Tableau.

Tableau

extract_refresh = "[1]"

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

Adaily

Bmanual

Crealtime

Dnever

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'realtime' which applies to live connections, not extracts.

Selecting 'never' which means no refresh.

Extracts in Tableau can be refreshed on a daily schedule to keep data up to date.

3fill in blank

hard

Fix the error in the code that sets the connection type for Tableau data source.

Tableau

connection_type = '[1]'

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

Alive

Blive extract

Cextract

Dlive-extract

Attempts:

3 left

💡 Hint

Common Mistakes

Using combined terms like 'live extract' which are invalid.

Using hyphenated terms like 'live-extract' which Tableau does not recognize.

The connection type must be either 'live' or 'extract'. 'extract' is the correct option here.

4fill in blank

hard

Fill both blanks to complete the Tableau extract creation code.

Tableau

extract = tableau.[1](source)
extract.[2]()

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

Acreate_extract

Brefresh

Cdelete

Dpublish

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'delete' which removes the extract instead of creating it.

Using 'publish' which uploads the extract but does not create it.

First, you create_extract from the source, then you refresh it to update data.

5fill in blank

hard

Fill all three blanks to configure a Tableau data source connection with extract and schedule refresh.

Tableau

data_source = tableau.connect('[1]')
extract = data_source.[2]()
schedule = extract.[3]('weekly')

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

Alive

Bextract

Cset_refresh_schedule

Dcreate_extract

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'live' connection type when scheduling extract refresh.

Confusing 'refresh' with 'set_refresh_schedule'.

Skipping extract creation step.

You connect using an extract, then create_extract to build it, and finally set_refresh_schedule to automate updates.