Free sample, no account needed

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.

Create a free account I already have an account

1Question 1You are here

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

2Question 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?

3Question 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`?

4Question 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?

5Question 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?

Create a free account and keep going

Free members study the full dbt - Analytics Engineering Certification theory course and get a much larger slice of the question bank, with progress tracking that remembers exactly where they stopped.

Full theory course

Every chapter, free