Data Warehousing Multiple Choice Questions and Answers

51. _______________ is the goal of data mining.

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

52. The ............................ exposes the information being captured, stored, and managed by operational systems.

1. top-down view
2. data warehouse view
3. data source view
4. business query view

53. The .................. allows the selection of the relevant information necessary for the data warehouse.

1. top-down view
2. data warehouse view
3. data source view
4. business query view

54. A data warehouse is

1. updated by end users.
2. contains numerous naming conventions and formats
3. organized around important subject areas.
4. contains only current data.

55. An operational system is

1. used to run the business in real time and is based on historical data.
2. used to run the business in real time and is based on current data.
3. used to support decision making and is based on current data.
4. used to support decision making and is based on historical data.

56. ________________defines the structure of the data held in operational databases and used byoperational applications.

1. User-level metadata.
2. Data warehouse metadata.
3. Operational metadata.
4. Data mining metadata.

57. The data is stored, retrieved and updated in

1. OLAP
2. OLTP
3. SMTP
4. FTP