Database Processing for BIS Questions and Answers
Database Processing for BIS
Showing 10 of
17 questions
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
4. The "F" in RFM analysis stands for ________ .
- frequently
- freshness
- fast food
- fantasy
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