Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 39 of 60
Free Preview · 60 of 198 · questions 1–60 of 198 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
B. Star schema. A star schema is designed for BI and reporting queries: it puts a central fact table (such as sales transactions) around denormalized dimension tables (such as date, product, customer, and region). This typically makes analytical queries and dashboard tools simpler and efficient because it minimizes joins.[exasol +1] • 3NF: suited to normalized operational/integration-oriented models. • Data Vault: suited to scalable, auditable enterprise data integration and historical tracking. • Snowflake schema: normalizes dimension tables further, reducing redundancy but adding joins and query complexity.
This design requires only one level of joins between the fact table and each dimension, resulting in fewer joins in queries and therefore better performance.
In data models for general BI use, it is important to minimize the number of joins. The star schema has a simple structure with a single fact table at the center, directly connected to multiple denormalized dimension tables. This design requires only one level of joins between the fact table and each dimension, resulting in fewer joins in queries and therefore better performance. https://www.databricks.com/glossary/star-schema