SnowPro Advanced: Architect — Question 29

Which Snowflake data modeling approach is designed for BI queries?

Answer options

• A. 3 NF
• B. Star schema
• C. Data Vault
• D. Snowflake schema

Correct answer: B

Explanation

The Star schema is optimized for BI queries as it simplifies data retrieval through its denormalized structure, allowing for faster query performance. The other options, such as 3 NF, Data Vault, and Snowflake schema, are more complex and not as efficient for BI reporting purposes.