Installing and initializing a dbt project - Practice Exercises

Challenge - 5 Problems

❓ Predict Output

intermediate

What is the output of the dbt command?

You run the command dbt init my_project in your terminal. What is the expected outcome?

dbt

dbt init my_project

A A new directory named 'my_project' is created with sample dbt project files inside.

B dbt installs all dependencies but does not create any project files.

C An error occurs because 'my_project' is not a valid dbt command argument.

D dbt connects to the database and runs all models immediately.

💡 Hint

Think about what the 'init' command does in dbt.

The 'dbt init' command creates a new project directory with starter files to help you begin your dbt project.

🧠 Conceptual

intermediate

What is the purpose of the profiles.yml file in dbt?

After initializing a dbt project, you see a file named profiles.yml. What is its main role?

A It stores database connection details and credentials for your dbt project.

B It contains the SQL code for your data models.

C It lists all installed dbt packages and plugins.

D It defines the visualizations and dashboards for your data.

💡 Hint

Think about where dbt needs to connect to run your models.

The profiles.yml file holds connection info like database type, host, user, and password so dbt can access your data warehouse.

🔧 Debug

advanced

Why does this dbt command fail?

You run dbt run immediately after dbt init without any changes. Why might it fail?

dbt

dbt run

A Because 'dbt run' needs a specific model name as an argument.

B Because 'dbt run' only works after you have installed dbt packages.

C Because the default sample model is missing or not configured properly.

D Because dbt requires a database connection set up in profiles.yml before running models.

💡 Hint

Check if dbt knows where to connect to run your models.

Without a valid profiles.yml with connection info, dbt cannot run models and will error out.

🚀 Application

advanced

How to initialize a dbt project with a specific adapter?

You want to create a new dbt project that uses the Snowflake adapter. Which command correctly initializes this?

A dbt new my_snowflake_project --adapter snowflake

B dbt init my_snowflake_project

C dbt init my_snowflake_project --adapter snowflake

D dbt init my_snowflake_project --profile snowflake

💡 Hint

The adapter is set in profiles.yml, not during init.

The 'dbt init' command does not take an adapter argument; you set the adapter in your profiles.yml after initialization.

❓ data_output

expert

What files are created after running 'dbt init'?

After running dbt init example_project, which of the following files will you find inside the new project folder?

A setup.py, models/example_project.sql, dbt.lock

B profiles.yml, requirements.txt, Dockerfile

C dbt_project.yml, models/example_project.sql, README.md

D config.json, main.py, models/example_project.sql

💡 Hint

Look for typical dbt project files created by default.

The 'dbt init' command creates a dbt_project.yml file, a models folder with a sample SQL file, and a README.md file.