DATABASE PROCESSING FOR BIS QUIZ

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

Data warehouse data

None of these

Data extraction/cleaning/preparation programs

Data metadata

TRUE ANSWER : ?
YOUR ANSWER : ?

The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an unsupervised data mining technique?

Cluster analysis only

Regression Analysis only

RFM Analysis only

Both Regression Analysis and RFM Analysis

TRUE ANSWER : ?
YOUR ANSWER : ?

In OLAP, we are interested in ________ .

dimensions only

levels only

measures only

measures and dimensions

TRUE ANSWER : ?
YOUR ANSWER : ?

Formatting the report is part of authoring a report.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is not a reason that operational data are difficult to read?

Dirty data

Missing values

Non-integrated data

Non-duplicated data

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

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis uses customer's purchasing patterns to ________ .

analyze and rank customers

predict future sales using regression techniques

perform OLAP

record transactions

TRUE ANSWER : ?
YOUR ANSWER : ?

Data warehouse data are usually normalized.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑