Question 1

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 2

What best describes var() in dbt

Options :

A : function can be used to incorporate Environment Variables from the system into your dbt project

B : can be passed from your dbt_project.yml file into models during compilation

C : outputs a UUID generated for this dbt command. This value is useful when auditing or analyzing dbt invocation metadata.

D : variable returns the installed version of dbt that is currently running

Answer: B

Question 3

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 4

Identify 3 snapshot meta fields

Options :

A : dbt_scd_id

B : dbt_valid_to

C : dbt_valid_from

D : dbt_scd_latest

Answer: A,B,C

Question 5

Given the following .yml file

name: dbt_labs

models:

dbt_labs:

events:

+enabled: true

+materialized: view

base:

+schema: base

And following config are defined in events/base/model_a.sql

{{ config(

schema=analytics

) }}

in which schema the model mart/stripe/model_b.sql will be created

Options :

A : It will be an compile error

B : base

C : analytics

D : default schema

Answer: D

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

Buying Options: