dbt Analytics Engineering Certification · v1.11 · updated May 2026

Walk into your dbt exam knowing you’ll pass.

Timed simulations with the real exam’s question formats, weights, and pass mark. Every answer cited to the official docs — and where it’s SQL, you can run it yourself.

Take the free readiness check20 questions · ~15 minutesTry one sample question ↓

examprotocol.dbt Analytics Engineering

Hide Timer

01:21:07

20212223242526

Question 24 of 65Mark for review

An orders table holds 800M rows. Roughly 0.5% of existing rows are UPDATED each day, plus a few million new rows are appended. Each order has a stable order_id, and consumers must see each order’s latest state exactly once. Which incremental configuration fits?

Aincremental_strategy='merge' without a unique_key

Bmaterialized='table' so every run rebuilds the full 800M rows

Cincremental_strategy='append', since updates are rare

Dincremental_strategy='merge' with unique_key='order_id'

Submit

Built for exam v1.11 (2026)Answers cited to the dbt docsRunnable SQL on data questionsMoney-back pass guarantee

TRY ONE QUESTION

An original question, in the real exam format.

This is DOMC — the format the real exam uses. Answer it and you get the explanation, the citations and a runnable proof cell.

Discrete option — decide YES or NO for each option as it appears

A view must be rebuilt by dbt before it returns rows added to its source table

OPTION 1

On the real exam each answer is final — here, answer either way to see everything.

Answer to reveal the explanation, citations and proof

A view holds only the query definition, not a copy of the rows — the warehouse resolves it against the underlying table at read time, so rows landing in the source are visible on the very next query with no dbt run in between. This is exactly why views are the default for lightweight staging models.

docs.getdbt.com/docs/build/materializations docs.getdbt.com/best-practices/materializations/2-available-materializations

Try 20 more — take the free check

What’s inside

Everything here exists to answer one question: are you ready to sit the exam? You find out here — while you can still do something about it.

YESNO

Real formats

DOMC, build-list, matching, hotspot — the formats the real exam uses and almost nobody else replicates.

0102030405060708

8 full practice exams

520 original questions across 8 complete 65-question simulations, with zero overlap — you never sit the same exam twice.

select count(*) from stg_orderswhere amount is null;→ 0 rows

Prove-it cells

Run the SQL against a sample schema, right inside the explanation, and watch the answer come out.

docs.getdbt.com/docs/build/incremental-modelsreference/resource-configs

Doc-cited explanations

Why the right answer is right, why each wrong one is wrong — with links to the official docs.

Governance

Testing

Modeling

Weakness-first studying

The engine feeds you your weakest exam topic first.

78% ready

Readiness score

Every attempt is saved. Watch your score climb toward the pass mark — and know the moment you're ready.

Get your own gap map — free check

How it works

Take the readiness check

Free, 20 questions, weighted like the real exam. You leave with a weakness map, not a sales pitch.

Start the check

Close your gaps in Study Mode

Every miss resurfaces until you answer it correctly — weakest exam topic first.

Rehearse with full timed simulations

65 questions, real formats, real clock — until your readiness score clears the pass mark.

How we compare

Exam-format fidelity (DOMC, build-list, hotspot)
Free dumps✕
Udemy packs✕
examprotocol.✓
Full timed simulator with the real pass mark
Free dumps✕
Udemy packspartial
examprotocol.✓
Answers you can verify by running them
Free dumps✕
Udemy packs✕
examprotocol.✓
Citations to the official dbt docs
Free dumps✕
Udemy packssometimes
examprotocol.✓
Weakness analytics by exam topic
Free dumps✕
Udemy packs✕
examprotocol.✓
Progress tracking across attempts
Free dumps✕
Udemy packs✕
examprotocol.✓
Written for the current exam edition (v1.11)
Free dumps✕
Udemy packssometimes
examprotocol.✓

CAPABILITY	Free dumps	Udemy packs	examprotocol.
Exam-format fidelity (DOMC, build-list, hotspot)	✕	✕	✓
Full timed simulator with the real pass mark	✕	partial	✓
Answers you can verify by running them	✕	✕	✓
Citations to the official dbt docs	✕	sometimes	✓
Weakness analytics by exam topic	✕	✕	✓
Progress tracking across attempts	✕	✕	✓
Written for the current exam edition (v1.11)	✕	sometimes	✓

See where you stand — free check20 questions · ~15 minutes

Your exam date is coming either way. Find out where you stand today — free.

Start the readiness check20 questions · ~15 minutes