DATABASE PROCESSING FOR BIS QUIZ

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

None of these

Data warehouse data

Data extraction/cleaning/preparation programs

Data metadata

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis uses customer's purchasing patterns to ________ .

perform OLAP

record transactions

analyze and rank customers

predict future sales using regression techniques

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Inconsistent data

Too much data

Non-integrated data

Dirty data

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Dirty data

Non-duplicated data

Missing values

Non-integrated data

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis is a BI reporting system.

False

True

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

support

confidence

the basic probability

lift

TRUE ANSWER : ?
YOUR ANSWER : ?

A data warehouse is a database system that is optimized for operational transaction processing.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Market basket analysis primarily uses the technique of conditional probabilities.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data warehouse data are usually normalized.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A BI reporting system does not ________ .

use statistical procedures to predict future events

use disparate data sources

create meaningful information

deliver information to users on a timely basis

TRUE ANSWER : ?
YOUR ANSWER : ?

↑