Questions and answers for exam Preparation

MCQs

Total Questions : 40 | Page 2 of 4 pages

Question 11. 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

Discuss Question

Answer: Option B. -> standard SQL only

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

Commercial courier service
E-Mail
Web portal
Digital dashboard

Discuss Question

Answer: Option A. -> Commercial courier service

Question 13. 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

Discuss Question

Answer: Option C. -> non-integrated data

Question 14. Which of the following is an unsupervised data mining technique?

Cluster analysis only
Regression Analysis only
Both Regression Analysis and RFM Analysis
RFM Analysis only

Discuss Question

Answer: Option A. -> Cluster analysis only

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

Do RFM analysis only
Do what-if analysis only
Do both RFM and what-if analysis
Process transactions only

Discuss Question

Answer: Option B. -> Do what-if analysis only

Question 16. In OLAP, we are interested in ________ .

measures and dimensions
dimensions only
levels only
measures only

Discuss Question

Answer: Option A. -> measures and dimensions

Question 17. Which of the following is not a reason that operational data are difficult to read?

Dirty data
Non-integrated data
Missing values
Non-duplicated data

Discuss Question

Answer: Option D. -> Non-duplicated data

Question 18. 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 ________ .

confidence
lift
the basic probability
support

Discuss Question

Answer: Option A. -> confidence

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

both cluster analysis and regression analysis
RFM analysis only
cluster analysis only
regression analysis only

Discuss Question

Answer: Option B. -> RFM analysis only

Question 20. 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, and doesn't place 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

Discuss Question

Answer: Option D. -> Has ordered recently, orders frequently, but doesn't place a large order when she orders