Why models are the core of dbt - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why are models central in dbt?

In dbt, models are the main building blocks. Which statement best explains why models are the core of dbt?

A Models define SQL queries that transform raw data into clean, usable tables or views.

B Models are used only to schedule dbt runs automatically.

C Models store the raw data before any transformation.

D Models are scripts that install dbt on your computer.

💡 Hint

Think about what dbt does with data and how models fit in.

Models in dbt are SQL files that define how raw data is transformed into clean, organized tables or views. They are the core because they represent the transformation logic.

❓ Predict Output

intermediate

Output of a simple dbt model SQL

Given this dbt model SQL code, what will be the output table content?

dbt

select id, upper(name) as name_upper from raw.customers where active = true

A [{'id': 1, 'name_upper': 'ALICE'}, {'id': 3, 'name_upper': 'CHARLIE'}]

B [{'id': 1, 'name_upper': 'alice'}, {'id': 3, 'name_upper': 'charlie'}]

C [{'id': 2, 'name_upper': 'BOB'}, {'id': 4, 'name_upper': 'DAVID'}]

D SyntaxError: missing FROM clause

💡 Hint

Look at the filter and the upper function.

The query selects only active customers and converts their names to uppercase. So only active customers appear with uppercase names.

❓ data_output

advanced

Number of models created after running dbt

If you have 5 SQL files in your models folder and run dbt run, how many models will be created in your data warehouse?

A Depends on the number of sources

B 0

C 1

D 5

💡 Hint

Each SQL file in the models folder corresponds to one model.

Each SQL file in the models folder is compiled and run as one model, so 5 files produce 5 models.

🔧 Debug

advanced

Identify the error in this dbt model SQL

What error will this dbt model SQL produce when run?

dbt

select id, name from raw.customers where active = 'yes'

A No error, runs successfully

B Runtime error: invalid boolean comparison

C SyntaxError: missing comma

D KeyError: 'active' column not found

💡 Hint

Check the data type of the 'active' column and the filter value.

If 'active' is a boolean column, comparing it to string 'yes' causes a runtime error due to type mismatch.

🚀 Application

expert

Choosing the right model materialization

You want your dbt model to update quickly and reflect the latest data without rebuilding the entire table. Which materialization should you choose?

A Table materialization

B View materialization

C Incremental materialization

D Ephemeral materialization

💡 Hint

Think about materializations that update only new or changed data.

Incremental materialization updates only new or changed rows, making it faster for large datasets than rebuilding tables or views.