Data Warehousing Quiz Question with Answer

41. The full form of OLAP is

  1. Online Analytical Processing
  2. Online Advanced Processing
  3. Online Advanced Preparation
  4. Online Analytical Performance

42. The source of all data warehouse data is the

  1. operational environment.
  2. informal environment.
  3. formal environment.
  4. technology environment.

43. ________________ is the specialized data warehouse database.

  1. Oracle.
  2. DBZ.
  3. Informix.
  4. Redbrick.

44. The biggest drawback of the level indicator in the classic star-schema is that it limits

  1. quantify.
  2. qualify.
  3. flexibility.
  4. ability.

45. The data Warehouse is

  1. read only
  2. write only
  3. read write only
  4. none

46. __________describes the data contained in the data warehouse.

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

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

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

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

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

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

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

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

Tags :

Multiple Choice Questions and Answers on Data Warehousing

Data Warehousing Multiple Choice Questions and Answers

Data Warehousing Trivia Quiz

Data Warehousing Question and Answer PDF Online

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....