Database Management Systems

Business Intelligence (BI) systems combine all three functions: they aggregate and present data in meaningful ways (A), enable better decision-making through data-driven insights (B), and provide analytical perspectives on business questions (C). BI is a comprehensive approach to transforming raw data into actionable business insights.

A data warehouse is characterized by four key properties: subject-oriented (organized by major subject areas), integrated (data from multiple sources unified), non-volatile (once loaded, data doesn't change), and time-variant (data reflects historical changes over time). These distinguish it from operational databases that are volatile and current-focused.

A data mart is a focused subset of an enterprise data warehouse, tailored to specific departmental needs (C). It extends warehouse capabilities to business units (B) and serves as a natural extension of the overall warehousing architecture (A). Data marts provide optimized, department-specific views while maintaining consistency with enterprise data.

OLTP (Online Transactional Processing) handles day-to-day operational transactions like orders and updates, while OLAP (Online Analytical Processing) supports complex analytical queries and reporting on historical data. They serve different purposes: OLTP for operational efficiency, OLAP for business intelligence and decision support.

An Operational Data Store (ODS) contains detailed, current data drawn directly from operational systems, not summarized aggregates. This detailed granularity enables operational reporting and real-time analysis but results in large data volumes since no aggregation occurs.

Data warehouses use dimensional modeling (star schema, snowflake schema) to optimize query performance for analytical workloads, unlike transactional systems designed for rapid updates. Dimensional modeling organizes data into fact tables (measurements) and dimension tables (descriptive attributes) for efficient multi-dimensional analysis.

Dimension tables contain descriptive, contextual attributes that provide meaning to numerical measurements in fact tables. These include relatively static reference data like product names, customer demographics, geographic information, or time periods. Dimensions serve as the 'who, what, where, when' for analytical queries.

Fact tables store quantitative measurements or metrics (facts) along with foreign key references to dimension tables. These foreign keys connect each measurement record to its dimensional context (e.g., which product, which customer, which time period). Facts are typically numeric and additive across dimensions.

In dimensional modeling schemas, core schema objects include Attributes (descriptive properties), Facts (measurable metrics), and Hierarchies (organized level structures). These elements form the foundation of dimensional models used in data warehousing and OLAP systems. Filters are query-time mechanisms, not schema definition objects.

In MicroStrategy, Report Filters apply conditions directly at the data warehouse level by modifying the SQL WHERE clause sent to the database. View Filters are applied after data retrieval, filtering the result set already returned from the warehouse. This distinction is crucial for query performance optimization.

Consolidations in MicroStrategy are custom groupings created by combining specific attribute elements into logical sets. For example, you can create a consolidation called 'West Coast' by grouping specific state attribute elements like 'CA', 'OR', 'WA'. They are not created from filters, which are conditions rather than element groupings.

A database view is a virtual table representing the result of a pre-defined SQL query. It does not store data physically but can be queried using standard SQL commands just like a normal table. Distractors are incorrect because views can be accessed via SQL, unlike tables which physically store data.