DBT DBT Testing & Data Quality 3

Question 1

What built-in dbt test verifies that a column contains no NULL values?

Accepted Answer

not_null

Answer

The `not_null` test fails if any row in the column contains a NULL, enforcing completeness.

Question 2

Which dbt feature allows you to define custom generic tests in the `macros/` directory?

Accepted Answer

Jinja macros with test_ prefix

Answer

A macro named `test_<name>` in the macros folder is automatically recognized by dbt as a reusable generic test.

Question 3

What does `dbt test --store-failures` do at the command-line level?

Accepted Answer

Enables store_failures for all tests in the run

Answer

Passing `--store-failures` at runtime overrides individual test configs to persist failing rows for every test in that run.

Question 4

Which dbt artifact file contains a summary of test results after `dbt test` runs?

Accepted Answer

run_results.json

Answer

`run_results.json` records the status (pass/fail/warn/error), timing, and row counts for every node executed.

Question 5

In dbt, how do you apply a generic test to every model in a subdirectory using a schema.yml default config?

Accepted Answer

Add the test under a models: key in dbt_project.yml

Answer

The `models:` key in dbt_project.yml supports test configs that cascade to all models within a specified path.

DBT - Certified Data Build Tool Developer Practice Test