MyCertStack logoMyCertStack

    dbt - Analytics Engineering Certification Practice Questions & Free Practice Exam

    5 free dbt - Analytics Engineering Certification practice questions below, with instant explanations. The full simulator contains hundreds of exam-style questions across every topic.

    Open the full Practice ZoneCreate a free account
    Question 1

    Each column listed under a model's `columns:` block requires which YAML key when `contract: {enforced: true}` is set on the model?

    Question 2

    Source rows older than 7 days are purged downstream, so the freshness probe should restrict its staleness check to the past week of data only. The CI parse step currently rejects a `period: week` setting because the freshness schema does not accept that unit. Which key under the source's `freshness:` block restricts the probe to recent rows?

    Question 3

    Tests that breach their threshold under `dbt build` can land in several status buckets. Which outcome is NOT recorded with status `error` in `run_results.json`?

    Question 4

    Where does dbt write the compiled SQL of a test so an engineer can copy it into a SQL editor and rerun by hand?

    Question 5

    Internal package code sits in a private GitLab repository, not on `hub.getdbt.com`. The CI runner already holds an SSH deploy key for the GitLab remote. Which `packages.yml` entry installs the package?

    Ready for the full dbt - Analytics Engineering Certification exam simulator?

    Unlock the complete question bank, weighted mock exams, saved-question flashcards, and the Shark AI tutor - all inside your MyCertStack account.

    See pricingBrowse other certifications