DATABASE PROCESSING FOR BIS QUIZ

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

Process transactions only

Do RFM analysis only

Do both RFM and what-if analysis

Do what-if analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Most operational databases can be used for many BI applications.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an unsupervised data mining technique?

Cluster analysis only

Regression Analysis only

Both Regression Analysis and RFM Analysis

RFM Analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Too much data

Inconsistent data

Non-integrated data

Dirty data

TRUE ANSWER : ?
YOUR ANSWER : ?

The reports generated by a reporting system are usually not delivered in which of the following media?

Web portal

Digital dashboard

Commercial courier service

E-Mail

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLAP, we are interested in ________ .

dimensions only

measures and dimensions

measures only

levels only

TRUE ANSWER : ?
YOUR ANSWER : ?

The data warehouse DBMS needs to be the same DBMS used for the operational database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑