Module 6 Quiz – Analytics Engineering

Question 1: What is the main purpose of testing in dbt? *

A) To format SQL queries

B) To create dashboards

C) To ensure data quality and catch issues early

D) To run Python scripts

Question 2: Which of the following is a built-in dbt test? *

A) row_count_matches

B) unique

C) order_amount_check

D) max_value_test

Question 3: Where do you usually define dbt tests for a model? *

A) In a Google Sheet

B) In the model's schema.yml file

C) In a separate JSON config file

D) Directly in the database

Question 4: What does the not_null test check for? *

A) That a column has at least one value

B) That a column contains only unique values

C) That no null values exist in a column

D) That a column is a foreign key

Question 5: Which test would best validate that a column only contains values like 'active' and 'inactive'? *

A) not_null

B) relationships

C) accepted_values

D) contains_only

Question 6: Which directory do custom test SQL files go in? *

A) /models/

B) /sources/

C) /tests/

D) /scripts/

Question 7: When you run dbt test, what happens? *

A) All tests are applied to the data models

B) Only unit tests are executed

C) dbt updates your models

D) dbt generates documentation

Question 8: What happens if a dbt test fails? *

A) dbt stops all processing

B) The test is ignored

C) You get a report showing the rows that failed

D) The entire database is rolled back

Question 9: Which of the following is a best practice when writing tests in dbt? *

A) Only test one model

B) Treat tests like code: version, review, and document

C) Avoid writing custom tests

D) Only run tests manually

Question 10: What is the benefit of using dbt-utils with testing? *

A) It offers reusable test macros like expression_is_true

B) It helps format dashboards

C) It runs dbt models faster

D) It improves chart visuals