Business Intelligence (BI) systems do not obtain data from operational databases.
Select an option to see the answer and solution.
Database · all questionsDatabase Processing for BIS
Database Processing for BIS
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
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.
Select an option to see the answer and solution.
A data warehouse is a database system that is optimized for operational transaction processing.
Select an option to see the answer and solution.
Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing.
Select an option to see the answer and solution.
Most operational databases can be used for many BI applications.
Select an option to see the answer and solution.
The data warehouse DBMS needs to be the same DBMS used for the operational database.
Select an option to see the answer and solution.
RFM analysis is a BI reporting system.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.
Report types include static, dynamic, query and OLAP.
Select an option to see the answer and solution.
OLAP uses measures, dimensions and associations.
Select an option to see the answer and solution.
In unsupervised data mining, explanations are created after patterns are found.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.
BI reporting systems summarize the current status of business activities in order to predict future activities.
Select an option to see the answer and solution.
Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.
Select an option to see the answer and solution.
The term neural networks as used in data mining is a misnomer.
Select an option to see the answer and solution.
Formatting the report is part of authoring a report.
Select an option to see the answer and solution.
Market basket analysis primarily uses the technique of conditional probabilities.
Select an option to see the answer and solution.
A data mart is a collection of data that, while smaller than a data warehouse, still addresses the entire business.
Select an option to see the answer and solution.
OnLine Analytical Processing (OLAP) is a BI reporting system.
Select an option to see the answer and solution.
Data warehouse data are usually normalized.
Select an option to see the answer and solution.