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

Process extracts from operational databases

Read and process data from an operational database

Process extracts from operational databases

Process data purchased from data vendors

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

Analyze past and current activities only

Process and record transactions only

Neither of the above is correct.

A BI reporting system does ________ .

deliver information to users on a timely basis

use statistical procedures to predict future events

Which of the following is a component of a data warehouse?

None of the above are data warehouse components.

Data extraction/cleaning/preparation programs

None of the above are data warehouse components.

*/*_Which of the following is an unsupervised data mining technique??

Both Regression Analysis and RFM Analysis

*/*_Which of the following is not a component of a data warehouse??

None of the above are data warehouse components.

Data extraction/cleaning/preparation programs

None of the above are data warehouse components.

*/*_We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .?

Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

Has ordered recently, orders frequently, and places a large order when she orders.

Hasn't ordered recently, orders infrequently, but places a large order when she orders.

Has ordered recently, orders frequently, but doesn't place a large order when she orders

Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

_ Data mining applications are used accomplish which of the following tasks?$?

Do both RFM and what-if analysis

_ One popular classification technique in Business Intelligence (BI) reporting is ________ .$?

both cluster analysis and regression analysis

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

Process extracts from operational databases

Read and process data from an operational database

Process extracts from operational databases

Process data purchased from data vendors

RFM analysis uses customer's purchasing patterns to ________ .

predict future sales using regression techniques

41 + Mcqs in Database Processing For Bis in Database Page 1 McqOptions

1.	Business Intelligence (BI) systems do 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» C. Process extracts from operational databases

Discussion

2.	Which of the following are 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» C. Both of the above are correct.

Discussion

3.	A BI reporting system does ________ .
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» D. use disparate data sources

Discussion

4.	Business Intelligence (BI) reporting systems do which of the following operations?
A.	Filter data
B.	Group data
C.	Modify data
D.	Both filter and group data
Answer» D. Both filter and group data

Discussion

5.	Which of the following is 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» D. None of the above are data warehouse components.

Discussion

6.	Which of the following is a reason that operational data are difficult to read?
A.	Non-duplicated data
B.	Dirty data
C.	Missing values
D.	Non-integrated data
Answer» B. Dirty data

Discussion

7.	The reports generated by a reporting system are usually delivered in which of the following media?
A.	Web portal
B.	Commercial courier service
C.	Digital dashboard
D.	E-Mail
Answer» C. Digital dashboard

Discussion

8.	The term neural networks as used in data mining is a misnomer.%!
A.	True
B.	False
Answer» B. False

Discussion

9.	OLAP uses measures, dimensions and associations.%!
A.	True
B.	False
Answer» C.

Discussion

10.	Most operational databases can be used for many BI applications.%!
A.	True
B.	False
Answer» C.

Discussion

11.	Data warehouse data are usually normalized.%!
A.	True
B.	False
Answer» C.

Discussion

12.	Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.%!
A.	True
B.	False
Answer» C.

Discussion

13.	Report types include static, dynamic, query and OLAP.%!
A.	True
B.	False
Answer» B. False

Discussion

14.	Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.%!
A.	True
B.	False
Answer» C.

Discussion

15.	OnLine Analytical Processing (OLAP) is a BI reporting system.%!
A.	True
B.	False
Answer» B. False

Discussion

16.	BI reporting systems summarize the current status of business activities in order to predict future activities.%!
A.	True
B.	False
Answer» C.

Discussion

17.	In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.%!
A.	True
B.	False
Answer» B. False

Discussion

18.	A data warehouse is a database system that is optimized for operational transaction processing.%!
A.	True
B.	False
Answer» C.

Discussion

19.	A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.%!
A.	True
B.	False
Answer» C.

Discussion

20.	The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.%!
A.	True
B.	False
Answer» C.

Discussion

21.	RFM analysis is a BI reporting system.%!
A.	True
B.	False
Answer» B. False

Discussion

22.	Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.%!
A.	True
B.	False
Answer» C.

Discussion

23.	Market basket analysis primarily uses the technique of conditional probabilities.%!
A.	True
B.	False
Answer» C.

Discussion

24.	In unsupervised data mining, explanations are created after patterns are found.%!
A.	True
B.	False
Answer» B. False

Discussion

25.	The data warehouse DBMS needs to be the same DBMS used for the operational database.%!
A.	True
B.	False
Answer» C.

Discussion

26.	Business Intelligence (BI) systems do not obtain data from operational databases.%!
A.	True
B.	False
Answer» C.

Discussion

27.	Formatting the report is part of authoring a report.%!
A.	True
B.	False
Answer» B. False

Discussion

28.	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» C. RFM

Discussion

29.	/_Which of the following is an unsupervised data mining technique??
A.	Cluster analysis only
B.	Regression Analysis only
C.	RFM Analysis only
D.	Both Regression Analysis and RFM Analysis
Answer» B. Regression Analysis only

Discussion

30.	/_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» D. None of the above are data warehouse components.

Discussion

31.	/_We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .?
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.
Answer» D. Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

Discussion

32.	/_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» C. RFM

Discussion

33.	_ Data mining applications are used accomplish which of the following tasks?$?
A.	Process transactions only
B.	Do RFM analysis only
C.	Do what-if analysis only
D.	Do both RFM and what-if analysis
Answer» D. Do both RFM and what-if analysis

Discussion

34.	_ 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» D. Both filter and group data

Discussion

35.	_ One popular classification technique in Business Intelligence (BI) reporting is ________ .$?
A.	cluster analysis only
B.	regression analysis only
C.	RFM analysis only
D.	both cluster analysis and regression analysis
Answer» D. both cluster analysis and regression analysis

Discussion

36.	__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» D. Non-integrated data

Discussion

37.	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» C. Digital dashboard

Discussion

38.	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» C. lift

Discussion

39.	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 ________ .$?
A.	the basic probability
B.	support
C.	lift
D.	confidence
Answer» E.

Discussion

40.	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» C. Process extracts from operational databases

Discussion

41.	RFM analysis uses customer's purchasing patterns to ________ .
A.	record transactions
B.	analyze and rank customers
C.	predict future sales using regression techniques
D.	perform OLAP
Answer» C. predict future sales using regression techniques

Discussion

Explore topic-wise MCQs in Database.

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

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

A BI reporting system does ________ .

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

Which of the following is a component of a data warehouse?

Which of the following is a reason that operational data are difficult to read?

The reports generated by a reporting system are usually delivered in which of the following media?

The term neural networks as used in data mining is a misnomer.%!

OLAP uses measures, dimensions and associations.%!

Most operational databases can be used for many BI applications.%!

Data warehouse data are usually normalized.%!

Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.%!

Report types include static, dynamic, query and OLAP.%!

Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.%!

OnLine Analytical Processing (OLAP) is a BI reporting system.%!

BI reporting systems summarize the current status of business activities in order to predict future activities.%!

In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.%!

A data warehouse is a database system that is optimized for operational transaction processing.%!

A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.%!

The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.%!

RFM analysis is a BI reporting system.%!

Data Mining uses simple arithmetic techniques such as sums, averages, and groupings to perform what-if analyses, to make predictions, and to facilitate decision making.%!

Market basket analysis primarily uses the technique of conditional probabilities.%!

In unsupervised data mining, explanations are created after patterns are found.%!

The data warehouse DBMS needs to be the same DBMS used for the operational database.%!

Business Intelligence (BI) systems do not obtain data from operational databases.%!

Formatting the report is part of authoring a report.%!

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?%!

*/*_Which of the following is an unsupervised data mining technique??

*/*_Which of the following is not a component of a data warehouse??

*/*_We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .?

*/*_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??

_ Data mining applications are used accomplish which of the following tasks?$?

_ Business Intelligence (BI) reporting systems cannot do which of the following operations?$?

_ One popular classification technique in Business Intelligence (BI) reporting is ________ .$?

__The "curse of dimensionality" relates to which problem of using operational data for BI reporting?__

The reports generated by a reporting system are usually not delivered in which of the following media?$?

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 ________ .$?

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 ________ .$?

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

RFM analysis uses customer's purchasing patterns to ________ .

/_Which of the following is an unsupervised data mining technique??

/_Which of the following is not a component of a data warehouse??

/_We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .?

/_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??

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