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
Correct Answer: Process transactions
- 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
Correct Answer: confidence
- 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
Correct Answer: Too much data
- 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
Correct Answer: Data metadata
- 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
Correct Answer: non-integrated data
- 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
Correct Answer: Non-duplicated data
- 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
Correct Answer: analyze and rank customers
- 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
Correct Answer: Process and record transactions only
- 9. The "F" in RFM analysis stands for ________ .
Options- A. frequently
- B. freshness
- C. fast food
- D. fantasy Discuss
Correct Answer: frequently
- 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
Correct Answer: Has ordered recently, orders frequently, but doesn't place a large order when she orders
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.