Free Practice Questions for DBT Analytics Engineering Certification Exam Certification

🔄 Last checked for updates March 3rd, 2026

Study with 510 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

Question formats CertSafari offers

Multiple choice
Ordering
Matching
True/False
Fill in the blank

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 of experience with dbt (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)

dbt Snapshots

dbt Analyses

dbt Seeds

dbt Exposures

Source Freshness

dbt State

dbt run

dbt test

dbt docs

dbt seed

dbt compile

dbt source freshness

dbt docs generate

dbt build

dbt run-operation

dbt retry

dbt snapshot

dbt clone

Directed Acyclic Graphs (DAGs)

dbt_project.yml

.yml files

Model Contracts

Model Versioning

Model Deprecation

Model Access

Git branching strategies

Git commands (fetch, pull, merge)

Pull Requests

Data platforms

Data warehouses

Common Table Expressions (CTEs)

Window functions

Aggregations

Joins

Python models

Start Practicing