DBT DBT Sources & Seeds 2

Question 1

How do you reference a seed table inside a dbt model?

Accepted Answer

Answer

Seeds are treated like models in the DAG, so you reference them with `{{ ref('seed_name') }}` just like any model.

Question 2

Where are source definitions typically stored in a dbt project?

Accepted Answer

In YAML files within the models/ directory

Answer

Sources are declared in any YAML file inside the models/ directory tree (e.g., sources.yml or staging/sources.yml).

Question 3

What does the `loaded_at_field` property on a source table specify?

Accepted Answer

The column that holds the row's creation timestamp for freshness checks

Answer

`loaded_at_field` points to a timestamp column that dbt checks to determine how recently data was loaded.

Question 4

Which config key in dbt_project.yml sets the schema for all seed tables?

Accepted Answer

seeds > +schema

Answer

Under the `seeds:` block in dbt_project.yml, `+schema` overrides the default schema for seed output tables.

Question 5

What happens when you run `dbt seed --full-refresh`?

Accepted Answer

The seed table is dropped and recreated from scratch

Answer

`--full-refresh` causes dbt to drop the existing seed table before recreating it, ensuring a clean load.

DBT - Certified Data Build Tool Developer Practice Test