A data architect is setting up a repository for sales data that includes a central record of daily transactions and several smaller tables for product details, locations, and customer segments. What type of structure provides efficient analytics for this design?
A normalized structure that uses extensive relationships across multiple tables
A design with a main record table linking surrounding references for faster queries
An unstructured approach that stores information without defined fields
A multi-level layout that links specialized tables through multiple bridging tiers
This approach is sometimes known as a star arrangement because it positions a main table as the hub and links specialized data in nearby tables. The alternative designs do not match this central pattern. A multi-level arrangement creates deeper branching, which can be more complex. A normalized approach spreads data across many relationships, which can affect query performance. An unstructured layout does not define schema elements, which can be less suitable for structured reporting.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a star schema in database design?
Open an interactive chat with Bash
What are the advantages of using a centralized record table?
Open an interactive chat with Bash
What are dimension tables, and why are they important?