Database - Database Processing for BIS
Exercise :: Database Processing for BIS - General Questions
11.
Business Intelligence (BI) reporting analyses can be performed using ________ .
A.
standard SQL only B.
extensions to SQL only C.
OLAP only D.
both standard SQL and extensions to SQL
Answer: Option A
Explanation:
12.
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.
dirty data B.
inconsistent data C.
non-integrated data D.
a "wrong format" problem
Answer: Option C
Explanation:
13.
The reports generated by a reporting system are usually not delivered in which of the following media?
A.
Web portal B.
Commercial courier service C.
Digital dashboard D.
E-Mail
Answer: Option B
Explanation:
14.
Data mining applications are used accomplish which of the following tasks?
A.
Process transactions only B.
Do RFM analysis only C.
Do what-if analysis only D.
Do both RFM and what-if analysis
Answer: Option C
Explanation:
15.
Which of the following is an unsupervised data mining technique?
A.
Cluster analysis only B.
Regression Analysis only C.
RFM Analysis only D.
Both Regression Analysis and RFM Analysis
Answer: Option A
Explanation: