100% Free Data Build Tool dbt-Analytics-Engineering Practice Test Questions

Question 1

Identify 3 snapshot meta fields

A : dbt_scd_id

B : dbt_valid_to

C : dbt_valid_from

D : dbt_scd_latest

Answer: A,B,C

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

A : 1 --> C

B : 1 --> B

C : 3 --> A

D : 3 --> C

Answer: A,C

Question 3

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)

A : Wrong Database or Schema

B : Not enough permission

C : Wrong Adapter

D : Wrong table name

Answer: A,B

Question 4

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

A : 1 --> C

B : 1 --> B

C : 3 --> A

D : 3 --> C

Answer: A,C

Question 5

Which is a mandatory property of an Exposure resource

A : url

B : type

C : description

D : maturity

Answer: B

Free Practice Data Build Tool dbt-Analytics-Engineering Exam Questions 2025