Free Data Build Tool dbt-Analytics-Engineering Exam Questions
Try our Free Demo Practice Tests for Comprehensive dbt-Analytics-Engineering Exam Preparation
-
Data Build Tool dbt-Analytics-Engineering Exam Questions
-
Provided By: Data Build Tool
- Exam: dbt Analytics Engineering Certification
- Certification: dbt Certification
-
Total Questions: 224
-
Updated On: Nov 13, 2024
-
Rated: 4.9 |
-
Online Users: 448
-
Question 1
-
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.
Answer: C
-
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.
-
Question 2
-
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
Answer: D
-
Given the following .yml file
-
Question 3
-
Given the below yaml
sources:
- name: stripe
database: raw
tables:
- name: orders
- name: customers
What is the right compiled code for a model which runs
select *
from {{ source('stripe', 'customers') }}
Answer: C
-
Given the below yaml
-
Question 4
-
Identify 3 snapshot meta fields
Answer: A,B,C
-
-
Question 5
-
Which 2 are NOT valid property for Exposure
Answer: B,C
-