Free Data Build Tool dbt-Analytics-Engineering Exam Questions
Absolute Free dbt-Analytics-Engineering Exam Practice for Comprehensive Preparation
-
Data Build Tool dbt-Analytics-Engineering Exam Questions
-
Provided By: Data Build Tool
- Exam: dbt Analytics Engineering Certification
- Certification: dbt Certification
-
Total Questions: 224
-
Updated On: Dec 08, 2025
-
Rated: 4.9 |
-
Online Users: 448
-
Question 1
-
Given following .yml, how the model events/mart/model_b.sql will be materialized
name: dbt_labs
models:
dbt_labs:
events:
+enabled: true
+materialized: view
base:
+materialized: table"
Answer: A
-
Given following .yml, how the model events/mart/model_b.sql will be materialized
-
Question 2
-
Identify True/False dbt also executes any custom generate_schema_name macros that are part of a package installed in your project., hence it is important to rename any such macro provided by installed packages
Answer: B
-
Identify True/False dbt also executes any custom generate_schema_name macros that are part of a package installed in your project., hence it is important to rename any such macro provided by installed packages
-
Question 3
-
Which statement best describes snapshot feature in dbt
Answer: B
-
-
Question 4
-
Identify valid dbt commands (choose 2)
Answer: B,C
-
Identify valid dbt commands (choose 2)
-
Question 5
-
How the SQL will be compiled based on the following model:
{% set payment_methods = ["bank_transfer", "credit_card", "gift_card"] %}
select order_id,
{% for payment_method in payment_methods %}
sum(case when payment_method = '{{payment_method}}' then amount end) as {{payment_method}}_amount,
{% endfor %}
from {{ ref('raw_payments') }}
group by 1
Answer: A
-
How the SQL will be compiled based on the following model: