Databases designed to support a dimensional examination and aggregation are referred to as ________.

Databases designed to support a dimensional examination and aggregation are referred to as ________.

• A. OLTP Systems
• B. OLAP Systems
• C. Graph Databases
• D. Key-Value Stores

Answer: (B)

OLAP systems are designed for analytics with a multidimensional view of data. They organize data by dimensions (like time, geography, product) and measures, enabling fast aggregations and complex queries such as rolling up to a higher level, drilling down into details, and slicing or dicing the data to see different perspectives. This supports dimensional examination and cross-cutting analysis across large datasets, which is why they’re used for business intelligence and reporting. OLTP systems, in contrast, optimize for day-to-day transactions and data integrity; graph databases focus on relationships between entities; and key-value stores are built for fast key-based retrieval rather than multi-dimensional analysis.

OLAP systems are designed for analytics with a multidimensional view of data. They organize data by dimensions (like time, geography, product) and measures, enabling fast aggregations and complex queries such as rolling up to a higher level, drilling down into details, and slicing or dicing the data to see different perspectives. This supports dimensional examination and cross-cutting analysis across large datasets, which is why they’re used for business intelligence and reporting.

OLTP systems, in contrast, optimize for day-to-day transactions and data integrity; graph databases focus on relationships between entities; and key-value stores are built for fast key-based retrieval rather than multi-dimensional analysis.