A financial institution is looking to build a data warehouse to analyze historical transaction data over the last decade. They need a solution that allows complex analytical queries. Which type of schema would be most suitable for this use case?

  • Star Schema
  • Snowflake Schema
  • Factless Fact Table
  • NoSQL Database
A Star Schema is the best choice for a data warehouse designed for complex analytical queries. It provides a denormalized structure that optimizes query performance. Snowflake Schema is similar but more normalized. Factless Fact Table is used for scenarios without measures. NoSQL databases are not typically used for traditional data warehousing.
Add your answer
Loading...

Leave a comment

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