Full refresh vs incremental in dbt - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to run a full refresh of a dbt model.

dbt

dbt run --[1]

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

Afull-refresh

Bincremental

Cselect

Dcompile

Attempts:

3 left

💡 Hint

Common Mistakes

Using --incremental runs only new data, not a full rebuild.

Using --select only chooses models but does not refresh fully.

Using --full-refresh tells dbt to rebuild the model completely, replacing existing data.

2fill in blank

medium

Complete the code to define an incremental model in dbt.

dbt

[1]:
  +materialized: incremental

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

Aseeds

Bmodels

Csnapshots

Dsources

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing seeds or snapshots with models.

Placing materialized under the wrong section.

The models section in dbt_project.yml defines how models are materialized, including incremental.

3fill in blank

hard

Fix the error in the incremental model SQL to update only new rows.

dbt

select * from source_table where updated_at > '[1]'

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

Arun_started_at

Bmax(updated_at)

Ccurrent_timestamp

Dlast_updated

Attempts:

3 left

💡 Hint

Common Mistakes

Using max(updated_at) without aggregation context causes errors.

Using current_timestamp may miss rows updated during the run.

run_started_at is a dbt variable that holds the timestamp when the run started, useful for incremental filters.

4fill in blank

hard

Fill both blanks to create a dictionary comprehension that filters words longer than 4 characters.

dbt

filtered = {word: len(word) for word in words if len(word) [1] [2]

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

A>

B4

C<

D3

Attempts:

3 left

💡 Hint

Common Mistakes

Using < instead of > reverses the filter.

Using 3 instead of 4 changes the length condition.

The comprehension keeps words where length is greater than 4.

5fill in blank

hard

Fill all three blanks to create a dictionary of uppercase words with their lengths, filtering words longer than 5.

dbt

result = { [1]: [2] for w in words if len(w) [3] 5 }

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

Aw.upper()

Blen(w)

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' filters shorter words instead.

Using 'w' instead of 'w.upper()' changes the key format.

This comprehension maps uppercase words to their lengths, only for words longer than 5 characters.