Q. Fact tables are ___________.

  • (A) completely demoralized.
  • (B) partially demoralized.
  • (C) completely normalized.
  • (D) partially normalized.
πŸ’¬ Discuss
βœ… Correct Answer: (C) completely normalized.

Q. _______________ is the goal of data mining.

  • (A) to explain some observed event or condition.
  • (B) to confirm that data exists.
  • (C) to analyze data for expected relationships.
  • (D) to create a new data warehouse.
πŸ’¬ Discuss
βœ… Correct Answer: (A) to explain some observed event or condition.

Q. Business Intelligence and data warehousing is used for ________.

  • (A) forecasting.
  • (B) data mining.
  • (C) analysis of large volumes of product sales data.
  • (D) all of the above.
πŸ’¬ Discuss
βœ… Correct Answer: (D) all of the above.

Q. The data administration subsystem helps you perform all of the following, except__________.

  • (A) backups and recovery.
  • (B) query optimization.
  • (C) security management.
  • (D) create, change, and delete information.
πŸ’¬ Discuss
βœ… Correct Answer: (D) create, change, and delete information.

Q. The most common source of change data in refreshing a data warehouse is _______.

  • (A) queryable change data.
  • (B) cooperative change data.
  • (C) logged change data.
  • (D) snapshot change data.
πŸ’¬ Discuss
βœ… Correct Answer: (A) queryable change data.

Q. ________ are responsible for running queries and reports against data warehouse tables.

  • (A) hardware.
  • (B) software.
  • (C) end users.
  • (D) middle ware.
πŸ’¬ Discuss
βœ… Correct Answer: (C) end users.

Q. Query tool is meant for __________.

  • (A) data acquisition.
  • (B) information delivery.
  • (C) information exchange.
  • (D) communication.
πŸ’¬ Discuss
βœ… Correct Answer: (A) data acquisition.

Q. Classification rules are extracted from _____________.

  • (A) root node.
  • (B) decision tree.
  • (C) siblings.
  • (D) branches.
πŸ’¬ Discuss
βœ… Correct Answer: (B) decision tree.

Q. Dimensionality reduction reduces the data set size by removing ____________.

  • (A) relevant attributes.
  • (B) irrelevant attributes.
  • (C) derived attributes.
  • (D) composite attributes.
πŸ’¬ Discuss
βœ… Correct Answer: (B) irrelevant attributes.

Q. ___________ is a method of incremental conceptual clustering.

  • (A) corba.
  • (B) olap.
  • (C) cobweb.
  • (D) sting.
πŸ’¬ Discuss
βœ… Correct Answer: (C) cobweb.

Jump to