DATABASE PROCESSING FOR BIS QUIZ

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

Non-integrated data

Dirty data

Non-duplicated data

Missing values

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

inconsistent data

non-integrated data

dirty data

a "wrong format" problem

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.

True

False

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

Formatting the report is part of authoring a report.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The "F" in RFM analysis stands for ________ .

fast food

freshness

frequently

fantasy

TRUE ANSWER : ?
YOUR ANSWER : ?

A BI reporting system does not ________ .

deliver information to users on a timely basis

create meaningful information

use statistical procedures to predict future events

use disparate data sources

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) systems do not obtain their data by which of the following means?

Process transactions

Read and process data from an operational database

Process extracts from operational databases

Process data purchased from data vendors

TRUE ANSWER : ?
YOUR ANSWER : ?

Most operational databases can be used for many BI applications.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an unsupervised data mining technique?

Both Regression Analysis and RFM Analysis

Cluster analysis only

RFM Analysis only

Regression Analysis only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑