Which Snowflake data modeling approach is designed for BI queries?
Which Snowflake data modeling approach is designed for BI queries?
The Star schema is commonly used for business intelligence (BI) queries because it is designed to simplify complex query logic and optimize performance. It includes a central fact table that contains measurable, quantitative data, which is connected to multiple dimension tables that provide descriptive attributes related to the facts. This structure allows for intuitive and efficient querying, making it ideal for BI applications.
Answer is B and is validated
isn't star schema a better option?
B is correct.
B. Star schema The star schema is a common data modeling approach used specifically for optimizing BI queries. It features a central fact table linked to dimension tables, which radiate from the fact like points on a star. This design simplifies queries, improves data retrieval speed, and is highly effective for BI applications where performance and simplicity are key. While Snowflake's architecture can support various data modeling techniques like 3NF (Third Normal Form), Data Vault, and Snowflake schema (which is a variation of star schema with normalized dimension tables), the star schema remains the preferred choice for BI-focused workloads due to its straightforward structure and query efficiency.
https://www.snowflake.com/blog/support-multiple-data-modeling-approaches-with-snowflake/
I think its B
I guess that is C https://community.snowflake.com/s/article/Snowflake-Data-Vault-Reference-Architecture