Smartly Prepare Exam with Free Online dbt-Analytics-Engineering Practice Test

We offer the latest dbt-Analytics-Engineering practice test designed for free and effective online dbt Analytics Engineering Certification certification preparation. It's a simulation of the real dbt-Analytics-Engineering exam experience, built to help you understand the structure, complexity, and topics you'll face on exam day.

Question 1

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 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

Which file is NOT generated by dbt docs generate config --no-compile

Options :

A : target/manifest.json

B : Both of them

C : None of them

D : target/catalog.json

Answer: A

Question 4

Which is a mandatory property of an Exposure resource

Options :

A : url

B : type

C : description

D : maturity

Answer: B

Question 5

Given the snapshot config, how check_cols will be used

{{

config(

target_schema='history',

target_database='analytics',

strategy='timestamp',

unique_key='id',

updated_at='updated_at',

check_cols=[“col_1”, “col_2”]

)

}}

Options :

A : check_cols will be ignored

B : updated_at column will be used to determine changes first and check_cols will be used in case of any duplicate

C : Snapshot will check all columns in check_cols for changes

D : updated_at and col_1 will be used for snapshot

Answer: A