Data Warehousing and Business Intelligence MCQs

Reconciliation confirms completeness and numerical consistency across the load.
Differences must be explained by documented transformation rules or corrected.

A natural hierarchy follows real one-to-many relationships between adjacent levels.
Each city belongs to one state and each state belongs to one country in the modeled structure.

Sets define the members or tuples displayed on rows, columns, or filters.
They can be explicitly listed or generated through expressions.

Conformed dimensions enable facts from different processes to be analyzed together.
Shared Date, Product, and Customer dimensions create enterprise consistency.

An inferred member provides a valid surrogate key for early-arriving facts.
Its attributes are updated when the complete source dimension record arrives.

Leaving free page space can reduce page splits for future inserts.
Too much free space, however, increases storage and read I/O.

Incremental loads reduce data movement and processing time.
They require a dependable way to identify inserts, updates, and sometimes deletes.

Idempotence makes retries safe after uncertain failures.
The process recognizes already applied data or replaces a defined target scope consistently.

Attribute relationships tell the engine how dimension members roll up.
Accurate relationships enable better aggregation choices and more efficient queries.

MOLAP stores optimized multidimensional data and summaries.
Processing must refresh that storage whenever source data changes.

A Date dimension gives users rich, standardized time attributes.
It supports fiscal calendars, weekdays, holidays, and hierarchies without repeated logic.

An outrigger normalizes a reusable set of dimension attributes outside the main dimension.
It should be used carefully because it introduces additional joins into a dimensional model.