logo

CuriousTab

CuriousTab

Database Processing for BIS problems


  • 1. In OLAP, we are interested in ________ .

  • Options
  • A. levels only
  • B. dimensions only
  • C. measures only
  • D. measures and dimensions
  • 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. 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
  • 4. 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
  • Discuss
  • 5. 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
  • 6. 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
  • 7. 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
  • 8. 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
  • 9. 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
  • 10. The reports generated by a reporting system are usually not delivered in which of the following media?

  • Options
  • A. Web portal
  • B. Commercial courier service
  • C. Digital dashboard
  • D. E-Mail
  • Discuss

First 2 3