DATABASE PROCESSING FOR BIS QUIZ

Report types include static, dynamic, query and OLAP.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Data warehouse data

Data extraction/cleaning/preparation programs

Data metadata

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

A BI reporting system does not ________ .

use statistical procedures to predict future events

deliver information to users on a timely basis

use disparate data sources

create meaningful information

TRUE ANSWER : ?
YOUR ANSWER : ?

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

cluster analysis only

both cluster analysis and regression analysis

regression analysis only

RFM analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting systems cannot do which of the following operations?

Modify data

Group data

Filter data

Both filter and group data

TRUE ANSWER : ?
YOUR ANSWER : ?

We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .

confidence

lift

support

the basic probability

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Most operational databases can be used for many BI applications.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

Non-integrated data

Inconsistent data

Too much data

Dirty data

TRUE ANSWER : ?
YOUR ANSWER : ?

↑