DATABASE PROCESSING FOR BIS QUIZ

Business Intelligence (BI) systems do not obtain their data by which of the following means?

Read and process data from an operational database

Process extracts from operational databases

Process transactions

Process data purchased from data vendors

TRUE ANSWER : ?
YOUR ANSWER : ?

Most operational databases can be used for many BI applications.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Report types include static, dynamic, query and OLAP.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In unsupervised data mining, explanations are created after patterns are found.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Formatting the report is part of authoring a report.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLAP, we are interested in ________ .

levels only

dimensions only

measures only

measures and dimensions

TRUE ANSWER : ?
YOUR ANSWER : ?

Data warehouse data are usually normalized.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

RFM analysis only

cluster analysis only

both cluster analysis and regression analysis

regression analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not a reason that operational data are difficult to read?

Non-integrated data

Non-duplicated data

Missing values

Dirty data

TRUE ANSWER : ?
YOUR ANSWER : ?

We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .

Has ordered recently, orders frequently, and places a large order when she orders.

Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

Hasn't ordered recently, orders infrequently, but places a large order when she orders.

Has ordered recently, orders frequently, but doesn't place a large order when she orders

TRUE ANSWER : ?
YOUR ANSWER : ?