Learn
Practice
Projects
Free datasets
Resources
Toolkit
Pricing
Log in
Start free
Loading…
dbt Quiz (100 Questions)
← All topics
dbt Quiz (100 Questions)
100 exercises
·
10 free
01
What Is dbt Primarily Used For?
Free
→
02
dbt Projects Are Commonly Written In Which Language?
Free
→
03
Which dbt Command Compiles Models Without Running Them?
Free
→
04
Which Concept Best Describes dbt’s Approach To Data Transformations?
Free
→
05
dbt Is Most Similar In Concept To:
Free
→
06
dbt Fits Into The Modern Data Stack As:
Free
→
07
When Running dbt, Transformations Are Executed:
Free
→
08
Which Statement Best Captures dbt’s Philosophy?
Free
→
09
dbt Models Are Typically Organized In A:
Free
→
10
dbt Encourages A Version-Control Workflow That Primarily Uses:
Free
→
11
Which Command Runs All Models In A dbt Project?
Locked
→
12
Where Are Target Profiles Typically Defined?
Locked
→
13
The dbt Debug Command Is Used To:
Locked
→
14
To Specify Different Environments Like Dev Or Prod, You Can:
Locked
→
15
If Your dbt Command Isn’t Connecting To The Warehouse, The First Step Is Often To:
Locked
→
16
dbt Commands Typically Run From:
Locked
→
17
A dbt_project.yml File Defines:
Locked
→
18
To Run A Subset Of Models, dbt Uses:
Locked
→
19
To Run Models For A Specific Folder Only:
Locked
→
20
dbt Logs By Default Are Found In:
Locked
→
21
A Ref() Function In dbt Is Used To:
Locked
→
22
Sources In dbt:
Locked
→
23
Seeds In dbt Are:
Locked
→
24
Materializations Define:
Locked
→
25
A Model Configured As 'View' Materialization:
Locked
→
26
Ephemeral Models:
Locked
→
27
Incremental Models Are Beneficial For:
Locked
→
28
The Var() Function In dbt:
Locked
→
29
Staging Models Typically:
Locked
→
30
A Snapshot In dbt:
Locked
→
31
dbt Tests Are Written In:
Locked
→
32
Running dbt Test Does What?
Locked
→
33
Documentation In dbt Is Generated By:
Locked
→
34
The dbt Docs Serve Command:
Locked
→
35
Generic Data Tests (Formerly Called Schema Tests) Check:
Locked
→
36
Custom Tests Are Defined By:
Locked
→
37
dbt Docs Generate Outputs:
Locked
→
38
The --Select Test_type:Singular Argument
Locked
→
39
Descriptions For Models And Columns Are Usually Stored In:
Locked
→
40
Tests Can Help Ensure Data Quality By:
Locked
→
41
Jinja In dbt Is Used For:
Locked
→
42
A Macro In dbt Is:
Locked
→
43
To Reference A Macro, You Typically Use:
Locked
→
44
Macros Help:
Locked
→
45
A Common Macro File Location Is:
Locked
→
46
Jinja Variables Are Enclosed In:
Locked
→
47
If You Want A Macro To Do Conditional Logic, You’d Use:
Locked
→
48
Macros Can Also Be Used To:
Locked
→
49
To Debug A Macro, You Can:
Locked
→
50
Macros Can Be Made Available To Other dbt Projects By:
Locked
→
51
dbt Packages Are Defined In:
Locked
→
52
To Install Packages, You Run:
Locked
→
53
The dbt Package Hub Hosts:
Locked
→
54
Packages Help:
Locked
→
55
To Specify A Package Version:
Locked
→
56
A Private Git Repository Can Be Referenced In Packages.yml Using:
Locked
→
57
After Updating Packages.yml, You Must:
Locked
→
58
Package Conflicts Are Resolved By:
Locked
→
59
Packages Often Contain:
Locked
→
60
Using Packages Can:
Locked
→
61
Which dbt Command Runs Models, Tests, Seeds, And Snapshots Together In DAG Order?
Locked
→
62
When A Test With Error Severity Fails During dbt build, Downstream Resources Are:
Locked
→
63
An Enforced Model Contract (contract: {enforced: true}) Guarantees That:
Locked
→
64
To Enforce A Model Contract, The Model's YAML Must:
Locked
→
65
dbt Unit Tests (Introduced In dbt 1.8) Are Defined:
Locked
→
66
What Is The Main Difference Between Unit Tests And Data Tests In dbt?
Locked
→
67
To Run Only Unit Tests, You Can Use:
Locked
→
68
Which Four Generic Data Tests Ship With dbt Out Of The Box?
Locked
→
69
Setting severity: warn On A Data Test Means:
Locked
→
70
Since dbt 1.8, The Recommended YAML Key For Attaching Generic Data Tests To A Column Is:
Locked
→
71
Model Versions In dbt Let You:
Locked
→
72
To Reference Version 2 Of A Versioned Model, You Write:
Locked
→
73
A Model Configured With access: private Can Be Referenced:
Locked
→
74
The dbt Semantic Layer Is Powered By:
Locked
→
75
The Main Benefit Of Defining Metrics In The dbt Semantic Layer Is:
Locked
→
76
dbt Semantic Layer Metrics Are Defined In:
Locked
→
77
The dbt source freshness Command Checks:
Locked
→
78
In An Incremental Model, is_incremental() Returns True When:
Locked
→
79
To Rebuild An Incremental Model From Scratch, You Run:
Locked
→
80
The unique_key Config On An Incremental Model Is Used To:
Locked
→
81
The Default on_schema_change Behavior For Incremental Models Is:
Locked
→
82
The microbatch Incremental Strategy (dbt 1.9+) Processes Data:
Locked
→
83
Since dbt 1.9, Snapshots Can Be Configured:
Locked
→
84
By Default, A NULL dbt_valid_to In A Snapshot Table Means:
Locked
→
85
The Two Built-In Snapshot Strategies Are:
Locked
→
86
The {{ source('stripe', 'payments') }} Function:
Locked
→
87
Using ref() Instead Of Hard-Coding Table Names Lets dbt:
Locked
→
88
The Selector In dbt run --select +orders Selects:
Locked
→
89
Slim CI In dbt Typically Uses:
Locked
→
90
The dbt retry Command Is Used To:
Locked
→
91
Exposures In dbt Are Used To:
Locked
→
92
A Python Model In dbt Is A .py File That Defines:
Locked
→
93
The dbt show Command Is Used To:
Locked
→
94
Under The Hood, A dbt Data Test Is:
Locked
→
95
By Default, A Model With schema: 'marketing' Built In A Target Whose Schema Is analytics Lands In:
Locked
→
96
Pre-Hooks And Post-Hooks In dbt:
Locked
→
97
A Key Capability Of dbt’s Rust-Based Engine (dbt v2, Formerly The dbt Fusion Engine) Is:
Locked
→
98
Seeds Are Best Suited For:
Locked
→
99
The {{ this }} Variable In A Model Refers To:
Locked
→
100
To Read An Environment Variable In dbt Code, You Use:
Locked
→