DBT CERTIFICATION EXAM | GUARANTEED
SUCCESS STARTS HERE! LEARN, PRACTICE &
EXCEL!
Source property - name - Answer: 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 - Answer: the name of the database the source tables are in
Source property - schema - Answer: the name of the schema the source tables are in
Source property - loaded_at_field - Answer: the column name dbt will use to check when data
was last loaded in the table to check for freshness
Source property - freshness - Answer: configuration to set up errors or warning if data is stale
based on when it was last loaded
Source - table - name - Answer: 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 - Answer: the name of the table in the database
Source property - table quoting - Answer: whether dbt will use quotes in the query when
compiling the table / view names
APPHIA – Crafted with Care and Precision for Academic Excellence. 1
, Source property - config - enabled - Answer: whether the source is included in your dbt project
Source property - overrides - Answer: 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 - Answer: dictionary of metadata pointing to external table
What type of files are sources configured in - Answer: yml
How do you call the source function - Answer: {{ source ('source_name', 'table_name') }}
What command produces warnings or errors if sources have stale data? - Answer: dbt source
freshness
Dbt command to execute all compiled sql models - Answer: dbt run
Dbt command to run tests on all models, sources, snapshots, seeds - Answer: dbt test
Dbt command to load csv files - Answer: dbt seed
Dbt command to execute all snapshots - Answer: dbt snapshot
APPHIA – Crafted with Care and Precision for Academic Excellence. 2
SUCCESS STARTS HERE! LEARN, PRACTICE &
EXCEL!
Source property - name - Answer: 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 - Answer: the name of the database the source tables are in
Source property - schema - Answer: the name of the schema the source tables are in
Source property - loaded_at_field - Answer: the column name dbt will use to check when data
was last loaded in the table to check for freshness
Source property - freshness - Answer: configuration to set up errors or warning if data is stale
based on when it was last loaded
Source - table - name - Answer: 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 - Answer: the name of the table in the database
Source property - table quoting - Answer: whether dbt will use quotes in the query when
compiling the table / view names
APPHIA – Crafted with Care and Precision for Academic Excellence. 1
, Source property - config - enabled - Answer: whether the source is included in your dbt project
Source property - overrides - Answer: 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 - Answer: dictionary of metadata pointing to external table
What type of files are sources configured in - Answer: yml
How do you call the source function - Answer: {{ source ('source_name', 'table_name') }}
What command produces warnings or errors if sources have stale data? - Answer: dbt source
freshness
Dbt command to execute all compiled sql models - Answer: dbt run
Dbt command to run tests on all models, sources, snapshots, seeds - Answer: dbt test
Dbt command to load csv files - Answer: dbt seed
Dbt command to execute all snapshots - Answer: dbt snapshot
APPHIA – Crafted with Care and Precision for Academic Excellence. 2
