What is the primary characteristic of a Star Schema?
- Each dimension table is connected to other dimension tables
- Each dimension table is directly connected to the fact table
- Fact table is absent in the schema
- Fact table is organized in a snowflake pattern
In a Star Schema, the primary characteristic is that each dimension table is directly connected to the fact table. This results in a simple and straightforward structure, making it easier to understand and query data for analytical purposes.
Loading...
Related Quiz
- Scenario: A large development team is working on a database project using ER diagram tools. How can version control features in these tools help manage changes and track revisions effectively?
- How does Dimensional Modeling differ from Entity-Relationship Modeling?
- Which operation is used for summarization in SQL?
- Scenario: A team of developers is tasked with designing a database for a large e-commerce platform. They need a tool that can handle complex data models and allow for seamless collaboration. Which database design tool would you recommend, and why?
- What are some common methods used to monitor database performance?