DBT DBT Testing & Data Quality 2

Question 1

What does the `store_failures` config on a dbt test do?

Accepted Answer

Persists failing rows to a table in the database

Answer

Stops the pipeline on failure

Answer

Sends a Slack alert

Answer

Logs failures to a local file

Question 2

Which severity level causes dbt test to exit with a non-zero code but continue running remaining tests?

Accepted Answer

warn

Answer

error

Answer

info

Answer

debug

Question 3

Where are singular (bespoke) dbt tests stored in a standard project layout?

Accepted Answer

tests/

Answer

models/

Answer

macros/

Answer

analyses/

Question 4

What does a singular dbt test return to indicate a failure?

Accepted Answer

Any non-empty result set

Answer

A boolean FALSE value

Answer

A NULL value

Answer

An exception

Question 5

Which config allows you to set a threshold so a test only fails if MORE than N rows are returned?

Accepted Answer

error_if

Answer

warn_if

Answer

threshold

Answer

max_failures

Question 6

Which dbt-utils test checks that a numeric column never decreases over time within a partition?

Accepted Answer

monotonic_increase

Answer

not_decreasing

Answer

recency

Answer

expression_is_true