Question 1

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 2

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 3

Given following model code

Select col_1, col_2 From {{ ref(‘model_a’) }}

While running dbt run, following error occurred: table does not exist What is the most likely error (Choose 2)

Options :

A : Wrong Database or Schema

B : Not enough permission

C : Wrong Adapter

D : Wrong table name

Answer: A,B

Question 4

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 5

Given the snapshot config, how check_cols will be used

{{

config(

target_schema='history',

target_database='analytics',

strategy='timestamp',

unique_key='id',

updated_at='updated_at',

check_cols=[“col_1”, “col_2”]

)

}}

Options :

A : check_cols will be ignored

B : updated_at column will be used to determine changes first and check_cols will be used in case of any duplicate

C : Snapshot will check all columns in check_cols for changes

D : updated_at and col_1 will be used for snapshot

Answer: A

Higher Test Marks with Free Online dbt-Analytics-Engineering Exam Practice

Buying Options: