Question 1

Which is a mandatory property of an Exposure resource

Options :

A : url

B : type

C : description

D : maturity

Answer: B

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

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 4

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 5

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

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

Buying Options: