Database - Database Processing for BIS

Exercise : Database Processing for BIS - General Questions
16.
In OLAP, we are interested in ________ .
levels only
dimensions only
measures only
measures and dimensions
Answer: Option
Explanation:
No answer description is available. Let's discuss.

17.
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
Answer: Option
Explanation:
No answer description is available. Let's discuss.

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 ________ .
the basic probability
support
lift
confidence
Answer: Option
Explanation:
No answer description is available. Let's discuss.

19.
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
Answer: Option
Explanation:
No answer description is available. Let's discuss.

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, 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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.