Discussion
Home ‣ Database ‣ Database Processing for BIS Comments
- Question
Business Intelligence (BI) reporting analyses can be performed using ________ .
Options- A. standard SQL only
- B. extensions to SQL only
- C. OLAP only
- D. both standard SQL and extensions to SQL
- Correct Answer
- standard SQL only
- 1. 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 ________ .
Options- A. the basic probability
- B. support
- C. lift
- D. confidence Discuss
- 2. Which of the following is an unsupervised data mining technique?
Options- A. Cluster analysis only
- B. Regression Analysis only
- C. RFM Analysis only
- D. Both Regression Analysis and RFM Analysis Discuss
- 3. In OLAP, we are interested in ________ .
Options- A. levels only
- B. dimensions only
- C. measures only
- D. measures and dimensions Discuss
- 4. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Options- 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. Discuss
- 5. The "F" in RFM analysis stands for ________ .
Options- A. frequently
- B. freshness
- C. fast food
- D. fantasy Discuss
- 6. 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?
Options- A. Push
- B. Pull
- C. RFM
- D. OLAP Discuss
- 7. Business Intelligence (BI) reporting systems cannot do which of the following operations?
Options- A. Filter data
- B. Group data
- C. Modify data
- D. Both filter and group data Discuss
- 8. One popular classification technique in Business Intelligence (BI) reporting is ________ .
Options- A. cluster analysis only
- B. regression analysis only
- C. RFM analysis only
- D. both cluster analysis and regression analysis Discuss
- 9. Data mining applications are used accomplish which of the following tasks?
Options- A. Process transactions only
- B. Do RFM analysis only
- C. Do what-if analysis only
- D. Do both RFM and what-if analysis Discuss
- 10. A BI reporting system does not ________ .
Options- A. create meaningful information
- B. deliver information to users on a timely basis
- C. use statistical procedures to predict future events
- D. use disparate data sources Discuss
Database Processing for BIS problems
Search Results
Correct Answer: support
Correct Answer: Cluster analysis only
Correct Answer: measures and dimensions
Correct Answer: Has ordered recently, orders frequently, but doesn't place a large order when she orders
Correct Answer: frequently
Correct Answer: Pull
Correct Answer: Modify data
Correct Answer: RFM analysis only
Correct Answer: Do what-if analysis only
Correct Answer: use statistical procedures to predict future events
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.