Quiz Discussion

Legacy data is which of the following?

• 1]

  Data contained in a newly-installed system

• 2]

  Data contained in a file system

• 3]

  Data rejected during the installation of a new system

• 4]

  Data contained by a system used prior to the installation of a new system

Which of the following is true for a relational database?

• 1]

  Data is represented by tables

• 2]

  Complex programs have to be written for simple queries

• 3]

  It is difficult to access data

• 4]

  All of the above

The load and index are which of the following?

• 1]

  A process to reject data from the data warehouse and to create the necessary indexes

• 2]

  A process to load the data in the data warehouse and to create the necessary indexes

• 3]

  A process to upgrade the quality of data before it is moved into a data warehouse

• 4]

  A process to upgrade the quality of data after it is moved into a data warehouse

A data warehouse uses

• 1]

  partial operational data

• 2]

  future operational data

• 3]

  historical operational data

• 4]

  health care data

Transient data is which of the following?

• 1]

  Data in which changes to existing records cause the previous version of the records to be eliminated

• 2]

  Data in which changes to existing records do not cause the previous version of the records to be eliminated

• 3]

  Data that are never altered or deleted once they have been added

• 4]

  Data that are never deleted once they have been added

The extract process is which of the following?

• 1]

  Capturing all of the data contained in various operational systems

• 2]

  Capturing a subset of the data contained in various operational systems

• 3]

  Capturing a subset of the data contained in various decision support systems

• 4]

  Capturing all of the data contained in various decision support systems

A database management system (DBMS) is a

• 1]

  hardware system used to create, maintain and provide controlled access to a database

• 2]

  a software system used to create, maintain and provide controlled access to a database

• 3]

  hardware system used to create, maintain, and provide uncontrolled access to a database

• 4]

  a software system used to create, maintain, and provide uncontrolled access to a database

The active data warehouse architecture includes which of the following?

• 1]

  At least one data mart

• 2]

  Data that can extracted from numerous internal and external sources

• 3]

  Near real-time updates

• 4]

  All of the above

Data scrubbing is which of the following?

• 1]

  A process to reject data from the data warehouse and to create the necessary indexes

• 2]

  A process to load the data in the data warehouse and to create the necessary indexes

• 3]

  A process to upgrade the quality of data after it is moved into a data warehouse

• 4]

  A process to upgrade the quality of data before it is moved into a data warehouse

An operational system is which of the following?

• 1]

  A system that is used to run the business in real-time and is based on historical data

• 2]

  A system that is used to run the business in real-time and is based on current data

• 3]

  A system that is used to support decision making and is based on current data

• 4]

  A system that is used to support decision making and is based on historical data