Difficulty: Easy
Correct Answer: Correct
Explanation:
Introduction / Context:
Databases hold many forms of data. “Event data” records discrete occurrences (for example, a purchase) with timestamps. “Status data” captures the current state (for example, account balance) or a snapshot. The question asks whether both can be stored in a database; the answer hinges on common modeling patterns rather than any platform limitation.
Given Data / Assumptions:
Concept / Approach:
Event tables typically store one row per occurrence with a timestamp (and possibly an event type). Status can be modeled as the latest row in a history table, a separate current-state table maintained by upserts, or periodic snapshots. Many analytic architectures keep both: events for causality and sequence, status for quick point-in-time queries.
Step-by-Step Solution:
Verification / Alternative check:
Warehousing textbooks show event-centric facts plus status snapshots (for example, monthly inventory snapshots) in the same database, confirming feasibility.
Why Other Options Are Wrong:
Common Pitfalls:
Confusing current-state overwrites with loss of history; mismatched grains between events and status leading to inaccurate joins; missing effective-dating for status changes.
Final Answer:
Correct
Discussion & Comments