Machine-translated by Google. Questions are authored in English.
Top

Data Warehousing Questions and Answers

31.

Data in operational systems are typically fragmented and inconsistent.

Answer: A

Correct answer: True

Operational systems are built one at a time for particular functions, so the same customer appears with different identifiers in each, codes conflict, formats differ and definitions diverge. Reconciling that fragmentation is the substance of the transformation stage and usually the largest part of a warehouse project.

Please log in or register to report this question.

32.

Static extract is used for ongoing warehouse maintenance.

Answer: B

Correct answer: False

A static extract takes a snapshot of everything and is used to populate the warehouse initially. Ongoing maintenance uses an incremental extract, capturing only what has changed since the last one - which is far cheaper and imposes far less load on the operational systems.

Please log in or register to report this question.

Loading…

Other Subjects

Tags: Data Warehousing Questions and Answers || Data Warehousing MCQ Questions and Answers || Data Warehousing GK Questions and Answers || Data Warehousing GK MCQ Questions || Data Warehousing Multiple Choice Questions and Answers || Data Warehousing GK || GK on Data Warehousing || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database