Free DBT Project Development Questions and Answers

Question 1

Which command initializes a new dbt project in your working directory?

Accepted Answer

dbt init

Answer

dbt start

Answer

dbt new-project

Answer

dbt create

Question 2

Where are dbt model SQL files typically stored inside a dbt project structure?

Accepted Answer

models/

Answer

data/

Answer

seeds/

Answer

logs/

Question 3

What is the primary function of the 'dbt_project.yml' file?

Accepted Answer

Project configuration and settings

Answer

Database credentials

Answer

Log storage

Answer

Model documentation

Question 4

Which command is used to validate the structure and syntax of a dbt project?

Accepted Answer

dbt debug

Answer

dbt check

Answer

dbt compile

Answer

dbt seed

Question 5

What is the purpose of the 'macros/' directory in a dbt project?

Accepted Answer

Houses reusable Jinja-based SQL snippets

Answer

Stores model descriptions

Answer

Manages logs

Answer

Holds compiled models

Question 6

Which file defines the packages and dependencies required by a dbt project?

Accepted Answer

packages.yml

Answer

dbt_project.yml

Answer

profiles.yml

Answer

models.sql

Question 7

Which dbt command creates the compiled SQL files and saves them in the target directory without running them?

Accepted Answer

dbt compile

Answer

dbt build

Answer

dbt clean

Answer

dbt snapshot

Question 8

Which directory in a dbt project is typically used to store static CSV data for loading into the warehouse?

Accepted Answer

data/

Answer

macros/

Answer

logs/

Answer

snapshots/

Question 9

What is the purpose of 'dbt clean' command?

Accepted Answer

Deletes compiled and package directories

Answer

Runs all models

Answer

Applies incremental updates

Answer

Generates documentation