DATABASE PROCESSING FOR BIS QUIZ

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

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLAP, we are interested in ________ .

measures only

dimensions only

levels only

measures and dimensions

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

a "wrong format" problem

inconsistent data

non-integrated data

dirty data

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following are not done by Business Intelligence (BI) systems?

Both of the above are correct.

Neither of the above is correct.

Process and record transactions only

Analyze past and current activities only

TRUE ANSWER : ?
YOUR ANSWER : ?

BI reporting systems summarize the current status of business activities in order to predict future activities.

False

True

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

↑