Question 1

Identify 2 jinja macros available in generate_schema_name

Options :

A : source

B : log

C : exception

D : tests

Answer: B,C

Question 2

Identify valid dbt commands (choose 2)

Options :

A : build refresh

B : run

C : run-operation

D : build-operation

Answer: B,C

Question 3

Given following .yml config, how dbt behaves if the environment variables are not set when dbt run is invoked

profile:

target: prod

outputs:

prod:

type: postgres

host: 127.0.0.1

# IMPORTANT: Make sure to quote the entire Jinja string here

user: "{{ env_var('DBT_USER') }}"

password: "{{ env_var('DBT_PASSWORD') }}"

....

Options :

A : dbt throws compilation error

B : dbt produces an warning and continue

C : dbt throws an warning and stops execution

D : dbt throws run time error

Answer: A

Question 4

Which function can be used to create automatic dependency between models

Options :

A : ref

B : run

C : from

D : graph

Answer: A

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

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

Buying Options: