DATABASE PROCESSING FOR BIS QUIZ

Which of the following are not done by Business Intelligence (BI) systems?

Neither of the above is correct.

Analyze past and current activities only

Both of the above are correct.

Process and record transactions only

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis uses customer's purchasing patterns to ________ .

record transactions

predict future sales using regression techniques

perform OLAP

analyze and rank customers

TRUE ANSWER : ?
YOUR ANSWER : ?

The reports generated by a reporting system are usually not delivered in which of the following media?

Digital dashboard

Web portal

Commercial courier service

E-Mail

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLAP, we are interested in ________ .

measures only

levels only

dimensions only

measures and dimensions

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis is a BI reporting system.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The "F" in RFM analysis stands for ________ .

fantasy

frequently

freshness

fast food

TRUE ANSWER : ?
YOUR ANSWER : ?

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

regression analysis only

RFM analysis only

cluster analysis only

both cluster analysis and regression analysis

TRUE ANSWER : ?
YOUR ANSWER : ?

Market basket analysis primarily uses the technique of conditional probabilities.

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

inconsistent data

a "wrong format" problem

dirty data

non-integrated data

TRUE ANSWER : ?
YOUR ANSWER : ?

A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

Pull

Push

OLAP

RFM

TRUE ANSWER : ?
YOUR ANSWER : ?

↑