30) Which of the following statements is true about a data mart?
A) It standardizes the format of data retrieved from different systems.
B) It contains selected data from a data warehouse.
C) It stores master data only.
D) It is a compilation of data from the database that is organized and produced in printed format.
E) It helps to eliminate data duplication.
Difficulty: Moderate
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
31) The business processes outlined within strategic plans are often implemented as envisioned
at the managerial and operational levels of the organization.
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
32) Data-driven organizations make decisions that can be backed up with verifiable data and are
measurably more profitable than those that aren’t.
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
33) The structure of data is typically captured in a data model.
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
34) Data dictionaries restrict business rules.
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
11
35) Structured Query Language is the most common language used to interface with relational
database management systems (RDBMSs).
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
36) The primary use of online transaction processing (OLTP) systems is to define a set of
reachable and exploitable vulnerabilities present in a database.
Difficulty: Moderate
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
37) In a distributed online environment, performing real-time analytical processing enhances the
performance of transaction processing.
Difficulty: Moderate
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
38) Master data management is a management rather than a technology-focused issue.
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
39) Write a short note on a continuous planning process and how it is executed.
Difficulty: Easy
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
12
40) Define a database management system. What is an entity? Differentiate between records and
attributes.
Difficulty: Moderate
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
41) Explain the process of consolidating data from operational systems with other organizational
data.
Difficulty: Moderate
Learning Obj.: 6.1: Describe the concept of business intelligence and how databases serve as a
foundation for gaining business intelligence.
Classification: Concept
42) Information and knowledge discovery tools are used primarily to ________.
A) standardize the format of data retrieved from different systems
B) reduce the complexity of the data to be analyzed
C) extract information from existing data
D) analyze information for decision-making support
E) allow managers to learn query language for the effective maintenance of a database
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
13
43) ________ are produced at predefined intervals to support routine decisions.
A) Security reports
B) Exception reports
C) Drill-down reports
D) Scheduled reports
E) Key-indicator reports
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
44) Which of the following statements is true about key-indicator reports?
A) They provide a summary of critical information on a recurring schedule.
B) They help analyze why a key indicator is not at an appropriate level or why an exception
occurred.
C) They are produced at predefined intervals to support routine decisions.
D) They highlight situations that are out of the normal range.
E) They answer unplanned information requests to support a non-routine decision.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
45) Which of the following statements is true about exception reports?
A) They help analyze why a key indicator is not at an appropriate level or why an exception
occurred.
B) They are produced at predefined intervals to support routine decisions.
C) They answer unplanned information requests to support a non-routine decision.
D) They provide a summary of critical information on a recurring schedule.
E) They highlight situations that are out of the normal range.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
14
46) ________ help in analyzing why a key indicator is not at an appropriate level or why an
exception occurred.
A) Activity reports
B) Exception reports
C) Drill-down reports
D) Scheduled reports
E) Key-indicator reports
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
47) Which of the following statements is true about ad hoc queries?
A) They are produced at predefined intervals to support routine decisions.
B) They provide a summary of critical information on a recurring schedule.
C) They help analyze why a key indicator is not at an appropriate level or why an exception
occurred.
D) They answer unplanned information requests to support a non-routine decision.
E) They highlight situations that are out of the normal range.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
48) ________ refers to the process of quickly conducting complex, multidimensional analyses of
data stored in a database that is optimized for retrieval.
A) Concept implementation
B) Online analytical processing
C) Compartmentalization
D) Data mining
E) Predictive analysis
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
15
49) Online analytical processing tools enable users to ________.
A) discover hidden predictive relationships in the data
B) find associations or correlations among sets of items
C) analyze different dimensions of data beyond simple data summaries
D) group related records together on the basis of having similar values for attributes
E) extract textual information from Web documents
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
50) Which of the following statements is true about an online analytical processing server?
A) It is a data structure allowing for multiple dimensions to be added to a traditional two-
dimensional table.
B) It groups related records together on the basis of having similar values for attributes.
C) It allows you to make hypothetical changes to the data associated with a problem and observe
how these changes influence the results.
D) It uses reasoning methods based on knowledge about a specific problem domain in order to
provide advice.
E) It understands how data are organized in a database and has special functions for analyzing
the data.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
51) How do online analytical processing systems improve performance?
A) They preaggregate data so that only the subset of the data necessary for the queries is
extracted.
B) They use reasoning methods to outline how sensitive information will be handled, stored,
transmitted, and destroyed.
C) They make hypothetical changes to the data associated with a problem.
D) They allow for multiple dimensions to be added to a traditional two-dimensional table.
E) They provide capabilities for discovering hidden predictive relationships in the data.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
16
52) In online analytic processing systems, ________ are the values or numbers the user wants to
analyze.
A) dimensions
B) forms
C) measures
D) queries
E) entities
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
53) In online analytical processing systems, ________ provide a way to summarize the data.
A) forms
B) measures
C) facts
D) records
E) dimensions
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
54) Which of the following statements is true about the online analytic processing cube?
A) It allows you to make hypothetical changes to the data associated with a problem and observe
how these changes influence the results.
B) It groups related records together on the basis of having similar values for attributes.
C) It understands how data are organized in the database and has special functions for analyzing
the data.
D) It is a data structure allowing for multiple dimensions to be added to a traditional two-
dimensional table.
E) It uses reasoning methods based on knowledge about a specific problem domain in order to
provide advice.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
17
55) Data mining complements online analytical processing in that it ________.
A) finds associations or correlations among sets of items
B) provides capabilities for discovering hidden predictive relationships in the data
C) extracts textual information from Web documents
D) groups related records together on the basis of having similar values for attributes
E) analyzes different dimensions of data beyond simple data summaries
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
56) ________ can be achieved by rolling up a data cube to the smallest level of aggregation
needed, reducing the dimensionality, or dividing continuous measures into discrete intervals.
A) Data cleansing
B) Normalization
C) Clustering
D) Data reduction
E) Inferencing
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
57) Which of the following statements is true about association discovery?
A) It is a technique used to find correlations among sets of items.
B) It is the process of grouping related records together on the basis of having similar values for
attributes.
C) It is the use of analytical techniques for extracting information from textual documents.
D) It is a type of intelligent system that uses reasoning methods based on knowledge about a
specific problem domain in order to provide advice.
E) It makes sure that each table contains only attributes that are related to an entity.
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
18
58) ________ is the process of grouping related records together on the basis of having similar
values for attributes.
A) Normalization
B) Data mining
C) Clustering
D) Inferencing
E) Slicing and dicing
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
59) ________ refers to the use of analytical techniques for extracting information from textual
documents.
A) Web usage mining
B) Text underlining
C) Text mining
D) Decision making
E) Web content mining
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
60) ________ refers to extracting textual information from online documents.
A) Web usage mining
B) Web crawling
C) Text mining
D) Decision making
E) Web content mining
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
19
61) Which of the following is used for Web content mining?
A) clustering
B) Web underlining
C) neural networks
D) Web crawler
E) data reduction
Difficulty: Moderate
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
62) ________ is used by organizations to determine patterns in customers’ usage data.
A) Web usage mining
B) Web crawling
C) Text mining
D) Decision making
E) Web content mining
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
63) Which of the following is a recording of a user’s path through a Web site?
A) clustering
B) normalization
C) slicing and dicing
D) clickstream data
E) inferencing
Difficulty: Easy
Learning Obj.: 6.2: Explain the three components of business intelligence: information and
knowledge discovery, business analytics, and information visualization.
Classification: Concept
20