Q.1

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

  • Many-to-many
  • One-to-one
  • One-to-many
  • All of the above.
Q.2

Transient data is which of the following?

  • Data in which changes to existing records cause the previous version of the records to be eliminated
  • Data in which changes to existing records do not cause the previous version of the records to be eliminated
  • Data that are never altered or deleted once they have been added
  • Data that are never deleted once they have been added
Q.3

A goal of data mining includes which of the following?

  • To explain some observed event or condition
  • To confirm that data exists
  • To analyze data for expected relationships
  • To create a new data warehouse
Q.4

Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

  • True
  • False
Q.5

Every key used to join the fact table with a dimensional table should be a surrogate key.

  • True
  • False
Q.6

Data in the data warehouse are loaded and refreshed from operational systems.

  • True
  • False
Q.7

Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.

  • True
  • False
Q.8

Data in operational systems are typically fragmented and inconsistent.

  • True
  • False
Q.9

A multifield transformation does which of the following?

  • Converts data from one field into multiple fields
  • Converts data from multiple fields into one field
  • Converts data from multiple fields into multiple fields
  • All of the above
Q.10

An operational system is which of the following?

  • A system that is used to run the business in real time and is based on historical data.
  • A system that is used to run the business in real time and is based on current data.
  • A system that is used to support decision making and is based on current data.
  • A system that is used to support decision making and is based on historical data.
Q.11

A data warehouse is which of the following?

  • Can be updated by end users.
  • Contains numerous naming conventions and formats.
  • Organized around important subject areas.
  • Contains only current data.
Q.12

Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.

  • True
  • False
Q.13

Periodic data are data that are physically altered once added to the store.

  • True
  • False
Q.14

Most operational systems are based on the use of transient data.

  • True
  • False
Q.15

Independent data marts are often created because an organization focuses on a series of short-term business objectives.

  • True
  • False
0 h : 0 m : 1 s