DATABASE PROCESSING FOR BIS QUIZ

The "F" in RFM analysis stands for ________ .

fast food

freshness

fantasy

frequently

TRUE ANSWER : ?
YOUR ANSWER : ?

Most operational databases can be used for many BI applications.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

RFM analysis only

both cluster analysis and regression analysis

regression analysis only

cluster analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Do what-if analysis only

Do both RFM and what-if analysis

Process transactions only

Do RFM analysis only

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

lift

the basic probability

confidence

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLAP, we are interested in ________ .

dimensions only

levels only

measures only

measures and dimensions

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting analyses can be performed using ________ .

standard SQL only

OLAP only

extensions to SQL only

both standard SQL and extensions to SQL

TRUE ANSWER : ?
YOUR ANSWER : ?

Data warehouse data are usually normalized.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑