DBT DBT Sources & Seeds

Question 1

In dbt, what is a 'source' used for?

Accepted Answer

Declaring raw database tables that dbt did not create

Answer

Defining output tables

Answer

Storing lookup data in CSV files

Answer

Triggering external pipelines

Question 2

Which dbt function is used to reference a source table inside a model SQL file?

Accepted Answer

Answer

Answer

Answer

Question 3

What dbt command checks whether source tables are fresh based on a loaded_at_field?

Accepted Answer

dbt source freshness

Answer

dbt test --source-freshness

Answer

dbt check sources

Answer

dbt run --freshness

Question 4

Which YAML key defines how old source data can be before dbt warns about staleness?

Accepted Answer

freshness

Answer

max_age

Answer

staleness

Answer

loaded_at_threshold

Question 5

What is a dbt seed?

Accepted Answer

A CSV file loaded into the warehouse as a table

Answer

A random data generator for testing

Answer

An initial schema migration script

Answer

A template for new models

Question 6

Which dbt command loads seed CSV files into the target database?

Accepted Answer

dbt seed

Answer

dbt load

Answer

dbt import

Answer

dbt upload