Data Warehouse Concepts, Design, and Data Integration - Home Coursera 2 Module 4 PDF

Preview

Summary

Download Data Warehouse Concepts, Design, and Data Integration - Home Coursera 2 Module 4 PDF

Description

11/21/2018

Data Warehouse Concepts, Design, and Data Integration - Home | Coursera

Module 4 quiz Quiz, 15 questions

1 point

1. Load time lag is the dierence between the occurrence of an event in the real world (valid time) and usage of the associated data in a data warehouse query. the dierence between storage of an event in the data warehouse and usage of the associated data in a data warehouse query. the dierence between transaction time and the storage of the event in a data warehouse. the dierence between the occurrence of an event in the real world (valid time) and the storage of the event in an operational database (transaction time).

1 point

2. Cooperative change data comes directly from a data source via a query using a timestamp in the data source. involves periodic dumps of source data (usually two most recent snapshots) to create deltas. involves source system changes for trigger code and execution to put change data in a queue or staging area for eventual loading into a warehouse. involves les that record changes or other user activity such as web page activity.

1 point

3. Queryable change data https://www.coursera.org/learn/dwdesign/exam/ME4yw/module-4-quiz

1/6

11/21/2018

Data Warehouse Concepts, Design, and Data Integration - Home | Coursera

involves source system changes for trigger code and execution to put change data in a queue or

Module 4staging quizarea for eventual loading into a warehouse. Quiz, 15 questions

involves periodic dumps of source data (usually two most recent snapshots) to create deltas. comes directly from a data source via a query using a timestamp in the data source involves les that record changes or other user activity such as web page activity.

1 point

4. Select the following choice that is FALSE about the initial data warehouse load process. Usually a major activity in the data warehouse development process Less open ended than refresh processing Can be dicult to estimate project time requirements. Typically discover many data quality problems during the load process

1 point

5. In a regular expression, a meta character denes a search pattern by itself. is a character to match exactly. has special meaning within a search expression. removes the special meaning of a meta character.

1 point

6. In a regular expression, a literal character

https://www.coursera.org/learn/dwdesign/exam/ME4yw/module-4-quiz

2/6

11/21/2018

Data Warehouse Concepts, Design, and Data Integration - Home | Coursera

denes a search pattern by itself.

Module 4 quiz Quiz, 15 questions

has special meaning within a search expression. is a character to match exactly. removes the special meaning of a meta character.

1 point

7. Choose the search strings matched by the search expression: “cd{1,3}e”. You should ignore the quotation marks in the regular expression and search strings. “ce” “cdde” “de” “cdce” “cdcde”

1 point

8. Identify the FALSE choice about quasi identiers. Can be used to match records in data sources without a common identier Can consist of individual elds or combinations of elds Must be unique in each data source May require inexact matching across data sources

1 point

9. https://www.coursera.org/learn/dwdesign/exam/ME4yw/module-4-quiz

3/6

11/21/2018

Data Warehouse Concepts, Design, and Data Integration - Home | Coursera

Metaphone distance renes soundex using

Module 4 quiz

Quiz, 15 questions 6 consonant sounds.

16 consonant sounds. No consonant sounds. 12 consonant sounds.

1 point

10. The edit operations to transform the source string “Saturday” to the target string “Sunday” are 2 deletions and 1 substitution 2 insertions and 1 substitution 2 deletions and 2 substitutions 2 substitutions and 1 deletion

1 point

11. Valid time lag is the dierence between the occurrence of an event in the real world (valid time) and the storage of the event in an operational database (transaction time). the dierence between transaction time and the storage of the event in a data warehouse. the dierence between the occurrence of an event in the real world (valid time) and usage of the associated data in a data warehouse query. the dierence between storage of an event in the data warehouse and usage of the associated data in a data warehouse query.

1 point https://www.coursera.org/learn/dwdesign/exam/ME4yw/module-4-quiz

4/6

11/21/2018

Data Warehouse Concepts, Design, and Data Integration - Home | Coursera

12.

Module quiz administrator has typically more control over load time lag than valid time lag. A data 4 warehouse Quiz, 15 questions

True False

1 point

13. Logged change data involves periodic dumps of source data (usually two most recent snapshots) to create deltas. involves les that record changes or other user activity such as web page activity. involves source system changes for trigger code and execution to put change data in a queue or staging area for eventual loading into a warehouse. comes directly from a data source via a query using a timestamp in the data source.

1 point

14. Snapshot change data involves source system changes for trigger code and execution to put change data in a queue or staging area for eventual loading into a warehouse. comes directly from a data source via a query using a timestamp in the data source. involves periodic dumps of source data (usually two most recent snapshots) to create deltas. involves les that record changes or other user activity such as web page activity.

1 point

15. Select the following choice that a data warehouse administrator should NOT consider to determine the frequency of refreshing a data warehouse. https://www.coursera.org/learn/dwdesign/exam/ME4yw/module-4-quiz

5/6

11/21/2018

Data Warehouse Concepts, Design, and Data Integration - Home | Coursera

the value of data timeliness

Module 4 quiz Quiz, 15 questions

the cost to perform refresh processes at desired time periods the uncertainty of the data loading process the need to satisfy constraints on source access, integration, completeness/consistency, and availability.

I, Prasanthi Yepuru, understand that submitting work that isn’t my own may result in permanent failure of this course or deactivation of my Coursera account. Learn more about Coursera’s Honor Code Submit Quiz

https://www.coursera.org/learn/dwdesign/exam/ME4yw/module-4-quiz

6/6...