Bird
0
0

You want to create a naming convention for a large dbt project with multiple teams. Which approach best supports scalability and clarity?

hard📝 Application Q8 of 15
dbt - Project Organization
You want to create a naming convention for a large dbt project with multiple teams. Which approach best supports scalability and clarity?
AUse random prefixes to avoid conflicts and keep names short
BUse clear prefixes like stg_, int_, dim_, fct_ and include team initials in model names
CUse only the model purpose without prefixes to keep names simple
DUse numeric codes instead of descriptive names for faster lookups
Step-by-Step Solution
Solution:
  1. Step 1: Consider naming clarity and team collaboration

    Clear prefixes help identify model types; adding team initials helps track ownership.
  2. Step 2: Evaluate other options

    Random prefixes or numeric codes reduce clarity; no prefixes make it hard to identify model roles.
  3. Final Answer:

    Use clear prefixes like stg_, int_, dim_, fct_ and include team initials in model names -> Option B
  4. Quick Check:

    Clear prefixes + team IDs = scalable naming [OK]
Quick Trick: Combine clear prefixes with team IDs for scale [OK]
Common Mistakes:
MISTAKES
  • Using random or numeric prefixes
  • Skipping prefixes for simplicity
  • Ignoring team ownership in names

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes