dbt Analytics Engineering study materials
dbt Analytics Engineering study resources

dbt Analytics Engineering exam-day guide

dbt Analytics Engineering · Prepare for the day ahead.

Your checklist

Government-issued photo ID matching your registration name

Check that your name on the ID matches the name you registered with. If you have a preferred name or recently changed your name, confirm with the provider in advance how mismatches are handled, since policies vary by vendor.

Your appointment confirmation and testing-provider login

Save the confirmation email (or PDF) and know how to reach the exam portal. Confirm the exact start time and time zone in your confirmation. If you cannot find it, contact the provider before exam day rather than guessing.

Stable internet connection and a backup option

A wired connection or strong Wi-Fi is preferable. Know how to tether to a phone as a fallback, and confirm with the provider whether a disconnect allows you to resume or requires a reschedule.

Computer that meets the provider's technical requirements

Run any system or compatibility check the provider offers ahead of time. Close other applications before starting. Exact OS/browser requirements are provider-specific: confirm with the provider.

Webcam, microphone, and speakers/headset if testing remotely

Remote proctoring typically requires a working camera and mic for identity verification and room scan. Confirm with the provider which peripherals are permitted or prohibited.

Quiet, private room free of prohibited materials

Clear your desk of notes, second screens, phones, and printed material unless the provider explicitly allows them. Know whether a whiteboard or scratch paper is permitted: confirm with the provider.

Review the provider's allowed-materials and environment rules

Rules on scratch paper, calculators, water, and breaks differ between vendors and delivery modes. Read the candidate handbook for your specific exam rather than relying on secondhand advice.

Log in early per the provider's instructions

Many providers recommend arriving 15-30 minutes before your slot for check-in. Confirm the exact recommended window with the provider.

Plan your time budget for the question format

Know roughly how many questions and how much time you have, and rehearse a pace that leaves time to review flagged items. Confirm the current format and duration with the provider, since these can change.

Prepare for scenario-based SQL and modeling questions

Expect questions that test reasoning about models, tests, sources, and incremental logic rather than trivia. Practice reading a described scenario and choosing the most appropriate dbt construct.

Decide in advance how you will handle uncertain questions

Plan to flag and move on rather than stall. Confirm whether the exam penalizes wrong answers or whether unanswered questions score as incorrect: confirm with the provider.

Note the provider's reschedule and cancellation window

Fees and deadlines vary. If something goes wrong in the final days, knowing the policy helps you decide quickly. Confirm with the provider.

Plan the day

Final 72 hours

Shift from learning new material to consolidating. Re-read your own summary of dbt fundamentals: project structure, the ref and source functions, model materializations, schema tests and custom tests, sources and freshness, seeds and snapshots, and Jinja/macros. Do one timed practice set under exam-like conditions and review every miss for the underlying concept, not just the answer. Confirm your appointment details, ID, and technical setup are in order.

Final 24 hours

Stop cramming new topics. Do a light review of your weak areas and the constructs you confuse most often (for example, when to use a snapshot versus an incremental model, or how source freshness differs from data tests). Prepare your workspace and gather your ID. Get a full night's sleep; fatigue costs more than one extra hour of review. Re-confirm your start time and time zone.

Morning of

Eat and hydrate, then do a short warm-up of 10-15 easy questions or a quick skim of your notes to get into the mindset. Test your camera, mic, and connection. Close unnecessary applications and silence notifications. Log in at the provider's recommended time and complete identity verification calmly.

During the test

Read each question fully and identify what is actually being asked before looking at options. Answer confident questions first, flag uncertain ones, and return to them. For scenario questions, reason about correctness and maintainability rather than cleverness. Watch the clock at rough checkpoints so you are never surprised by the end. If you take an allowed break, note the time and confirm the rules beforehand. If the platform fails, follow the provider's incident process immediately.

After the test

Note which topics felt weak while it is fresh, in case you need to retake. Confirm with the provider how and when results are delivered and what the retake policy is.

Rules to check

  • Bring identification that matches your registration exactly. If your ID name differs from your registered name, resolve it with the provider before exam day; do not assume it will be accepted.

  • Follow the provider's rules on permitted materials. Unless the provider explicitly allows notes, scratch paper, calculators, or a second screen, assume they are prohibited and keep them out of your testing area.

  • Do not communicate with anyone during the exam, and do not use unauthorized tools or AI assistants. Treat the session as closed-book unless the provider states otherwise.

  • Understand the break policy before you start. Some exams allow scheduled breaks and others do not, and leaving the camera view may be treated as a violation: confirm with the provider.

  • Know how scoring works before you sit down: whether unanswered questions count as incorrect, whether there is a penalty for guessing, and what the passing threshold is. Confirm with the provider rather than relying on forums.

  • Read the provider's policy on technical failures and rescheduling. If your session drops, follow their incident procedure and keep any reference numbers they give you.

  • Do not discuss, share, or reproduce exam content afterward. This is standard for most certification programs and protects your own result.

  • If a rule in your confirmation conflicts with anything you read elsewhere, the provider's current candidate handbook governs. Confirm anything ambiguous with the provider directly.