DBT Analytics Engineering
Certification Exam-Graded A
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? - ANSWER-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
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 - ANSWER-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
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 - ANSWER-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.
3) It only refreshes incremental models.
4) It uses a different set of dbt commands.
Code blocks for configuring models.
, Macros are blocks of code that you can reuse multiple times.
Reference:https://docs.getdbt.com/docs/build/projects - ANSWER-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
WET.
WET stands for "Write Everything Twice," implying code duplication.
Reference:https://docs.getdbt.com/terms/dry - ANSWER-What is the opposite of DRY in
software development?
1) WET
2) HARD
3) SOFT
4) DARE
Include all columns.
Snapshot source data in its raw form and include as many columns as possible, even if
not immediately needed.
Reference:https://docs.getdbt.com/docs/build/snapshots - ANSWER-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
Writing singular tests.
The recommended approach for testing multiple specific tables simultaneously is writing
singular tests.
Reference:https://docs.getdbt.com/best-practices/how-we-structure/6-the-rest-of-the-
project - ANSWER-What is the recommended approach for testing multiple specific
tables simultaneously in a dbt project?
1) Writing singular tests
2) Using generic tests
3) Avoiding tests altogether
4) Creating custom models
Certification Exam-Graded A
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? - ANSWER-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
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 - ANSWER-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
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 - ANSWER-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.
3) It only refreshes incremental models.
4) It uses a different set of dbt commands.
Code blocks for configuring models.
, Macros are blocks of code that you can reuse multiple times.
Reference:https://docs.getdbt.com/docs/build/projects - ANSWER-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
WET.
WET stands for "Write Everything Twice," implying code duplication.
Reference:https://docs.getdbt.com/terms/dry - ANSWER-What is the opposite of DRY in
software development?
1) WET
2) HARD
3) SOFT
4) DARE
Include all columns.
Snapshot source data in its raw form and include as many columns as possible, even if
not immediately needed.
Reference:https://docs.getdbt.com/docs/build/snapshots - ANSWER-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
Writing singular tests.
The recommended approach for testing multiple specific tables simultaneously is writing
singular tests.
Reference:https://docs.getdbt.com/best-practices/how-we-structure/6-the-rest-of-the-
project - ANSWER-What is the recommended approach for testing multiple specific
tables simultaneously in a dbt project?
1) Writing singular tests
2) Using generic tests
3) Avoiding tests altogether
4) Creating custom models
