Database Processing for BIS Questions and Answers

Practice Mode
Showing 10 of 17 questions
Q1
The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
  • A Dirty data
  • B Inconsistent data
  • C Too much data
  • D Non-integrated data
Answer: Option C
Q2
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?
  • A Push
  • B Pull
  • C RFM
  • D OLAP
Answer: Option B
Q3
 RFM analysis uses customers' purchasing patterns to ________ .
  • A record transactions
  • B analyze and rank customers
  • C predict future sales using regression techniques
  • D perform OLAP
Answer: Option B
Q4
The "F" in RFM analysis stands for ________ .
  • A frequently
  • B freshness
  • C fast food
  • D fantasy
Answer: Option A
Q5
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 ________ .
  • A the basic probability
  • B support
  • C lift
  • D confidence
Answer: Option B
Q6
Business Intelligence (BI) reporting systems cannot do which of the following operations?
  • A Filter data
  • B Group data
  • C Modify data
  • D Both filter and group data
Answer: Option C
Q7
Which of the following is not a component of a data warehouse?
  • A Data extraction/cleaning/preparation programs
  • B Data warehouse data
  • C Data metadata
  • D None of the above are data warehouse components.
Answer: Option C
Q8
  • A Business Intelligence (BI) reporting analyses can be performed using ________ .
  • B standard SQL only
  • C extensions to SQL only
  • D OLAP only
Answer: Option A
Q9
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 ________ .
  • A dirty data
  • B inconsistent data
  • C non-integrated data
  • D a "wrong format" problem
Answer: Option C
Q10
The reports generated by a reporting system are usually not delivered in which of the following media?
  • A Web portal
  • B Commercial courier service
  • C Digital dashboard
  • D E-Mail
Answer: Option B

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test