DATABASE PROCESSING FOR BIS QUIZ

Data mining applications are used accomplish which of the following tasks?

Do both RFM and what-if analysis

Do what-if analysis only

Process transactions only

Do RFM analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not a component of a data warehouse?

Data extraction/cleaning/preparation programs

Data metadata

None of these

Data warehouse data

TRUE ANSWER : ?
YOUR ANSWER : ?

OnLine Analytical Processing (OLAP) is a BI reporting system.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

One popular classification technique in Business Intelligence (BI) reporting is ________ .

RFM analysis only

regression analysis only

cluster analysis only

both cluster analysis and regression analysis

TRUE ANSWER : ?
YOUR ANSWER : ?

The data warehouse DBMS needs to be the same DBMS used for the operational database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

dirty data

a "wrong format" problem

non-integrated data

inconsistent data

TRUE ANSWER : ?
YOUR ANSWER : ?

The "F" in RFM analysis stands for ________ .

fantasy

fast food

frequently

freshness

TRUE ANSWER : ?
YOUR ANSWER : ?

The term neural networks as used in data mining is a misnomer.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

BI reporting systems summarize the current status of business activities in order to predict future activities.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑