DBT DBT Deployment & CI/CD 3

Question 1

Which dbt artifact is essential for enabling Slim CI state comparison?

Accepted Answer

manifest.json

Answer

`manifest.json` is the compiled graph of all nodes and their checksums, which dbt diffs against to find modified nodes.

Question 2

What is the best practice for the `profiles.yml` target schema in a developer environment?

Accepted Answer

Use a personal schema prefixed with the developer's name

Answer

A personal schema (e.g., `dbt_alice`) isolates each developer's models and prevents overwriting shared data.

Question 3

Which command verifies that your dbt project YAML and SQL are syntactically valid without connecting to a warehouse?

Accepted Answer

dbt parse

Answer

`dbt parse` reads all project files and builds the internal graph, catching YAML syntax errors and reference issues without running queries.

Question 4

What does the `on-run-start` hook in dbt_project.yml execute?

Accepted Answer

SQL run before any model or test in the job

Answer

`on-run-start` hooks run arbitrary SQL statements before any models, seeds, or tests are executed in a dbt invocation.

Question 5

Which dbt command installs packages listed in packages.yml?

Accepted Answer

dbt deps

Answer

`dbt deps` downloads all packages listed in packages.yml into the `dbt_packages/` directory.

DBT - Certified Data Build Tool Developer Practice Test