DATABASE PROCESSING FOR BIS QUIZ

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

Group data

Filter data

Both filter and group data

Modify data

TRUE ANSWER : ?
YOUR ANSWER : ?

Report types include static, dynamic, query and OLAP.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Process extracts from operational databases

Process transactions

Process data purchased from data vendors

Read and process data from an operational database

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Do what-if analysis only

Do RFM analysis only

Process transactions only

Do both RFM and what-if analysis

TRUE ANSWER : ?
YOUR ANSWER : ?

BI reporting systems summarize the current status of business activities in order to predict future activities.

True

False

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

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

extensions to SQL only

standard SQL only

OLAP only

both standard SQL and extensions to SQL

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

Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

RFM analysis uses customer's purchasing patterns to ________ .

record transactions

predict future sales using regression techniques

analyze and rank customers

perform OLAP

TRUE ANSWER : ?
YOUR ANSWER : ?

↑