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

unique

Answer

accepted_values

Answer

relationships

Question 2

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

Accepted Answer

Jinja macros with test_ prefix

Answer

Singular tests

Answer

Schema YAML overrides

Answer

Packages

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

Writes failures to a local CSV

Answer

Sends results to dbt Cloud

Answer

Creates a test results JSON artifact

Question 4

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

Accepted Answer

run_results.json

Answer

manifest.json

Answer

catalog.json

Answer

sources.json

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

Use a dbt_project.yml tests: block

Answer

Use an __all__.yml wildcard file

Answer

Define a global_tests.yml

Question 6

Which accepted_values test parameter makes the test case-insensitive?

Accepted Answer

case_sensitive: false

Answer

ignore_case: true

Answer

lower_values: true

Answer

normalize: true