dbt Analytics Engineer — Practice

Questions in this quiz

1. 1. In dbt, what is a 'model'?
   1. A YAML config file
   2. A SELECT statement saved as a .sql file that dbt materializes in the warehouse
   3. A Python script
   4. A schema migration tool
2. 2. Which materialization rebuilds the table from scratch on every run?
   1. view
   2. table
   3. incremental
   4. ephemeral
3. 3. Which materialization processes only new or changed records using a unique key?
   1. view
   2. table
   3. incremental
   4. ephemeral
4. 4. What is a dbt 'source'?
   1. An external SaaS product
   2. A declared upstream table in the warehouse, referenced via {{ source(...) }}
   3. A Python virtual environment
   4. A test result file
5. 5. Which built-in dbt test checks that a column has no duplicates?
   1. not_null
   2. unique
   3. accepted_values
   4. relationships
6. 6. What does the ref() function do?
   1. Reads from a CSV
   2. Resolves the fully qualified name of another dbt model and establishes the DAG dependency
   3. Executes a stored procedure
   4. Returns the current schema name
7. 7. Which dbt feature captures slowly changing dimensions (SCD Type 2) automatically?
   1. Seeds
   2. Snapshots
   3. Exposures
   4. Sources
8. 8. Which command runs only the tests defined for a project?
   1. dbt run
   2. dbt build
   3. dbt test
   4. dbt seed
9. 9. What does dbt seed do?
   1. Generates fake test data
   2. Loads CSV files from the seeds/ directory into the warehouse as tables
   3. Initializes a new dbt project
   4. Validates YAML files
10. 10. Which file declares a model's tests, documentation, and metadata?
    1. dbt_project.yml
    2. A .yml file in the same directory as the model (often schema.yml)
    3. profiles.yml
    4. manifest.json
11. 11. What is a dbt 'macro'?
    1. A keyboard shortcut
    2. A reusable Jinja function defined in macros/ and callable from models
    3. A scheduled job
    4. A profile setting
12. 12. Where is the connection to the warehouse (host, user, password) typically configured?
    1. dbt_project.yml
    2. profiles.yml (in ~/.dbt/ by default)
    3. schema.yml
    4. Inside each model file