logo

CuriousTab

CuriousTab

Database Processing for BIS problems


  • 1. Business Intelligence (BI) systems do not obtain their data by which of the following means?

  • Options
  • A. Read and process data from an operational database
  • B. Process transactions
  • C. Process extracts from operational databases
  • D. Process data purchased from data vendors
  • Discuss
  • 2. 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 ________ .

  • Options
  • A. the basic probability
  • B. support
  • C. lift
  • D. confidence
  • Discuss
  • 3. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

  • Options
  • A. Dirty data
  • B. Inconsistent data
  • C. Too much data
  • D. Non-integrated data
  • Discuss
  • 4. Which of the following is not a component of a data warehouse?

  • Options
  • A. Data extraction/cleaning/preparation programs
  • B. Data warehouse data
  • C. Data metadata
  • D. None of the above are data warehouse components.
  • Discuss
  • 5. 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 ________ .

  • Options
  • A. dirty data
  • B. inconsistent data
  • C. non-integrated data
  • D. a "wrong format" problem
  • Discuss
  • 6. Which of the following is not a reason that operational data are difficult to read?

  • Options
  • A. Non-duplicated data
  • B. Dirty data
  • C. Missing values
  • D. Non-integrated data
  • Discuss
  • 7. RFM analysis uses customers' purchasing patterns to ________ .

  • Options
  • A. record transactions
  • B. analyze and rank customers
  • C. predict future sales using regression techniques
  • D. perform OLAP
  • Discuss
  • 8. Which of the following are not done by Business Intelligence (BI) systems?

  • Options
  • A. Analyze past and current activities only
  • B. Process and record transactions only
  • C. Both of the above are correct.
  • D. Neither of the above is correct.
  • Discuss
  • 9. The "F" in RFM analysis stands for ________ .

  • Options
  • A. frequently
  • B. freshness
  • C. fast food
  • D. fantasy
  • Discuss
  • 10. 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

First 2 3