logo

CuriousTab

CuriousTab

Discussion


Home Database Database Processing for BIS Comments

  • Question
  • 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.

  • Correct Answer
  • Process and record transactions only 


  • Database Processing for BIS problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 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. 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
    • 6. The "F" in RFM analysis stands for ________ .

    • Options
    • A. frequently
    • B. freshness
    • C. fast food
    • D. fantasy
    • Discuss
    • 7. 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
    • 8. In OLAP, we are interested in ________ .

    • Options
    • A. levels only
    • B. dimensions only
    • C. measures only
    • D. measures and dimensions
    • Discuss
    • 9. 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
    • 10. 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


    Comments

    There are no comments.

Enter a new Comment