Font size
S
M
L
XL
WorksheetsDBT Advanced Quiz
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
Which of these is the main focus of dbt?
a)
Data Extraction
b)
Data Transformation
c)
Data Storage
d)
Data Analysis
2.
Fill in the blank: By default, dbt materializes models as (a) .
3.
Which folder typically contains the most complex transformations?
a)
Mart
b)
Staging
c)
Intermediate
d)
Raw
4.
What are benefits of materializing models as tables in dbt? (Select all that apply)
a)
Faster performance
b)
Always uses less storage
c)
Avoids recomputing queries
d)
Ensures freshest data
5.
Fill in the blank: A dbt (a) is used to organize logic and store models by transformation type.
6.
In dbt, what is the purpose of staging models?
a)
Final reporting
b)
Joining 10+ tables
c)
Cleaning raw data
d)
Creating dashboards
7.
Fill in the blank: In dbt Cloud, version control is managed using (a) .
8.
What is the role of the production environment in dbt?
a)
For testing experiments
b)
For cleaning raw data
c)
To serve data to end users
d)
To store backups
9.
Which steps are part of the Git workflow in dbt Cloud? (Select all that apply)
a)
Create a branch
b)
Commit changes
c)
Create a pull request
d)
Upload to FTP
10.
How can dbt jobs be scheduled in production?
a)
Only manually
b)
Using dbt Cloud or Airflow
c)
With Excel Macros
d)
On a timer app
11.
Fill in the blank: In dbt, a (a) defines a reusable block of SQL code.
12.
What does the `ref()` function in dbt do?
a)
Deletes unused models
b)
References another model
c)
Joins all tables
d)
Connects to dashboards
13.
Fill in the blank: The templating language used in dbt is called (a) .
14.
What is a reason to create a singular test in dbt?
a)
To test views only
b)
To write a custom SQL test
c)
To convert macros
d)
To run dbt faster
15.
Fill in the blank: The most popular package for extending dbt tests and macros is (a) .
Reset
