Question 1

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 2

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 3

Which 2 platforms are supported by dbt

Options :

A : Databricks

B : MongoDB

C : Dremio

D : Casandra

Answer: A,C

Question 4

Given following configuration in dbt_project.yml file: target-path: compiled-target where will the artefacts be generated if dbt compile command is issued

Options :

A : /target

B : /target-path

C : /compiled-target

D : /target/compiled-target

Answer: C

Question 5

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

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

Buying Options: