Data Warehouse Concepts, Design, and Data Integration

14. Question 14 Snapshot change data 1 point   involves periodic dumps of source data (usually two most recent snapshots) to create deltas.   comes directly from a data source…

13. Question 13 Logged change data 1 point   involves source system changes for trigger code and execution to put change data in a queue or staging area for eventual…

12. Question 12 A data warehouse administrator has typically more control over load time lag than valid time lag. 1 point   True   False

11. Question 11 Valid time lag is 1 point   the difference between the occurrence of an event in the real world (valid time) and the storage of the event…

10. Question 10 The relationship of distance measures for strings and the entity identification problem (also known as the record linkage problem) can best be characterized as 1 point  …

6. Question 6 In a regular expression, an escape sequence 1 point   defines a search pattern by itself.   is a character to match exactly.   has special meaning…

5. Question 5 In a regular expression, a meta character 1 point   removes the special meaning of a meta character.   has special meaning within a search expression.  …

3. Question 3 Queryable change data 1 point   involves periodic dumps of source data (usually two most recent snapshots) to create deltas.   comes directly from a data source…

2. Question 2 Cooperative change data 1 point   involves periodic dumps of source data (usually two most recent snapshots) to create deltas.   comes directly from a data source…

1. Question 1 Load time lag is 1 point   the difference between storage of an event in the data warehouse and usage of the associated data in a data…