Dbt Analytics Engineering Certification Exam Questions

DBT ANALYTICS ENGINEERING CERTIFICATION
EXAM QUESTIONS

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?

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.

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

, 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 - Answer -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

In dbt, which method allows you to clone private packages via HTTPS by passing a Git
token?
1) Git Token Method
2) Git Application Token Method
3) SSH Key Method
4) GitLab Deploy Token Method - Answer -Git Token Method.

You can clone private packages via HTTPS using the Git Token Method by passing a
Git token via an environment variable.

Reference:https://docs.getdbt.com/docs/build/packages

What is the purpose of a singular data test in dbt?
1) To check SQL code style
2) To validate a single assertion
3) To test multiple columns
4) To validate SQL - Answer -To validate a single assertion.

Singular data tests are used to validate a single assertion in SQL code. They are
typically defined in .sql files and are suitable for one-off assertions.

Reference:https://docs.getdbt.com/docs/build/data-tests

In dbt Core, where can you find logs related to queries dbt has run? x
1) In the target/run directory
2) In the target/compiled directory
3) In the dbt Cloud IDE
4) In the logs/dbt.log file - Answer -In the logs/dbt.log file.

In dbt Core, you can find logs related to queries dbt has run in the logs/dbt.log file.

Reference:https://docs.getdbt.com/guides/debug-errors?