Database Processing for BIS Questions and Answers

Q: Which of the following are not done by Business Intelligence (BI) systems?

Correct answer: Process and record transactions onlyRecording transactions is the work of an operational system, not a business intelligence one. A BI system reads data that operational systems have already recorded and turns it into information for decision making. The two are deliberately separated so that heavy analytical queries do not compete with transaction processing for the same resources.

Q: Business Intelligence (BI) systems do not obtain their data by which of the following means?

Correct answer: Process transactionsBI systems obtain data by reading an operational database directly, by processing extracts taken from one, or by processing data bought from a vendor. What they do not do is process transactions themselves - that is the operational system’s job, and keeping the two apart is what protects transaction performance from analytical load.

Q: The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

Correct answer: Too much dataThe curse of dimensionality is the problem of having so many attributes that the analysis becomes unmanageable: the number of possible combinations grows exponentially with the number of dimensions, and the data available thins out across them. It is a problem of quantity and breadth rather than of quality, so it is distinct from dirty, inconsistent or non-integrated data.

Q: 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?

Correct answer: PullThe distinction is who initiates the delivery. In pull mode the user goes to the website and requests the report; in push mode the system sends it out on a schedule or when an event occurs, by e-mail or to a dashboard. A report sitting on a site waiting to be accessed is therefore pull, whatever technology delivers it.

Q: RFM analysis uses customers' purchasing patterns to ________ .

Correct answer: analyze and rank customersRFM analysis scores each customer on how recently they ordered, how frequently they order and how much money they spend, and uses the three scores to rank them into groups. It is a reporting technique built on simple sorting and grouping, not a predictive one, which is why it belongs with reporting rather than with data mining.

Q: The "F" in RFM analysis stands for ________ .

Correct answer: frequentlyThe three letters stand for recency, frequency and monetary value - how recently the customer last ordered, how often they order, and how much they spend. Each is scored one to five by dividing the customer base into fifths, and the resulting three-digit score is what the analysis ranks customers by.

Q: 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 ________ .

Correct answer: supportSupport is the probability that a set of items appears together in a transaction - here the fraction of the thousand rentals containing both Video C and Video D. It is an unconditional probability of the whole combination. Confidence, by contrast, is conditional: the probability of D given that C was rented.

Q: Business Intelligence (BI) reporting systems cannot do which of the following operations?

Correct answer: Modify dataA reporting system reads: it filters, sorts, groups and calculates, and it delivers the result. It does not write back to the source, and it must not, since the data it reads belongs to operational systems whose integrity depends on transactions rather than on reports. Filtering and grouping are exactly what it does do.

A BI reporting system does not ________ .

A.create meaningful information
B.deliver information to users on a timely basis
C.use statistical procedures to predict future events
D.use disparate data sources

Answer: C

Correct answer: use statistical procedures to predict future events

A reporting system creates information from existing data by filtering, sorting, grouping and calculating simple arithmetic, and then delivers it to the right users at the right time, drawing on whatever sources are needed. Prediction using statistical procedures belongs to the other branch of business intelligence, data mining, which is exactly the distinction the two categories are defined by.

Discuss in Forum

Which of the following are not done by Business Intelligence (BI) systems?

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.

Answer: B

Correct answer: Process and record transactions only

Recording transactions is the work of an operational system, not a business intelligence one. A BI system reads data that operational systems have already recorded and turns it into information for decision making. The two are deliberately separated so that heavy analytical queries do not compete with transaction processing for the same resources.

Discuss in Forum

Business Intelligence (BI) systems do not obtain their data by which of the following means?

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

Answer: B

Correct answer: Process transactions

BI systems obtain data by reading an operational database directly, by processing extracts taken from one, or by processing data bought from a vendor. What they do not do is process transactions themselves - that is the operational system’s job, and keeping the two apart is what protects transaction performance from analytical load.

Discuss in Forum

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: C

Correct answer: Too much data

The curse of dimensionality is the problem of having so many attributes that the analysis becomes unmanageable: the number of possible combinations grows exponentially with the number of dimensions, and the data available thins out across them. It is a problem of quantity and breadth rather than of quality, so it is distinct from dirty, inconsistent or non-integrated data.

Discuss in Forum

In a data warehouse, what is a data mart ?

A.A copy of the operational database
B.A subset of a data warehouse serving a single department or subject area
C.The tool used to load data into the warehouse
D.A report generated from the warehouse

Answer: C

Correct answer: A subset of a data warehouse serving a single department or subject area

A data mart narrows the warehouse to the data one group actually needs, which makes queries faster and access control simpler. It may be carved out of an existing warehouse or built first and later consolidated into one.

Discuss in Forum

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: B

Correct answer: Pull

The distinction is who initiates the delivery. In pull mode the user goes to the website and requests the report; in push mode the system sends it out on a schedule or when an event occurs, by e-mail or to a dashboard. A report sitting on a site waiting to be accessed is therefore pull, whatever technology delivers it.

Discuss in Forum

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: B

Correct answer: analyze and rank customers

RFM analysis scores each customer on how recently they ordered, how frequently they order and how much money they spend, and uses the three scores to rank them into groups. It is a reporting technique built on simple sorting and grouping, not a predictive one, which is why it belongs with reporting rather than with data mining.

Discuss in Forum

The "F" in RFM analysis stands for ________ .

A.frequently
B.freshness
C.fast food
D.fantasy

Answer: A

Correct answer: frequently

The three letters stand for recency, frequency and monetary value - how recently the customer last ordered, how often they order, and how much they spend. Each is scored one to five by dividing the customer base into fifths, and the resulting three-digit score is what the analysis ranks customers by.

Discuss in Forum

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: B

Correct answer: support

Support is the probability that a set of items appears together in a transaction - here the fraction of the thousand rentals containing both Video C and Video D. It is an unconditional probability of the whole combination. Confidence, by contrast, is conditional: the probability of D given that C was rented.

Discuss in Forum

10.

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: C

Correct answer: Modify data

A reporting system reads: it filters, sorts, groups and calculates, and it delivers the result. It does not write back to the source, and it must not, since the data it reads belongs to operational systems whose integrity depends on transactions rather than on reports. Filtering and grouping are exactly what it does do.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Database Processing for BIS Questions and Answers || Database Processing for BIS MCQ Questions and Answers || Database Processing for BIS GK Questions and Answers || Database Processing for BIS GK MCQ Questions || Database Processing for BIS Multiple Choice Questions and Answers || Database Processing for BIS GK || GK on Database Processing for BIS || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Database Processing for BIS Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications