dbt Analytics Engineering Certification
Exam Questions and Correct Answers
2025-2026 Updated.
What is the recommended approach for fixing a Database Error?
1) Review the warehouse documentation
2) Rewrite all SQL queries
3) Delete the entire project
4) Start a new dbt project - Answer Review the warehouse documentation.
To fix a Database Error, you should review the documentation of your data warehouse, such as
Snowflake or BigQuery docs, to debug the specific error.
Reference:https://docs.getdbt.com/guides/debug-errors?
In a dbt project, what happens if a model fails during a CI build?
1) The model is automatically fixed by dbt
2) The CI build is considered successful
3) The CI build stops and the failure is reported
4) The model is excluded from future CI builds - Answer The CI build stops and the failure is
reported.
If a model fails during a CI build in dbt, the build stops, and the failure is reported, preventing
the faulty code from being merged into the main branch.
Reference:https://courses.getdbt.com/courses/take/advanced-deployment/texts/39437556-
review
How does the one-off job approach differ from unified jobs in dbt?
1) It builds the entire DAG every time.
2) It focuses on individual tasks without regard to others.
, One-off jobs focus on individual tasks, possibly leading to redundant rebuilds.
Reference:https://courses.getdbt.com/courses/take/advanced-deployment/texts/39437552-
review
What are "macros" in the context of dbt projects?
1) Code blocks for configuring models
2) Blocks of code for bulk configurations
3) Blocks of SQL queries
4) Docs for your project - Answer Code blocks for configuring models.
Macros are blocks of code that you can reuse multiple times.
Reference:https://docs.getdbt.com/docs/build/projects
What is the opposite of DRY in software development?
1) WET
2) HARD
3) SOFT
4) DARE - Answer WET.
WET stands for "Write Everything Twice," implying code duplication.
Reference:https://docs.getdbt.com/terms/dry
What is the recommended approach for snapshotting source data in its raw form?
1) Include all columns
2) Apply business logic
3) Use joins in the snapshot
4) Select specific columns - Answer Include all columns.
Exam Questions and Correct Answers
2025-2026 Updated.
What is the recommended approach for fixing a Database Error?
1) Review the warehouse documentation
2) Rewrite all SQL queries
3) Delete the entire project
4) Start a new dbt project - Answer Review the warehouse documentation.
To fix a Database Error, you should review the documentation of your data warehouse, such as
Snowflake or BigQuery docs, to debug the specific error.
Reference:https://docs.getdbt.com/guides/debug-errors?
In a dbt project, what happens if a model fails during a CI build?
1) The model is automatically fixed by dbt
2) The CI build is considered successful
3) The CI build stops and the failure is reported
4) The model is excluded from future CI builds - Answer The CI build stops and the failure is
reported.
If a model fails during a CI build in dbt, the build stops, and the failure is reported, preventing
the faulty code from being merged into the main branch.
Reference:https://courses.getdbt.com/courses/take/advanced-deployment/texts/39437556-
review
How does the one-off job approach differ from unified jobs in dbt?
1) It builds the entire DAG every time.
2) It focuses on individual tasks without regard to others.
, One-off jobs focus on individual tasks, possibly leading to redundant rebuilds.
Reference:https://courses.getdbt.com/courses/take/advanced-deployment/texts/39437552-
review
What are "macros" in the context of dbt projects?
1) Code blocks for configuring models
2) Blocks of code for bulk configurations
3) Blocks of SQL queries
4) Docs for your project - Answer Code blocks for configuring models.
Macros are blocks of code that you can reuse multiple times.
Reference:https://docs.getdbt.com/docs/build/projects
What is the opposite of DRY in software development?
1) WET
2) HARD
3) SOFT
4) DARE - Answer WET.
WET stands for "Write Everything Twice," implying code duplication.
Reference:https://docs.getdbt.com/terms/dry
What is the recommended approach for snapshotting source data in its raw form?
1) Include all columns
2) Apply business logic
3) Use joins in the snapshot
4) Select specific columns - Answer Include all columns.
