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:

In the context of business intelligence (BI) queries, which are typically focused on data analysis and reporting, the star schema is the most suitable data modeling approach.

Option B: Star Schema – The star schema is a type of relational database schema that is widely used for developing data warehouses and data marts for BI purposes. It consists of a central fact table surrounded by dimension tables. The fact table contains the core data metrics, and the dimension tables contain descriptive attributes related to the fact data. The simplicity of the star schema allows for efficient querying and aggregation, which are common operations in BI reporting.