DBT DBT Testing & Data Quality

Question 1

Which built-in dbt generic test checks that all values in a column are unique?

Accepted Answer

unique

Answer

The `unique` generic test asserts that every row in a column has a distinct value.

Question 2

What dbt command runs all tests defined in your project?

Accepted Answer

dbt test

Answer

`dbt test` executes all schema and data tests and reports pass/fail results.

Question 3

Which YAML key is used to define generic tests on a column inside a schema.yml file?

Accepted Answer

tests

Answer

Under each column definition you add a `tests:` list to attach generic tests.

Question 4

A `relationships` test in dbt verifies what condition?

Accepted Answer

Column values exist in a referenced model's column

Answer

The `relationships` test is a referential-integrity check ensuring every foreign-key value exists in the parent table.

Question 5

Which dbt package is the most widely adopted for extending the set of generic tests beyond the four built-in ones?

Accepted Answer

dbt-utils

Answer

`dbt-utils` ships dozens of reusable macros and generic tests such as `expression_is_true` and `recency`.

DBT - Certified Data Build Tool Developer Practice Test