Question 1

Given the following .yml filename: dbt_labsmodels:dbt_labs: events: +enabled: true +materialized: view base: +schema: baseAnd following config are defined in events/base/model_a.sql{{ config( schema=analytics) }}in which schema the model mart/stripe/model_b.sql will be created

Options :

A : It will be an compile error

B : base

C : analytics

D : default schema

Answer: D

Question 2

Identify 3 snapshot meta fields

Options :

A : dbt_scd_id

B : dbt_valid_to

C : dbt_valid_from

D : dbt_scd_latest

Answer: A,B,C

Question 3

Which file is NOT generated by dbt docs generate config --no-compile

Options :

A : target/manifest.json

B : Both of them

C : None of them

D : target/catalog.json

Answer: A

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 : 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 5

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

Confidently Practice Online with Free dbt-Analytics-Engineering Exam Cram

Buying Options: