Q. ________________defines the structure of the data held in operational databases and used by operational applications.

  • (A) user-level metadata.
  • (B) data warehouse metadata.
  • (C) operational metadata.
  • (D) data mining metadata.
πŸ’¬ Discuss
βœ… Correct Answer: (C) operational metadata.

Q. ________________ is held in the catalog of the warehouse database system.

  • (A) application level metadata.
  • (B) algorithmic level metadata.
  • (C) departmental level metadata.
  • (D) core warehouse metadata.
πŸ’¬ Discuss
βœ… Correct Answer: (B) algorithmic level metadata.

Q. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

  • (A) application level metadata.
  • (B) user level metadata.
  • (C) enduser level metadata.
  • (D) core level metadata.
πŸ’¬ Discuss
βœ… Correct Answer: (A) application level metadata.

Q. ______consists of formal definitions, such as a COBOL layout or a database schema.

  • (A) classical metadata.
  • (B) transformation metadata.
  • (C) historical metadata.
  • (D) structural metadata.
πŸ’¬ Discuss
βœ… Correct Answer: (A) classical metadata.

Q. _____________consists of information in the enterprise that is not in classical form.

  • (A) mushy metadata.
  • (B) differential metadata.
  • (C) data warehouse.
  • (D) data mining.
πŸ’¬ Discuss
βœ… Correct Answer: (A) mushy metadata.

Q. . ______________databases are owned by particular departments or business groups.

  • (A) informational.
  • (B) operational.
  • (C) both informational and operational.
  • (D) flat.
πŸ’¬ Discuss
βœ… Correct Answer: (B) operational.

Q. The star schema is composed of __________ fact table.

  • (A) one.
  • (B) two.
  • (C) three.
  • (D) four.
πŸ’¬ Discuss
βœ… Correct Answer: (A) one.

Q. The time horizon in operational environment is ___________.

  • (A) 30-60 days.
  • (B) 60-90 days.
  • (C) 90-120 days.
  • (D) 120-150 days.
πŸ’¬ Discuss
βœ… Correct Answer: (B) 60-90 days.

Q. The key used in operational environment may not have an element of__________.

  • (A) time.
  • (B) cost.
  • (C) frequency.
  • (D) quality.
πŸ’¬ Discuss
βœ… Correct Answer: (A) time.

Q. Data can be updated in _____environment.

  • (A) data warehouse.
  • (B) data mining.
  • (C) operational.
  • (D) informational.
πŸ’¬ Discuss
βœ… Correct Answer: (C) operational.

Jump to