Quiz Discussion

An enterprise data model is

• 1]

  a graphical model that shows the high-level entities for an organization

• 2]

  a graphical model that shows all entities for an organization

• 3]

  a non-graphical model that shows the high-level entities for an organization

• 4]

  a non-graphical model that shows all entities for an organization

An enterprise database is which of the following?

• 1]

  A database designed to support only users external to an organization

• 2]

  A database designed to support an entire organization

• 3]

  A database designed to support a single PC

• 4]

  A database designed to support a relatively small group

A data warehouse is which of the following?

• 1]

  Can be updated by end users

• 2]

  Contains numerous naming conventions and formats

• 3]

  Organized around important subject areas

• 4]

  Contains only current data

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

A shared database should

• 1]

  be accurate and available

• 2]

  be secure

• 3]

  provide for backup and recovery

• 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

A multifield transformation does which of the following?

• 1]

  Converts data from one field into multiple fields

• 2]

  Converts data from multiple fields into one field

• 3]

  Converts data from multiple fields into multiple fields

• 4]

  All of the above

A database application can perform which of the following activities?

• 1]

  Add records

• 2]

  Update records

• 3]

  Read records

• 4]

  All of the above

Data transformation includes which of the following?

• 1]

  A process to change data from a detailed level to a summary level

• 2]

  Joining data from one source into various sources of data

• 3]

  A process to change data from a summary level to a detailed level

• 4]

  Separating data from one source into various sources of data

Reconciled data is which of the following?

• 1]

  Data stored in the various operational systems throughout the organization

• 2]

  Current data intended to be the single source for all decision support systems

• 3]

  Data stored in one operational system in the organization

• 4]

  Data that has been selected and formatted for end-user support applications