Data Warehousing Questions and Answers | Online Quiz for Practice

46. __________describes the data contained in the data warehouse.

1. Metadata.
2. Informational data.
3. Relational data.
4. Operational data.

47. ........................ is a good alternative to the star schema.

1. Fact constellation
2. Star-snowflake schema
3. Star schema
4. Snowflake schema

48. ___________ is a good alternative to the star schema.

1. Fact constellation.
2. Star-snowflake schema.
3. Star schema.
4. Snowflake schema.

49. The important aspect of the data warehouse environment is that data found within the data warehouseis___________.

1. integrated.
2. All of the above.
3. subject-oriented.
4. time-variant.

50. The key used in operational environment may not have an element of

1. frequency.
2. quality.
3. time.
4. cost.

51. _______________ is the goal of data mining.

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

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

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

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

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

54. A data warehouse is

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

55. An operational system is

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

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

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

57. The data is stored, retrieved and updated in

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