Database - Database Processing for BIS
Exercise :: Database Processing for BIS - General Questions
16.
In OLAP, we are interested in ________ .
A. levels only B. dimensions only C. measures only D. measures and dimensions
Answer: Option D
Explanation:
17.
Which of the following is not a reason that operational data are difficult to read?
A. Non-duplicated data B. Dirty data C. Missing values D. Non-integrated data
Answer: Option A
Explanation:
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 ________ .
A. the basic probability B. support C. lift D. confidence
Answer: Option D
Explanation:
19.
One popular classification technique in Business Intelligence (BI) reporting is ________ .
A. cluster analysis only B. regression analysis only C. RFM analysis only D. both cluster analysis and regression analysis
Answer: Option C
Explanation:
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 ________ .
A. Has ordered recently, orders frequently, and places a large order when she orders. B. Hasn't ordered recently, orders infrequently, but places a large order when she orders. C. Has ordered recently, orders frequently, but doesn't place a large order when she orders D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.
Answer: Option C
Explanation:
