Free Online Data Build Tool dbt-Analytics-Engineering Practice Test

Prepare Your Data Build Tool dbt-Analytics-Engineering Exam Questions with Free online dbt-Analytics-Engineering Practice Test. Get Brilliant dbt Analytics Engineering Certification Exam Results with Valid dbt Analytics Engineering Exam Dumps.

Page: 1 / 45

Total 224 Questions | Updated On: May 16, 2024

Add To Cart

Question 1

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') }}"

....

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 2

Which 2 are NOT valid property for Exposure

A : type

B : dependent_models

C : owner_name

D : owner

Answer: B,C

Question 3

Identify 2 jinja macros available in generate_schema_name

A : source

B : log

C : exception

D : tests

Answer: B,C

Question 4

Which is a mandatory property of an metrics resource

A : config

B : timestamp

C : label

D : meta

Answer: C

Question 5

Identify valid dbt commands (choose 2)

A : build refresh

B : run

C : run-operation

D : build-operation

Answer: B,C

Page: 1 / 45

Total 224 Questions | Updated On: May 16, 2024

Add To Cart