DBT DBT Snapshots & Incremental Models 2

Question 1

What value does dbt store in `dbt_valid_to` for the currently active snapshot row?

Accepted Answer

NULL

Answer

The current timestamp

Answer

9999-12-31

Answer

The next run timestamp

Question 2

Which materialization causes dbt to append only new or changed rows instead of rebuilding the whole table?

Accepted Answer

incremental

Answer

view

Answer

table

Answer

ephemeral

Question 3

What block in an incremental model filters the source data to only new records?

Accepted Answer

{% if is_incremental() %}

Answer

{% if is_new %}

Answer

{% when incremental %}

Answer

{% filter new_rows %}

Question 4

What does `dbt run --full-refresh` do to an incremental model?

Accepted Answer

Rebuilds the table from scratch, ignoring the existing data

Answer

Skips the model entirely

Answer

Appends all historical records again

Answer

Converts it to a view temporarily

Question 5

Which incremental `strategy` is recommended for Snowflake and BigQuery to efficiently update existing rows?

Accepted Answer

merge

Answer

append

Answer

delete+insert

Answer

insert_overwrite

Question 6

What config key specifies the column(s) used to match existing rows in an incremental merge strategy?

Accepted Answer

unique_key

Answer

primary_key

Answer

merge_key

Answer

match_on