Database

Database

Database Processing for BIS has 40 Questions
A BI reporting system does not ________ .

create meaningful information
deliver information to users on a timely basis
use statistical procedures to predict future events
use disparate data sources
Business Intelligence (BI) systems do not obtain data from operational databases.

True
False
Which of the following are not done by Business Intelligence (BI) systems?

Analyze past and current activities only
Process and record transactions only
Both of the above are correct.
Neither of the above is correct.
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.

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

Read and process data from an operational database
Process transactions
Process extracts from operational databases
Process data purchased from data vendors
A data warehouse is a database system that is optimized for operational transaction processing.

True
False
The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

Dirty data
Inconsistent data
Too much data
Non-integrated data
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.

True
False
A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

Push
Pull
RFM
OLAP
Most operational databases can be used for many BI applications.

True
False
RFM analysis uses customers' purchasing patterns to ________ .

record transactions
analyze and rank customers
predict future sales using regression techniques
perform OLAP
The data warehouse DBMS needs to be the same DBMS used for the operational database.

True
False
The "F" in RFM analysis stands for ________ .

frequently
freshness
fast food
fantasy
RFM analysis is a BI reporting system.

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

the basic probability
support
lift
confidence
In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.

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

Filter data
Group data
Modify data
Both filter and group data
Report types include static, dynamic, query and OLAP.

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

Data extraction/cleaning/preparation programs
Data warehouse data
Data metadata
None of the above are data warehouse components.
OLAP uses measures, dimensions and associations.

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

standard SQL only
extensions to SQL only
OLAP only
both standard SQL and extensions to SQL
In unsupervised data mining, explanations are created after patterns are found.

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

dirty data
inconsistent data
non-integrated data
a "wrong format" problem
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
The reports generated by a reporting system are usually not delivered in which of the following media?

Web portal
Commercial courier service
Digital dashboard
E-Mail
BI reporting systems summarize the current status of business activities in order to predict future activities.

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

Process transactions only
Do RFM analysis only
Do what-if analysis only
Do both RFM and what-if analysis
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
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
The term neural networks as used in data mining is a misnomer.

True
False
In OLAP, we are interested in ________ .

levels only
dimensions only
measures only
measures and dimensions
Formatting the report is part of authoring a report.

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

Non-duplicated data
Dirty data
Missing values
Non-integrated data
Market basket analysis primarily uses the technique of conditional probabilities.

True
False
We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .

the basic probability
support
lift
confidence
A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.

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

cluster analysis only
regression analysis only
RFM analysis only
both cluster analysis and regression analysis
OnLine Analytical Processing (OLAP) is a BI reporting system.

True
False
We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .

Has ordered recently, orders frequently, and places a large order when she orders.
Hasn't ordered recently, orders infrequently, but places a large order when she orders.
Has ordered recently, orders frequently, but doesn't place a large order when she orders
Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.
Data warehouse data are usually normalized.

True
False