DATABASE PROCESSING FOR BIS QUIZ

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

Modify data

Both filter and group data

Filter data

Group data

TRUE ANSWER : ?
YOUR ANSWER : ?

We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

non-integrated data

a "wrong format" problem

dirty data

inconsistent data

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis is a BI reporting system.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.

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

Inconsistent data

Non-integrated data

TRUE ANSWER : ?
YOUR ANSWER : ?

Report types include static, dynamic, query and OLAP.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The "F" in RFM analysis stands for ________ .

freshness

fantasy

frequently

fast food

TRUE ANSWER : ?
YOUR ANSWER : ?

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

OLAP only

standard SQL only

both standard SQL and extensions to SQL

extensions to SQL only

TRUE ANSWER : ?
YOUR ANSWER : ?

Market basket analysis primarily uses the technique of conditional probabilities.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Data warehouse data

None of these

Data metadata

Data extraction/cleaning/preparation programs

TRUE ANSWER : ?
YOUR ANSWER : ?

↑