Q: What are the key benefits of star and snowflake schemas? Select all that apply.
or
Q: What are the principal advantages of the snowflake and star schemas? Choose every option that pertains.
- Efficient data analysis
- Effective data monitoring
- High-scale information delivery
- More efficient output
Explanation: Both schemas are designed to optimize data retrieval for analytical queries, making it easier and faster to analyze data. These schemas support scalable data models, allowing for efficient querying and reporting, even as data volume increases. Star and snowflake schemas improve query performance by organizing data in a way that minimizes redundancy and speeds up data retrieval.
