An organization tracks colleague roles in a dimension table. They update the table with new role details, removing older information so the final record remains accurate. Which approach meets this requirement?
Overwrite outdated rows with revised details in one record
Add more columns for each updated role to maintain all versions
Append each new role as a new row to track prior assignments
Maintain a historical table and link new roles to old entries
Replacing older data with updated details ensures the table reflects current roles. Creating new rows, keeping a separate table for historical entries, or adding multiple columns preserves past data, which goes against the requirement to discard older records.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a dimension table?
Open an interactive chat with Bash
Why is it important to overwrite outdated rows instead of keeping historical records?
Open an interactive chat with Bash
What are the implications of appending new roles as new rows?