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

not_null

Answer

accepted_values

Answer

relationships

Question 2

What dbt command runs all tests defined in your project?

Accepted Answer

dbt test

Answer

dbt compile

Answer

dbt run

Answer

dbt check

Question 3

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

Accepted Answer

tests

Answer

checks

Answer

constraints

Answer

validations

Question 4

A `relationships` test in dbt verifies what condition?

Accepted Answer

Column values exist in a referenced model's column

Answer

Column values are not null

Answer

Column values are unique

Answer

Column data types match

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-expectations

Answer

dbt-audit-helper

Answer

dbt-codegen

Question 6

How do you limit `dbt test` to only tests on a specific model named `orders`?

Accepted Answer

dbt test --select orders

Answer

dbt test --model orders

Answer

dbt test --filter orders

Answer

dbt test --only orders