ARA-C01 · Question #54
Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).
The correct answer is B. Dimensional/Kimball D. lnmon/3NF F. Data vault. Snowflake's relational engine supports the three dominant enterprise data warehousing modeling methodologies. B: Dimensional/Kimball modeling organizes data into fact and dimension tables (star or snowflake schemas), optimized for BI query patterns. D: Inmon/3NF (Third Normal…
Question
Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).
Options
- AGraph model
- BDimensional/Kimball
- CData lake
- Dlnmon/3NF
- EBayesian hierarchical model
- FData vault
How the community answered
(46 responses)- A2% (1)
- B96% (44)
- C2% (1)
Explanation
Snowflake's relational engine supports the three dominant enterprise data warehousing modeling methodologies. B: Dimensional/Kimball modeling organizes data into fact and dimension tables (star or snowflake schemas), optimized for BI query patterns. D: Inmon/3NF (Third Normal Form) is the normalized relational approach that eliminates redundancy and is common for enterprise data warehouses and operational data stores. F: Data Vault uses hubs (business keys), links (relationships), and satellites (attributes) to provide a highly auditable, flexible historical model suited for large enterprises. Options A (graph), C (data lake), and E (Bayesian hierarchical) are not standard relational data warehousing models - graph models require graph databases, data lake is a storage paradigm not a table model, and Bayesian hierarchical is a statistical modeling concept.
Topics
Community Discussion
No community discussion yet for this question.