Question 1

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

Question 2

Given the following .yml file

name: dbt_labs

models:

dbt_labs:

events:

+enabled: true

+materialized: view

base:

+schema: base

And 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 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

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 5

Which is NOT a step of a typical automated dbt workflow 1. models and analysis are downloaded from multiple source control repositories, 2. code is configured for the given environment, 3. code is tested, and 4. code is deployed.

Options :

A : Only 1

B : All of them

C : None of them

D : 1 and 2

Answer: C

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

Buying Options: