Dbt

What file type is used for building a model?

.sql

What technological changes have contributed to the evolution of ETL to ELT?

1. The modern cloud-base data warehouses have scalable storage and compute. 2. Off the shelf data pipeline/extraction tools (Stitch, Fivetran) 3. Self-service business intelligence tools increased the ability for stakeholders to access and analyze data.

What is required to materialize a model in your data platform with dbt?

1. a dbt project with the .sql files saved in models directory 2. a connection to a data warehouse with raw data loaded in 3. dbt_project.yml file

What is dbt core?

A command line tool that can be run locally.

In the dbt context, what is a model?

A select statement written in SQL

Which one of the following is true about dbt connections?

Data is stored in the data platform and code is stored in the git repository.

What are the two ways you can use dbt?

Dbt Core and Dbt Cloud.

Which one of the following is true about dbt in the context of the modern data stack?

Dbt connects directly to your data platform to model data.

Which command below will attempt to only materialize dim_customers and its downstream models?

Dbt run -- select dim_customers+

What is dbt DAG?

Directed acyclic graph: shows data lineage.

Which of the following is true about version control with git in dbt?

Separate branches allow dbt developers to simultaneously work on the same code based without impacting production.

Which one of the following is true about staging models as defined in this course?

Staging models are used to perform light touch transformations to shape the data to how you wish it looked

When working in dbt, which one of the following should always be unique for each dbt developer when working in development?

Target schema

What is dbt cloud?

The hosted version that streamlines development with an online integrated develop environment (IDE) and an interface to run dbt on a schedule.

Dbt is a part of which step of the ELT process?

Transform

How do you build dependencies between models?

Use the 'ref' function in the from clause of a model.

What is the default materialization of a model if you don't proactively configure the materialization for a model?

View

Which of the following is a benefit of using subdirectories in your models directory?

Which of the following is a benefit of using subdirectories in your models directory?

What are YAML files?

YAML files are used for configuring generic tests.

Which of the following is true about YAML files in dbt?

YAML files are used for configuring generic tests.