The ____ schema is designed to optimize data query operations rather than data update operations.
A) relational
B) circle
C) star
D) matrix

Question

Quizplus · Accepted Answer

The star schema is designed to optimize data query operations by organizing data into a central fact table with related dimension tables branching off of it. The fact table contains the lowest level of detail and is surrounded by dimension tables that provide context for the data. This structure allows for efficient querying and analysis of large datasets. However, it may be less suitable for data update operations, as changes to the structure of the schema can be more difficult to implement.

The ____ Schema Is Designed to Optimize Data Query Operations