Question 1

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 2

Choose 2 right combination describing git commands to right use cases 1. commit 2. push 3. merge A. take the changes from one branch and adds them into another (usually main) branch. B. updates a remote branch with the commits made to the current branch C. a user’s change to a file (or set of files) identified by a unique id

Options :

A : 1 --> C

B : 1 --> B

C : 3 --> A

D : 3 --> C

Answer: A,C

Question 3

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 4

Which function can be used to create automatic dependency between models

Options :

A : ref

B : run

C : from

D : graph

Answer: A

Question 5

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

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

Buying Options: