Free Data Build Tool dbt-Analytics-Engineering Exam Questions
Try our Free Demo Practice Tests for Comprehensive dbt-Analytics-Engineering Exam 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: Jun 03, 2025
-
Rated: 4.9 |
-
Online Users: 448
-
Question 1
-
Choose 2 right combination describing git commands to right use cases 1. commit 2. push 3. merge A. take the changes from one branch and adds them into another (usually main) branch. B. updates a remote branch with the commits made to the current branch C. a user’s change to a file (or set of files) identified by a unique id
Answer: A,C
-
Choose 2 right combination describing git commands to right use cases 1. commit 2. push 3. merge A. take the changes from one branch and adds them into another (usually main) branch. B. updates a remote branch with the commits made to the current branch C. a user’s change to a file (or set of files) identified by a unique id
-
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
-
Identify 2 jinja macros available in generate_schema_name
Answer: B,C
-
Identify 2 jinja macros available in generate_schema_name
-
Question 4
-
Which file is NOT generated by dbt docs generate config --no-compile
Answer: A
-
Which file is NOT generated by dbt docs generate config --no-compile
-
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: