DBT ANALYTICS ENGINEERING CERTIFICATION - KEY TOPICS | 180 QUESTIONS
AND ANSWERS | 2026 UPDATED | SCORED A+
Correct 180
Incorrect
1 of 180
Term
You have defined a metric in your dbt project, but upon attempting to
reference the metric in a downstream tool, an error message appears
indicating that the metric is not present. What is the most probable
cause for this problem?
Give this one a try later!
The result method is related to the state selector.
Used to select resources based on their result status from a prior run.
dbt test --select "result:fail" --state path/to/artifacts
^run all tests that failed on the prior invocation of dbt test
The metric has not been added to the dbt_project.yml file.
This file is used to configure your dbt project and must be updated to ensure
the metric is available to downstream tools.
, It can be a Snowpark or pandas DataFrame.
When working in Snowflake, the dbt Python model() function must return a single
DataFrame, which can be a Snowpark or pandas DataFrame.
Snapshots are stored in the same target_schema for everyone, while models are
stored in a separate schema for each user to maintain separate development and
production environments.
Don't know?
2 of 180
Definition
Declaring a deprecation_date for a dbt model provides a
mechanism to communicate plans and timelines for long-
term support and maintenance and to facilitate change
management.
Setting a deprecation_date works well in conjunction with
other model governance features like model versions, but
can also be used independently from them.
Deprecated models can continue to be built by producers
and be selected by consumers until they are disabled or
removed - But you will get warnings.
Just like it does not automatically drop relations when
models are deleted, dbt does not drop relations for
deprecated models.
Give this one a try later!
, run a model with multiple versions model versions
model contracts deprecation_date
Don't know?
3 of 180
Definition
Manage access to datasets by configuring grants on each model,
seed, or snapshot.
Define the default grants that apply to the entire project in your
dbt_project.yml, and define model-specific grants within each model's
SQL or YAML file.
When you run a model, seed data, or snapshot a dataset, dbt will run
grant and/or revoke statements to ensure that the permissions on the
database object match the grants you have configured on the
resource.
Grants have two key components:
Privilege: A right to perform a specific action or set of actions on an
object in the database, such as selecting data from a table.
Grantees: One or more recipients of granted privileges. Some
platforms also call these "principals." For example, a grantee could be
a user, a group of users, a role held by one or more users (Snowflake),
or a service account (BigQuery/GCP).
Give this one a try later!
, Packages Sanctions
Grants Bonuses
Don't know?
4 of 180
Term
What are the ways to set up a code repository for a dbt project?
Give this one a try later!
Navigate to the target/run/ directory It must contain a "date_day" column
for all run queries and columns for week, month, and
Navigate to the target/compiled/ quarter, and year (or equivalent) with
directory for all compiled queries the prefix "date_".
Using dbt Cloud to manage a
repository
Using an adapter for a data platform
Creating a new repository on
that supports a fully featured Python
Git
runtime.
Using a managed repository on
Git
Don't know?
AND ANSWERS | 2026 UPDATED | SCORED A+
Correct 180
Incorrect
1 of 180
Term
You have defined a metric in your dbt project, but upon attempting to
reference the metric in a downstream tool, an error message appears
indicating that the metric is not present. What is the most probable
cause for this problem?
Give this one a try later!
The result method is related to the state selector.
Used to select resources based on their result status from a prior run.
dbt test --select "result:fail" --state path/to/artifacts
^run all tests that failed on the prior invocation of dbt test
The metric has not been added to the dbt_project.yml file.
This file is used to configure your dbt project and must be updated to ensure
the metric is available to downstream tools.
, It can be a Snowpark or pandas DataFrame.
When working in Snowflake, the dbt Python model() function must return a single
DataFrame, which can be a Snowpark or pandas DataFrame.
Snapshots are stored in the same target_schema for everyone, while models are
stored in a separate schema for each user to maintain separate development and
production environments.
Don't know?
2 of 180
Definition
Declaring a deprecation_date for a dbt model provides a
mechanism to communicate plans and timelines for long-
term support and maintenance and to facilitate change
management.
Setting a deprecation_date works well in conjunction with
other model governance features like model versions, but
can also be used independently from them.
Deprecated models can continue to be built by producers
and be selected by consumers until they are disabled or
removed - But you will get warnings.
Just like it does not automatically drop relations when
models are deleted, dbt does not drop relations for
deprecated models.
Give this one a try later!
, run a model with multiple versions model versions
model contracts deprecation_date
Don't know?
3 of 180
Definition
Manage access to datasets by configuring grants on each model,
seed, or snapshot.
Define the default grants that apply to the entire project in your
dbt_project.yml, and define model-specific grants within each model's
SQL or YAML file.
When you run a model, seed data, or snapshot a dataset, dbt will run
grant and/or revoke statements to ensure that the permissions on the
database object match the grants you have configured on the
resource.
Grants have two key components:
Privilege: A right to perform a specific action or set of actions on an
object in the database, such as selecting data from a table.
Grantees: One or more recipients of granted privileges. Some
platforms also call these "principals." For example, a grantee could be
a user, a group of users, a role held by one or more users (Snowflake),
or a service account (BigQuery/GCP).
Give this one a try later!
, Packages Sanctions
Grants Bonuses
Don't know?
4 of 180
Term
What are the ways to set up a code repository for a dbt project?
Give this one a try later!
Navigate to the target/run/ directory It must contain a "date_day" column
for all run queries and columns for week, month, and
Navigate to the target/compiled/ quarter, and year (or equivalent) with
directory for all compiled queries the prefix "date_".
Using dbt Cloud to manage a
repository
Using an adapter for a data platform
Creating a new repository on
that supports a fully featured Python
Git
runtime.
Using a managed repository on
Git
Don't know?
