Bird
0
0

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:
  1. Step 1: Understand contents of profiles.yml

    It stores database credentials and connection info.
  2. Step 2: Security best practice

    Keeping credentials out of version control prevents leaks.
  3. Final Answer:

    Because it contains sensitive credentials that should not be shared -> Option A
  4. Quick Check:

    Security reason = B [OK]
Quick Trick: Keep credentials out of version control for security [OK]
Common Mistakes:
MISTAKES
  • Thinking profiles.yml is auto-generated
  • Believing it is unnecessary for dbt runs
  • Assuming version control affects performance

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes