Multiple choice technology databases

What is true of a Framework Manager model of an operational database lacking a time dimension?

  1. Virtual star schema models require a time dimension for multi-fact queries.

  2. Report authors cannot create multi-fact, time-based queries.

  3. Time-based rollups for multi-fact queries may be difficult to handle.

  4. Report authors cannot create multi-fact, time-based queries unless using a union.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A time dimension is critical for multi-fact queries that need to align facts across time periods. Without it, time-based rollups (aggregating by day, month, quarter, etc.) become difficult because Framework Manager cannot automatically generate the necessary time joins and period alignments. Virtual star schemas do not strictly require a time dimension for all multi-fact queries, and authors can still create multi-fact time-based queries using other techniques like unions, though it becomes more complex.

Keep practicing — related questions