A database consists of one fact table that is composed of multiple dimensions. Each dimension is represented by a denormalized table. This structure is an example of a:
Astar schemahas a central fact table linked to multiple dimension tables. The dimension tables are typically denormalized, meaning data is stored in a flat, non-normalized format for faster query performance. This design enables efficient queries in data warehousing and business intelligence.
CompTIA Data+ Reference:
CompTIA Data+ Study Guide (Exam DA0-001), Chapter 3: Databases and Data Sources, Section “Star Schema Design and Usage”, Official CompTIA CertMaster Learn for Data+, Module 3.6 “Data Warehousing Schemas”.
References Used:
CompTIA Data+ Study Guide (Exam DA0-001) – Official Sybex/CompTIA Book
CompTIA CertMaster Learn for Data+ – Official CompTIA Learning Modules
CompTIA Data+ Objectives (DA0-001)
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit