DATABASE PROCESSING FOR BIS QUIZ

OnLine Analytical Processing (OLAP) is a BI reporting system.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

One popular classification technique in Business Intelligence (BI) reporting is ________ .

both cluster analysis and regression analysis

RFM analysis only

regression analysis only

cluster analysis only

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

Report types include static, dynamic, query and OLAP.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.

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

OLAP uses measures, dimensions and associations.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Formatting the report is part of authoring a report.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Business Intelligence (BI) reporting systems cannot do which of the following operations?

Modify data

Group data

Both filter and group data

Filter data

TRUE ANSWER : ?
YOUR ANSWER : ?

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

both standard SQL and extensions to SQL

standard SQL only

extensions to SQL only

OLAP only

TRUE ANSWER : ?
YOUR ANSWER : ?

↑