2025-26-1S-COGNATES3-IST3-SFEXAM

A slowly changing dimension (SCD) Type 2 captures __________ history.

• a. Current only
• b. Full
• c. No
• d. Random

A role-playing dimension allows one dimension to serve __________ roles.

• a. One
• b. Multiple
• c. Static
• d. None

A junk dimension groups __________ attributes into one table.

• a. Numeric
• b. Miscellaneous
• c. Historical
• d. Time

Degenerate dimensions are stored in the __________ table.

• a. Dimension
• b. Fact
• c. Log
• d. Metadata

A mini-dimension is used to handle __________ attributes.

• a. Static
• b. Rapidly changing
• c. Numeric
• d. Random

Conformed dimensions are shared across __________ fact tables.

• a. One
• b. Multiple
• c. Zero
• d. Static

A snowflake schema normalizes __________ tables.

• a. Fact
• b. Dimension
• c. Log
• d. Cache

A bridge table is often used to manage __________ relationships.

• a. One-to-one
• b. Many-to-many
• c. Random
• d. Cache

A factless fact table contains __________.

• a. Measures only
• b. Keys without measures
• c. Dimensions only
• d. Metadata

A Type 1 SCD replaces old values with __________ values.

• a. Random
• b. New
• c. Empty
• d. Cached