What type of data model is commonly used in BI tools to optimize query performance?

  • Hierarchical schema
  • Relational schema
  • Snowflake schema
  • Star schema
Star schema is commonly used in BI tools to optimize query performance. It consists of a central fact table linked to multiple dimension tables, allowing for efficient data retrieval and analysis.
Add your answer
Loading...

Leave a comment

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