DBT CERTIFICATION EXAM
QUESTIONS AND CORRECT ANSWERS
VERIFIED 2025/2026.
Source property - name - ANS how you refer to the source when calling it. by default, this is
also the name of schema that dbt assumes the tables are in unless otherwise specified.
source property - database - ANS the name of the database the source tables are in
source property - schema - ANS the name of the schema the source tables are in
source property - loaded_at_field - ANS the column name dbt will use to check when data
was last loaded in the table to check for freshness
source property - freshness - ANS configuration to set up errors or warning if data is stale
based on when it was last loaded
source - table - name - ANS the name of the table that you refer to. by default this is also the
name of the table in the database unless specified
source - table - identifier - ANS the name of the table in the database
source property - table quoting - ANS whether dbt will use quotes in the query when
compiling the table / view names
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, source property - config - enabled - ANS whether the source is included in your dbt project
source property - overrides - ANS Override a source defined in an included package. The
properties defined in the overriding source will be applied on top of the base properties of the
overridden source.
source property - external - ANS dictionary of metadata pointing to external table
what type of files are sources configured in - ANS yml
how do you call the source function - ANS {{ source ('source_name', 'table_name') }}
what command produces warnings or errors if sources have stale data? - ANS dbt source
freshness
dbt command to execute all compiled sql models - ANS dbt run
dbt command to run tests on all models, sources, snapshots, seeds - ANS dbt test
dbt command to load csv files - ANS dbt seed
dbt command to execute all snapshots - ANS dbt snapshot
dbt command to generate the sql for models - ANS dbt compile
command the runs models, tests, snapshots, and seeds - ANS dbt build
dbt command to just run the model model_a - ANS dbt run --select model_a
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
QUESTIONS AND CORRECT ANSWERS
VERIFIED 2025/2026.
Source property - name - ANS how you refer to the source when calling it. by default, this is
also the name of schema that dbt assumes the tables are in unless otherwise specified.
source property - database - ANS the name of the database the source tables are in
source property - schema - ANS the name of the schema the source tables are in
source property - loaded_at_field - ANS the column name dbt will use to check when data
was last loaded in the table to check for freshness
source property - freshness - ANS configuration to set up errors or warning if data is stale
based on when it was last loaded
source - table - name - ANS the name of the table that you refer to. by default this is also the
name of the table in the database unless specified
source - table - identifier - ANS the name of the table in the database
source property - table quoting - ANS whether dbt will use quotes in the query when
compiling the table / view names
1 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
, source property - config - enabled - ANS whether the source is included in your dbt project
source property - overrides - ANS Override a source defined in an included package. The
properties defined in the overriding source will be applied on top of the base properties of the
overridden source.
source property - external - ANS dictionary of metadata pointing to external table
what type of files are sources configured in - ANS yml
how do you call the source function - ANS {{ source ('source_name', 'table_name') }}
what command produces warnings or errors if sources have stale data? - ANS dbt source
freshness
dbt command to execute all compiled sql models - ANS dbt run
dbt command to run tests on all models, sources, snapshots, seeds - ANS dbt test
dbt command to load csv files - ANS dbt seed
dbt command to execute all snapshots - ANS dbt snapshot
dbt command to generate the sql for models - ANS dbt compile
command the runs models, tests, snapshots, and seeds - ANS dbt build
dbt command to just run the model model_a - ANS dbt run --select model_a
2 @COPYRIGHT 2025/2026 ALLRIGHTS RESERVED.
