DATABASE PROCESSING FOR BIS QUIZ

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

OLAP only

extensions to SQL only

both standard SQL and extensions to SQL

standard SQL only

TRUE ANSWER : ?
YOUR ANSWER : ?

Formatting the report is part of authoring a report.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data warehouse data are usually normalized.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Do RFM analysis only

Do both RFM and what-if analysis

Do what-if analysis only

Process transactions only

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

dirty data

non-integrated data

TRUE ANSWER : ?
YOUR ANSWER : ?

A BI reporting system does not ________ .

use statistical procedures to predict future events

create meaningful information

deliver information to users on a timely basis

use disparate data sources

TRUE ANSWER : ?
YOUR ANSWER : ?

We have Market Basket data for 1,000 rental transactions at a Video Store. There are for videos for rent -- Video A, Video B, Video C and Video D. The probability that both Video C and Video D are rented at the same time is known as ________ .

confidence

the basic probability

lift

support

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

RFM analysis is a BI reporting system.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Commercial courier service

Web portal

E-Mail

Digital dashboard

TRUE ANSWER : ?
YOUR ANSWER : ?

↑