Data Warehousing and Business Intelligence MCQs

Isolation controls how concurrent transactions see each other’s changes.
It is central to reliable operational processing, especially under heavy concurrency.

Warehouses require continuous monitoring, tuning, data-quality management, and enhancement.
They must evolve as sources, volumes, and analytical needs change.

Staging isolates source extraction from warehouse loading.
It supports cleansing, reconciliation, restartability, and controlled transformation.

ROLAP leaves data in relational structures and generates SQL for analysis.
It can scale to large volumes but depends strongly on relational query performance.

Metadata explains what data means and how it is organized or produced.
It supports discovery, governance, lineage, and correct interpretation.

Tactical decisions translate strategy into medium-term plans and resource allocation.
Regional budget allocation is narrower and shorter-term than enterprise strategy.

Users adopt BI when it answers real questions in understandable terms.
Alignment, training, trust, and usability matter more than tool quantity.

OLAP questions often require multiple joins, filters, groups, and calculations.
OLTP statements are usually narrow and designed for a specific transaction.

Incremental releases let users validate data and functionality sooner.
Lessons from each iteration improve later design and reduce large-project risk.

The bus architecture integrates incremental dimensional solutions through conformed dimensions and facts.
This enables consistency while delivering business processes in stages.

MOLAP processes data into optimized multidimensional storage.
This often provides fast query performance at the cost of processing and storage overhead.

Decision support depends on reliable information from multiple periods and sources.
Warehouses provide that analytical foundation without burdening operational systems.