Which Snowflake data modeling approach is designed for BI queries?

Which Snowflake data modeling approach is designed for BI queries?
A . 3NF
B . Star schema
C . Data Vault
D . Snowflake schema

View Answer

Answer: B

Explanation:

A star schema is a Snowflake data modeling approach that is designed for BI queries. A star schema is a type of dimensional modeling that organizes data into fact tables and dimension tables. A fact table contains the measures or metrics of the business process, such as sales amount, order quantity, or profit margin. A dimension table contains the attributes or descriptors of the business process, such as product name, customer name, or order date. A star schema is called so because it resembles a star, with one fact table in the center and multiple dimension tables radiating from it. A star schema can improve the performance and simplicity of BI queries by reducing the number of joins, providing fast access to aggregated data, and enabling intuitive query syntax. A star schema can also support various types of analysis, such as trend analysis, slice and dice, drill down, and roll up12.

Reference: Snowflake Documentation: Dimensional Modeling

Snowflake Documentation: Star Schema