Question 1

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 2

Which is NOT a step of a typical automated dbt workflow 1. models and analysis are downloaded from multiple source control repositories, 2. code is configured for the given environment, 3. code is tested, and 4. code is deployed.

Options :

A : Only 1

B : All of them

C : None of them

D : 1 and 2

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

Which statement best describes snapshot feature in dbt

Options :

A : Snapshots implement type-1 Slowly Changing Dimensions

B : Snapshots implement type-2 Slowly Changing Dimensions

C : Snapshot implements fact less facts

D : Snapshot implements incremental data loading strategy

Answer: B

Question 5

Which 2 platforms are supported by dbt

Options :

A : Databricks

B : MongoDB

C : Dremio

D : Casandra

Answer: A,C

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

Buying Options: