Question 1

Given the below properties, how marts/model_a.sql will be materialized

models:

my_project:

dwh:

# materialize all models in models/events as tables

+materialized: incremental

marts:

# this is redundant, and does not need to be set

+materialized: table

Options :

A : View

B : Table

C : Incremental

D : Ephemeral

Answer: B

Question 2

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 3

Which function can be used to create automatic dependency between models

Options :

A : ref

B : run

C : from

D : graph

Answer: A

Question 4

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') }}

Options :

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 5

Which is a mandatory property of an metrics resource

Options :

A : config

B : timestamp

C : label

D : meta

Answer: C

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

Buying Options: