A company wants to analyze its sales data over the past decade, broken down by region, product, and month. What data warehousing architecture and component would best support this analysis?

  • Data Vault and Real-Time Analytics
  • Inmon Architecture and ETL Process
  • Snowflake Schema and Data Mart
  • Star Schema and OLAP Cube
To support in-depth sales data analysis with dimensions like region, product, and time, the best choice would be a Star Schema in the data warehousing architecture. OLAP Cubes are used to efficiently process complex queries and aggregations. Star Schema's simplicity and denormalized structure are well-suited for such analytical tasks.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *