Why is it recommended to keep the profiles.yml file outside of version control when managing multiple dbt environments?

hard🧠 Conceptual Q10 of 15

dbt - Production Deployment

Why is it recommended to keep the profiles.yml file outside of version control when managing multiple dbt environments?

ABecause it contains sensitive credentials that should not be shared

BBecause it is automatically generated by dbt

CBecause it is not needed for running dbt models

DBecause it slows down dbt runs if version controlled

Step-by-Step Solution

Solution:

Step 1: Understand contents of profiles.yml
It stores database credentials and connection info.
Step 2: Security best practice
Keeping credentials out of version control prevents leaks.
Final Answer:
Because it contains sensitive credentials that should not be shared -> Option A
Quick Check:
Security reason = B [OK]

Quick Trick: Keep credentials out of version control for security [OK]

Common Mistakes:

MISTAKES

Master "Production Deployment" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes