Quiz Discussion

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

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

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

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

A star schema has what type of relationship between a dimension and fact table?

• 1]

  One-to-one

• 2]

  Many-to-many

• 3]

  One-to-many

• 4]

  All of the above

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

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 application can perform which of the following activities?

• 1]

  Add records

• 2]

  Update records

• 3]

  Read records

• 4]

  All of the above

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

The generic two-level data warehouse architecture includes which of the following?

• 1]

  At least one data mart

• 2]

  Data that can be extracted from numerous internal and external sources

• 3]

  Near real-time updates

• 4]

  All of the above