Data Warehousing MCQ Questions and Answers Quiz

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

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

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

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

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

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

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

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

55. _______________ 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.

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

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

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

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

60. ________________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.
Tags

MCQ Multiple Choice Questions and Answers on Data Warehousing

Data Warehousing Trivia Questions and Answers PDF

Data Warehousing Question and Answer

Spreading Education Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....