Quiz Discussion

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

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

A shared database should

• 1]

  be accurate and available

• 2]

  be secure

• 3]

  provide for backup and recovery

• 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

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

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

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 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

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