Practice dbt-Analytics-Engineering Exam Online

Question 1

What best describes var() in dbt

A : function can be used to incorporate Environment Variables from the system into your dbt project

B : can be passed from your dbt_project.yml file into models during compilation

C : outputs a UUID generated for this dbt command. This value is useful when auditing or analyzing dbt invocation metadata.

D : variable returns the installed version of dbt that is currently running

Answer: B

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

A : TRUE

B : FALSE

Answer: B

Question 3

Given the below yaml

sources:

- name: stripe

database: raw

tables:

- name: orders

- name: customers

What is the right compiled code for a model which runs

select *

from {{ source('stripe', 'customers') }}

A : select * from raw.stripe.orders

B : select * from stripe.stripe.customers

C : select * from raw.stripe.customers

D : select * from stripe.stripe.orders

Answer: C

Question 4

Which is a mandatory property of an metrics resource

A : config

B : timestamp

C : label

D : meta

Answer: C

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

A : select

order_id,

sum(case when payment_method = 'bank_transfer' then amount end) as bank_transfer_amount

,

sum(case when payment_method = 'credit_card' then amount end) as credit_card_amount

,

sum(case when payment_method = 'gift_card' then amount end) as gift_card_amount,

from raw_jaffle_shop.payments

group by 1

B : select

order_id,

sum(case when payment_method = 'bank_transfer' then amount end) as bank_transfer_amount

,

sum(case when payment_method = 'credit_card' then amount end) as credit_card_amount

,

sum(case when payment_method = 'gift_card' then amount end) as gift_card_amount

from raw_jaffle_shop.payments

group by 1

C : select

order_id,

sum(case when payment_method = 'bank_transfer' then amount end) as bank_transfer_amount

,

sum(case when payment_method = 'credit_card' then amount end) as credit_card_amount

from raw_jaffle_shop.payments

group by 1

D : Compile Error

Answer: A

Name:	dbt Analytics Engineering Certification
Exam Code:	dbt-Analytics-Engineering
Certification:	dbt Certification
Vendor:	Data Build Tool
Total Questions:	289
Last Updated:	Apr 01, 2026

Data Build Tool dbt-Analytics-Engineering Answers