Question 1

Identify valid dbt commands (choose 2)

Options :

A : build refresh

B : run

C : run-operation

D : build-operation

Answer: B,C

Question 2

What best describes var() in dbt

Options :

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 3

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

Options :

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

Question 4

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"

Options :

A : View

B : Increamental

C : Ephemerea

D : Table

Answer: A

Question 5

Which is a mandatory property of an Exposure resource

Options :

A : url

B : type

C : description

D : maturity

Answer: B

Free dbt-Analytics-Engineering Mock Exam – Practice Online Confidently

Buying Options: