Bird
0
0

Which of the following is the correct syntax for naming a dbt model that represents a customer dimension table?

easy📝 Syntax Q3 of 15
dbt - Project Organization
Which of the following is the correct syntax for naming a dbt model that represents a customer dimension table?
Acustomer_dim
Bstg_customer
Cfct_customer
Ddim_customer
Step-by-Step Solution
Solution:

  1. Step 1: Understand dimension table naming

    Dimension tables in dbt are typically prefixed with dim_ followed by the subject.

  2. Step 2: Check each option

    dim_customer matches the convention; customer_dim reverses order; fct_customer is for fact tables; stg_customer is staging.

  3. Final Answer:

    dim_customer -> Option D

  4. Quick Check:

    Dimension tables start with dim_ [OK]
Quick Trick: Use dim_ prefix for dimension tables [OK]
Common Mistakes:
MISTAKES
  • Placing prefix after the name
  • Using fact or staging prefixes for dimension tables
  • Mixing naming order

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More dbt Quizzes
Advanced Testing - Store test failures for analysis - Quiz 5medium Advanced Testing - Unit testing dbt models - Quiz 2easy Advanced Testing - Unit testing dbt models - Quiz 8hard Incremental Models - Unique key for merge behavior - Quiz 12easy Jinja in dbt - if/else logic in models - Quiz 14medium Jinja in dbt - if/else logic in models - Quiz 15hard Jinja in dbt - Why Jinja makes SQL dynamic - Quiz 11easy Jinja in dbt - Calling macros across projects - Quiz 12easy Packages and Reusability - Creating your own dbt package - Quiz 13easy Project Organization - dbt_project.yml configuration - Quiz 5medium