Question 1

Which is a mandatory property of an metrics resource

Options :

A : config

B : timestamp

C : label

D : meta

Answer: C

Question 2

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 3

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 4

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 5

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

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

Buying Options: