DBT DBT Snapshots & Incremental Models

Question 1

What is the primary purpose of a dbt snapshot?

Accepted Answer

To capture and track slowly changing dimension (SCD) history in a source table

Answer

To cache query results for performance

Answer

To take a database backup before a run

Answer

To freeze a model's schema for documentation

Question 2

Which directory stores dbt snapshot files by default?

Accepted Answer

snapshots/

Answer

models/snapshots/

Answer

data/snapshots/

Answer

seeds/

Question 3

What command runs all dbt snapshots?

Accepted Answer

dbt snapshot

Answer

dbt run --snapshots

Answer

dbt materialize --type snapshot

Answer

dbt scd

Question 4

Which snapshot strategy compares a hash of all specified columns to detect row changes?

Accepted Answer

check

Answer

timestamp

Answer

merge

Answer

diff

Question 5

Which snapshot strategy relies on an `updated_at` timestamp column to detect changes?

Accepted Answer

timestamp

Answer

check

Answer

hash

Answer

merge

Question 6

What column does dbt automatically add to a snapshot table to mark the time a record became current?

Accepted Answer

dbt_valid_from

Answer

dbt_updated_at

Answer

dbt_created_at

Answer

snapshot_start