DBT Data Modeling & Transformation 4

Question 1

What is the purpose of a dbt snapshot?

Accepted Answer

To record changes to mutable source rows over time (type-2 SCD)

Answer

Snapshots capture historical versions of rows with valid-from and valid-to columns.

Question 2

Which snapshot strategy compares an updated_at column to detect changed rows?

Accepted Answer

timestamp

Answer

The timestamp strategy relies on an updated_at column and is the recommended one.

Question 3

Which columns does dbt add to snapshot tables to track validity?

Accepted Answer

dbt_valid_from and dbt_valid_to

Answer

Snapshots add dbt_valid_from, dbt_valid_to, dbt_scd_id, and dbt_updated_at.

Question 4

Which command loads CSV files from the seeds directory into the warehouse?

Accepted Answer

dbt seed

Answer

dbt seed loads CSV files as tables, suited to small static reference data.

Question 5

Which is the best use case for a seed file?

Accepted Answer

A small, rarely changing mapping such as country codes

Answer

Seeds are for small static lookups version-controlled with the project.

DBT - Certified Data Build Tool Developer Practice Test