FREE DBT Data Modeling & Transformation Questions and Answers

Question 1

In dbt, what is a 'model' primarily used for?

Accepted Answer

Transform data using SQL

Answer

Store user permissions

Answer

Send API requests

Answer

Configure server settings

Question 2

What type of dbt materialization creates a new physical table in the warehouse each time it runs?

Accepted Answer

Table

Answer

View

Answer

Incremental

Answer

Ephemeral

Question 3

Which materialization type is used in dbt to improve performance by only updating new or changed records?

Accepted Answer

Incremental

Answer

Table

Answer

View

Answer

Seed

Question 4

What does 'ref()' function do in dbt models?

Accepted Answer

References another dbt model

Answer

Declares a variable

Answer

Sends data to an API

Answer

Deletes a model

Question 5

Which dbt file is responsible for describing the structure and relationships of data models?

Accepted Answer

schema.yml

Answer

dbt_project.yml

Answer

models.sql

Answer

packages.yml

Question 6

What is the main advantage of using CTEs (Common Table Expressions) in dbt models?

Accepted Answer

Improves query readability and modularity

Answer

Reduces project size

Answer

Increases data redundancy

Answer

Prevents model execution

Question 7

Which command would you run to build all models in your dbt project?

Accepted Answer

dbt run

Answer

dbt seed

Answer

dbt test

Answer

dbt clean

Question 8

Which feature allows dbt to test for null values, uniqueness, and relationships in data models?

Accepted Answer

Data tests

Answer

Snapshots

Answer

Jinja macros

Answer

Ephemeral models

Question 9

Which configuration file in dbt specifies your database credentials and target environment settings?

Accepted Answer

profiles.yml

Answer

packages.yml

Answer

models.sql

Answer

snapshots.yml