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.
Loading...
Related Quiz
- How does data profiling contribute to data validation in ETL processes?
- In a healthcare application that relies on real-time data integration, what testing approach should be used to ensure data privacy and security compliance?
- In ETL testing, what advanced technique can be utilized in automated testing but not in manual testing?
- To protect sensitive data, ETL processes often implement ________ to restrict data access.
- Which BI tool feature is essential for effective data visualization?