Database - Database Processing for BIS
Database - Database Processing for BIS
1. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
- Dirty data
- Inconsistent data
- Too much data
- Non-integrated data
2. 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?
- Push
- Pull
- RFM
- OLAP
3. RFM analysis uses customers' purchasing patterns to ________ .
- record transactions
- analyze and rank customers
- predict future sales using regression techniques
- perform OLAP
5. 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 ________ .
- the basic probability
- support
- lift
- confidence
6. Business Intelligence (BI) reporting systems cannot do which of the following operations?
- Filter data
- Group data
- Modify data
- Both filter and group data
7. Which of the following is not a component of a data warehouse?
- Data extraction/cleaning/preparation programs
- Data warehouse data
- Data metadata
- None of the above are data warehouse components.
8.
- Business Intelligence (BI) reporting analyses can be performed using ________ .
- standard SQL only
- extensions to SQL only
- OLAP only
9. 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 ________ .
- dirty data
- inconsistent data
- non-integrated data
- a "wrong format" problem
10. The reports generated by a reporting system are usually not delivered in which of the following media?
- Web portal
- Commercial courier service
- Digital dashboard