Free Practice Questions for dbt Analytics Engineering Certification Exam Certification

🔄 Last checked for updates February 24th, 2026

Study with 374 exam-style practice questions designed to help you prepare for the dbt Analytics Engineering Certification Exam. All questions are aligned with the latest exam guide and include detailed explanations to help you master the material.

Random Questions

Practice with randomly mixed questions from all topics

Question MixAll Topics

FormatRandom Order

Domain Mode

Practice questions from a specific topic area

Select Domain

Exam Information

Exam Details

Key information about dbt Analytics Engineering Certification Exam

Official study guide:

View

price:

$200

language:

English

exam format:

Multiple-choice, Fill-in-the-blank, Matching, Hotspot, Build list, Discrete Option Multiple Choice (DOMC)

passing score:

65% or higher

prerequisites:

SQL proficiency, 6+ months dbt experience (Core or Cloud), foundational Git skills

delivery method:

online proctored

duration minutes:

120

supported version:

dbt Core 1.7

number of questions:

certification validity:

2 years

Exam Topics & Skills Assessed

Skills measured (from the official study guide)

Domain 1: Developing dbt models

Subdomain 1.1: Identifying and verifying any raw object dependencies

Identifying and verifying any raw object dependencies

Subdomain 1.2: Understanding core dbt materializations

Understanding core dbt materializations

Subdomain 1.3: Conceptualizing modularity and how to incorporate DRY principles

Conceptualizing modularity and how to incorporate DRY principles

Subdomain 1.4: Converting business logic into performant SQL queries

Converting business logic into performant SQL queries

Subdomain 1.5: Using commands such as run, test, docs and seed

Using commands such as run, test, docs and seed

Subdomain 1.6: Creating a logical flow of models and building clean DAGs

Creating a logical flow of models and building clean DAGs

Subdomain 1.7: Defining configurations in dbt_project.yml

Defining configurations in dbt_project.yml

Subdomain 1.8: Configuring sources in dbt

Configuring sources in dbt

Subdomain 1.9: Using dbt Packages

Using dbt Packages

Subdomain 1.10: Utilizing git functionality within the development lifecycle

Utilizing git functionality within the development lifecycle

Subdomain 1.11: Creating Python models

Creating Python models

Subdomain 1.12: Providing access to users to models with the “grants” configuration

Providing access to users to models with the “grants” configuration

Domain 2: Understanding dbt models governance

Subdomain 2.1: Adding contracts to models to ensure the shape of models

Adding contracts to models to ensure the shape of models

Subdomain 2.2: Creating different versions of our models and deprecating the old ones

Creating different versions of our models and deprecating the old ones

Subdomain 2.3: Configuring model access

Configuring model access

Domain 3: Debugging data modeling errors

Subdomain 3.1: Understanding logged error messages

Understanding logged error messages

Subdomain 3.2: Troubleshooting using compiled code

Troubleshooting using compiled code

Subdomain 3.3: Troubleshooting .yml compilation errors

Troubleshooting .yml compilation errors

Subdomain 3.4: Distinguishing between a pure SQL and a dbt issue that presents itself as a SQL issue

Distinguishing between a pure SQL and a dbt issue that presents itself as a SQL issue

Subdomain 3.5: Developing and implementing a fix and testing it prior to merging

Developing and implementing a fix and testing it prior to merging

Domain 4: Managing data pipelines

Subdomain 4.1: Troubleshooting and managing failure points in the DAG

Troubleshooting and managing failure points in the DAG

Subdomain 4.2: Using dbt clone

Using dbt clone

Subdomain 4.3: Troubleshooting errors from integrated tools

Troubleshooting errors from integrated tools

Domain 5: Implementing dbt tests

Subdomain 5.1: Using generic, singular, custom, and custom generic tests on a wide variety of models and sources

Using generic, singular, custom, and custom generic tests on a wide variety of models and sources

Subdomain 5.2: Testing assumptions for dbt models and sources

Testing assumptions for dbt models and sources

Subdomain 5.3: Implementing various testing steps in the workflow

Implementing various testing steps in the workflow

Domain 6: Creating and Maintaining dbt documentation

Subdomain 6.1: Updating dbt docs

Updating dbt docs

Subdomain 6.2: Implementing source, table, and column descriptions in .yml files

Implementing source, table, and column descriptions in .yml files

Subdomain 6.3: Using macros to show model and data lineage on the DAG

Using macros to show model and data lineage on the DAG

Domain 7: Implementing and maintaining external dependencies

Subdomain 7.1: Implementing dbt exposures

Implementing dbt exposures

Subdomain 7.2: Implementing source freshness

Implementing source freshness

Domain 8: Leveraging the dbt state

Subdomain 8.1: Understanding state

Understanding state

Subdomain 8.2: Using dbt retry

Using dbt retry

Subdomain 8.3: Combining state and result selectors

Combining state and result selectors

Techniques & products

dbt Core

dbt Cloud

SQL

Git

Jinja

Macros

dbt Packages

Materializations (table, view, incremental, ephemeral)

Snapshots

Analyses

Seeds

Exposures

Source Freshness

dbt state

dbt run command

dbt test command

dbt docs command

dbt seed command

dbt compile command

dbt source freshness command

dbt generate command

dbt build command

dbt run-operation command

dbt retry command

dbt snapshot command

dbt clone command

DAGs (Directed Acyclic Graphs)

YAML (.yml files)

Model Contracts

Model Versioning

Model Deprecation

Model Access

Git branching strategies

Git pull requests

Git fetch

Git pull

Git merge

Data platforms

GitHub

Start Practicing