Intro to DBT and Data Layers Quiz

What does dbt stand for?

• Data Built Table
• Digital Build Tools
• Data Build Tool
• Dynamic BI Tool

Fill in the blank: dbt focuses on the ________ step in the ELT process.

What does dbt use to define a model?

• An Excel file
• A SELECT SQL statement
• A CSV import
• A Python script

Which of the following are features of dbt Cloud? (Select all that apply)

• Git integration
• Python scripting
• SQL interface
• Web IDE

Fill in the blank: Each dbt model creates a ________ in your data warehouse.

What does the dbt run command do?

• Exports documentation
• Runs all tests
• Executes and recreates model views
• Loads raw data

What is the purpose of the ref() function in dbt?

• It formats SQL queries
• It references earlier models
• It writes test outputs
• It renames columns

What are some steps in the dbt transformation workflow? (Select all that apply)

• Document models
• Add sources
• Clean Python code
• Build SQL views

Fill in the blank: dbt’s graph of model dependencies is called a ________.

What happens if a dbt test fails?

• The transformation runs anyway
• The process stops to prevent bad data
• Only a warning appears
• Data is deleted