Question 1

Which is a mandatory property of an Exposure resource

Options :

A : url

B : type

C : description

D : maturity

Answer: B

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

Which statement best describes snapshot feature in dbt

Options :

A : Snapshots implement type-1 Slowly Changing Dimensions

B : Snapshots implement type-2 Slowly Changing Dimensions

C : Snapshot implements fact less facts

D : Snapshot implements incremental data loading strategy

Answer: B

Question 4

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 5

Given following .yml config, how dbt behaves if the environment variables are not set when dbt run is invoked

profile:

target: prod

outputs:

prod:

type: postgres

host: 127.0.0.1

# IMPORTANT: Make sure to quote the entire Jinja string here

user: "{{ env_var('DBT_USER') }}"

password: "{{ env_var('DBT_PASSWORD') }}"

....

Options :

A : dbt throws compilation error

B : dbt produces an warning and continue

C : dbt throws an warning and stops execution

D : dbt throws run time error

Answer: A