All MCQs

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

A late-arriving fact belongs to an earlier business period but is loaded later.
Historical aggregates and reports may need restatement to include it.

The fact references a dimension member not yet available in the warehouse.
An inferred member can preserve the fact until full dimension details arrive.

Fact foreign keys should remain valid and referentially consistent.
A special dimension member represents the legitimate absence of a promotion.

Cardinality indicates how many unique members occur in an attribute.
It influences storage, compression, indexing, and visualization choices.

Dimension attributes describe entities and are used for labels, filters, and grouping.
Measures such as amounts and quantities normally belong in fact tables.

A level is one stage of detail within a hierarchy.
Users can roll up from City to State or drill down from Country toward State.

Hierarchies organize attributes from summarized to detailed levels.
Examples include Year–Quarter–Month–Date and Country–Region–City.

A bridge stores associations and sometimes allocation weights for multivalued relationships.
Examples include customers belonging to multiple groups or patients having multiple diagnoses.

Snowflaking decomposes dimensions into normalized subdimensions.
It reduces some redundancy but adds joins and complexity for users.

A star schema places measurable events at the center and descriptive dimensions around them.
Its simple joins make analytical models understandable and efficient.

Accumulating snapshots track a process with a predictable beginning and end.
The same row is updated as milestone dates and durations become known.