DATABASE PROCESSING FOR BIS QUIZ

Business Intelligence (BI) systems do not obtain data from operational databases.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Too much data

Dirty data

Non-integrated data

Inconsistent 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

RFM

OLAP

TRUE ANSWER : ?
YOUR ANSWER : ?

Report types include static, dynamic, query and OLAP.

False

True

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 : ?

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

both standard SQL and extensions to SQL

extensions to SQL only

OLAP only

standard SQL only

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis uses customer's purchasing patterns to ________ .

analyze and rank customers

perform OLAP

record transactions

predict future sales using regression techniques

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 : ?

OnLine Analytical Processing (OLAP) is a BI reporting system.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Process transactions only

Do what-if analysis only

Do both RFM and what-if analysis

Do RFM analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑