Quiz 2

________ duplicates data across databases. A. Data propagation B. Redundant replication C. Data duplication D. A replication server

A. Data propagation

Data federation consolidates all data into one database. A. True B. False

A. False

Transient data are never changed. A. True B. False

A. False

All of the following are ways to consolidate data EXCEPT A. business process integration B. user interaction integration. C. data rollup and integration. D. application integration

C. data rollup and integration.

A method of capturing only the changes that have occurred in the source data since the last capture is called ________ extract. A. completion backward updates. B. static C. incremental D. data scrubbing.

C. incremental

SSIS Components are A. Operational Sources B. ETL Process C. Data Warehouse D. All of the above

D. All of the above

A characteristic of reconciled data that means the data reflect an enterprise-wide view is: A. normalized B. detailed C. historical D. comprehensive

D. Comprehensive

Which of the following is a basic method for single-field transformation? A. Cross-linking attributes B. Cross-linking entities C. Field-to-field communication D. Table lookup

D. Table lookup

All of the following are tasks of data cleansing EXCEPT: A. decoding data to make them understandable for data warehousing applications. B. adding time stamps to distinguish values for the same attribute over time. C. generating primary keys for each row of a table D. creating foreign keys

D. creating foreign keys

Data federation is a technique that: A. provides a virtual view of integrated data without actually creating one centralized database. B. creates an integrated database from several separate databases. C. creates a distributed database. D. provides a real-time update of shared data

A. provides a virtual view of integrated data without actually creating one centralized database.