Free Data Build Tool dbt-Analytics-Engineering Exam Questions

Become Data Build Tool Certified with updated dbt-Analytics-Engineering exam questions and correct answers

Page: 1 / 45

Total 224 Questions | Updated On: Oct 28, 2025

Add To Cart

Question 1

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 : selectorder_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.paymentsgroup by 1

B : selectorder_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.paymentsgroup by 1

C : selectorder_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.paymentsgroup by 1

D : Compile Error

Answer: A

Question 2

Given the below yamlsources: - name: stripe database: raw tables: - name: orders - name: customersWhat is the right compiled code for a model which runsselect * 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 3

Which 2 platforms are supported by dbt

A : Databricks

B : MongoDB

C : Dremio

D : Casandra

Answer: A,C

Question 4

Identify valid dbt commands (choose 2)

A : build refresh

B : run

C : run-operation

D : build-operation

Answer: B,C

Question 5

Given the snapshot config, how check_cols will be used{{ config( target_schema='history', target_database='analytics', strategy='timestamp', unique_key='id', updated_at='updated_at', check_cols=[“col_1”, “col_2”] ) }}

A : check_cols will be ignored

B : updated_at column will be used to determine changes first and check_cols will be used in case of any duplicate

C : Snapshot will check all columns in check_cols for changes

D : updated_at and col_1 will be used for snapshot

Answer: A

Page: 1 / 45

Total 224 Questions | Updated On: Oct 28, 2025

Add To Cart