70-463 · Question #73
You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to student
The correct answer is D. Add StartDate and EndDate columns to the student dimension.. Adding a start and end date will give you this ability as when a record is inserted and given a start and end date, you'll have the ability to determine when they were active therefore giving you a retention of historical changes
Question
You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation. You need to redesign the dimension to enable the full historical reporting of changes to multiple student attributes including ParentOccupation. What should you do?
Options
- AAdd CurrentValue and PreviousValue columns to the student dimension.
- BEnable Snapshot Isolation on the data warehouse.
- CAdd an IsCurrent column to the student dimension.
- DAdd StartDate and EndDate columns to the student dimension.
How the community answered
(27 responses)- A7% (2)
- B4% (1)
- C19% (5)
- D70% (19)
Explanation
Adding a start and end date will give you this ability as when a record is inserted and given a start and end date, you'll have the ability to determine when they were active therefore giving you a retention of historical changes
Topics
Community Discussion
No community discussion yet for this question.