dbt Analytics Engineering Practice Exams 2026 (v1.11)

This course contains the use of artificial intelligence.

Six full-length practice exams for the dbt Analytics Engineering Certification. Each one is built around the current study guide (dbt Core 1.11). Every exam has 65 questions spread across all seven official topics:

• Developing and optimizing dbt models: incremental strategies, microbatch, YAML snapshots, --empty and --sample, Python models, dbt show

• Managing dbt models governance: contracts, constraints, versions, access

• Debugging data modeling errors: compiled SQL, YAML and Jinja errors, behavior flags

• Troubleshooting and optimizing dbt pipelines: failure points, dbt clone, warn_if/error_if

• Implementing dbt tests: generic, singular and unit tests, severity, store_failures

• Implementing and maintaining external dependencies: exposures, source freshness

• Leveraging the dbt state: state:modified, defer, result: and source_status: selectors, dbt retry

Many questions are scenarios with real SQL, YAML and command-line snippets. You read the code and decide what dbt will do, which is how the exam tests you. Every answer option has its own explanation, so you learn why the right answer is right and why each wrong answer is wrong.

Aim for 65% or higher on each exam before booking the real test.

Updated October 2026: what changed

• Rebuilt all six exams around the dbt Core 1.11 study guide and its seven topics. The retired documentation and model-access domains are gone.

• Fixed incorrect answer keys, including swapped multi-select keys reported by students. All 114 multi-select questions were re-checked.

• Added dozens of new scenario questions covering unit tests, microbatch, YAML snapshots, constraints, behavior flags, dbt clone, dbt retry and state selection.

• Removed duplicate, outdated (for example surrogate_key, --models, GRANT hooks) and inaccurate questions.

• Every multi-select question now states how many answers to pick, and correct-answer positions are balanced.

This is an independent practice resource and isn't affiliated with or endorsed by dbt Labs.