Chapter 6 – Valuing Organizational Information
Question 1 The
completeness characteristic of high-quality information ensures that there are
no missing data values.
True
False
Question 2 Reports
for each sales person, product, and part are examples of detail or fine
information granularities.
True
False
Question 3 Which
of the following represents the different information levels?
Detail, summary, aggregate
Document,
presentation, spreadsheet, database
Individual,
department, enterprise
None of the above
Question 4 Which
of the following implies that information is current with respect to the
business requirements?
Uniqueness
Accuracy
Consistency
Timeliness
Question 5 Transactional
information is used when performing operational tasks and repetitive decisions
such as analyzing daily sales reports and production schedules to determine how
much inventory to carry.
True
False
Question 6 Which
of the following is an example of transactional information?
Trend projection
Sales projection
Purchasing
stock
All of the above
Question 7 Which
of the following is an example of transactional information?
Withdrawing cash from an ATM
Making an airline reservation
Purchasing stock
All of
the above
Question 8 Which
of the following is a characteristic of information?
Type (Transactional & Analytical)
Timeliness
Quality
All of
the above
Question 9 What
is a real-time system?
Provides
real-time information in response to query requests
Encompasses all of the information contained within a single
business process or unit of work, and its primary purpose is to support the
performing of daily operational tasks
Encompasses all organization information, and its primary
purpose is to support the performing of managerial analysis tasks
Provides immediate, up-to-date information
Question 10 Which
of the following is not
one of the five characteristics common to high quality information?
Accuracy
Completeness
Quantity
Consistency
Question 11 What
encompasses all of the information contained within a single business process
or unit of work, and its primary purpose is to support the performing of daily
operational tasks?
Transactional
information
Timeliness
Quality
Analytical information
Question 12 Which
of the following implies that aggregate or summary information is in agreement
with detailed information?
Accuracy
Timeliness
Consistency
Uniqueness
Completeness
Question 13 Transactional
information encompasses all organizational information and its primary purpose
is to support the performing of managerial analysis tasks.
True
False
Question 14 What
are the different types of information?
Data, formats, granularities
Levels, forms, granularities
Levels,
formats, granularities
Levels, forms, data
Question 15 Which
of the following represents the different information formats?
Individual, department, enterprise
Detail, summary, aggregate
Document,
presentation, spreadsheet, database
None of the above
Question 16 Organizations
use transactional information to make repetitive decisions.
True
False
Question 17 A
Purchasing stock is an example of analytical information.
True
False
Question 18 What is
immediate, up-to-date information?
Real-time
information
Real-time systems
Information granularity
All of the above
Question 19 What
encompasses all organizational information and its primary purpose is to
support the performing of managerial analysis tasks?
Analytical
information
Transactional information
Timeliness
Quality
Question 20 Which
of the following represents the different information granularities?
Detail,
summary, aggregate
Document, presentation, spreadsheet, database
Individual, department, enterprise
None of the above
Question 21 Organizations
use analytical information to make ad hoc decisions.
True
False
Question 22 All of
the following are characteristics of information, except:
Analytical
Transactional
Timeliness
Quantity
Question 23 What
provides real-time information in response to query requests?
Real-time information
Real-time
systems
Information level
All of the above
Question 24 The
uniqueness characteristic of high-quality information ensures that all the values
are correct.
True
False
Question 25 Timely
information must be up-to-the-second to be accurate.
True
False
Question 26 ___________
achieved great success by managing information
Office Max
AT&T
Staples
Samsung
Electronics
Question 27 Organizational
information comes in different levels, formats, and granularities.
True
False
Question 28 Which
of the following represents a level of information within an organization?
Individual
Enterprise
Department
All of
the above
Question 29 What is
one of the biggest pitfalls associated with real-time information?
It is only available in aggregate levels of granularity.
It
continually changes.
It rarely changes
It is only available to high-level executives due to the
expense.
Question 30 What is
it called when each transaction, entity, and event is represented only once in
the information?
Timeliness
Uniqueness
Consistency
Accuracy
Question 31 Match
the following characteristics of high quality information with their
definition.
1. Accuracy - All values are
correct
2. Completeness - No values
are missing
3. Consistency - Summary and
detailed information are in agreement
4. Uniqueness - Each thing
is represented only once
5. Timeliness - Information
is current with respect to business requirements
Chapter 7 Storing Organizational Information--Database
Question 1 Ideally,
an organization only wants to build forward integrations.
True
False
Question 2 The
physical view and the logical view are the same in a relational database
management system.
True
False
Question 3 A
foreign key in the relational database model is a primary key of one table that
appears as an attribute in another table.
True
False
Question 4 What
is integration?
Allows
separate systems to communicate directly with each other
Takes information entered into a given system and sends it
to the database
Takes information entered into a given system and sends it
to other processes
Takes information entered into a given system and sends it
to the DBMS
Question 5 A
data-driven website is an interactive website kept constantly updated and
relevant to the needs of its customers through the use of a database.
True
False
Question 6 What
refers to how well a system can adapt to increased demands?
Performance
Scalability
Information integrity
Redundancy
Question 7 A
database management system (DBMS) can only interact with other software
application programs.
True
False
Question 8 In the
relational database model, what are characteristics or properties of an entity?
Entity
Logical view
Physical view
Attribute
Question 9 Why do
relational databases use primary keys and foreign keys?
To
create logical relationships
To create a database
To create physical relationships
All of the above
Question 10 A
foreign key is a field (or group of fields) that uniquely identifies a given
entity in a table.
True
False
Question 11 What is
the physical view of information?
Deals
with the physical storage of information on a storage device such as a hard
disk
Focuses on how users logically access information to meet
their particular business needs
Deals with the logical storage of information on a storage
device such as a hard disk
Focuses on how users physically access information to meet
their particular business needs
Question 12 What
type of website is best to build for a general informational website with
static information?
Data-driven website
Static
website
Relational website
All of the above
Question 13 Which
of the following is true in regards to the elimination of redundant
information?
Uses additional hard disk space
Makes performing information updates harder
Improves
information quality
All of the above
Question 14 What
type of integrity constraint does not allow someone to create an order for a
nonexistent customer?
Relational
integrity constraint
Business-critical integrity constraint
Information-critical integrity constraint
None of the above
Question 15 Relational
integrity constraints are rules that enforce basic and fundamental
information-based constraints.
True
False
Question 16 What
type of website is best to build for a website with continually changing
information including press releases, new product information, and updated
pricing?
Data-driven
website
Static website
Relational website
All of the above
Question 17 What is
a backward integration?
Takes information entered into a given system and sends it
to the application generation component
Takes information entered into a given system and sends it
automatically to all downstream systems and processes
Takes
information entered into a given system and sends it automatically to all
upstream systems and processes
Takes information entered into a given system and sends it
to the DBMS
Question 18 Redundancy
is the duplication of information, or storing the same information in multiple
places.
True
False
Question 19 Which
of the following database structures stores information in a tree-like
structure that allows repeating information using parent/child relationships,
in such a way that it cannot have too many relationships?
Hierarchical
database
Network database
Relational database model
All of the above
Question 20 All of
the following are advantages of database-stored information, except:
Increased
information redundancy
Increased flexibility
Increased information integrity
Increased performance
Question 21 What is
a forward integration?
Takes information entered into a given system and sends it
automatically to all upstream systems and processes
Takes information entered into a given system and sends it
to the DBMS
Takes
information entered into a given system and sends it automatically to all
downstream systems and processes
Takes information entered into a given system and sends it
to the application generation component
Question 22 What is
an interactive website kept constantly updated and relevant to the needs of its
customers through the use of a database?
Customer-driven database
Data-driven
website
Data-driven database
Customer-driven website
Question 23 What is
a primary key?
A field (or group of fields) that uniquely identifies a
given attribute in a table
A field
(or group of fields) that uniquely identifies a given entity in a table
A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship among the two tables
Characteristics or properties of an entity
Question 24 Which
of the following measures how quickly a system performs a certain process or
transaction?
Scalability
Information integrity
Redundancy
Performance
Question 25 What is
a foreign key?
A field (or group of fields) that uniquely identifies a
given entity in a table
Characteristics or properties of an entity
A
primary key of one table that appears as an attribute in another table and acts
to provide a logical relationship among the two tables
A field (or group of fields) that uniquely identifies a
given attribute in a table
Question 26 Which
of the following database structures offers a flexible way of representing
objects and their relationships?
Hierarchical database
Network
database
Relational database model
All of the above
Question 27 A
central repository does not allow information to be integrated across multiple
systems.
True
False
Question 28 One of
the advantages found in a relational database is increased information
redundancy.
True
False
Question 29 In the
relational database model, what is a person, place, thing, transaction, or
event about which information is stored?
Physical view
Logical view
Entity
Attribute
Question 30 What
are the rules that help ensure the quality of information?
Business-critical integrity constraints
Relational integrity constraints
Information integrity
Integrity
constraints
Question 31 Match
the term with the appropriate definition.
1. Database = Maintains
information about various types of objects, events, people, and places
2. Database Management System
(DBMS) = Software through which users and application programs interact
with a database
3. Relational Data Model = A
type of database that stores information in the form of logically related two-dimensional
tables
4. Data-driven website = an
interactive website kept constantly updated and relevant to the needs of its
customers through the use of a database
5. Integration = Allows
separate systems to communicate directly with each other
Chapter 8 – Accessing Organizational Information – Data
Warehouse
Question 1 What
is information that people use to support their decision-making efforts?
Data mining
Business
intelligence
Information cleansing and scrubbing
Data-mining tools
Question 2 Why
would a business use a data warehouse that offers strategic level, external,
integrated, and historical information?
Identify trends
Make projections
Decide key business issues
All of
the above
Question 3 Achieving
perfect information is almost impossible. The more complete and accurate an
organization wants its information to be, the more it costs. Which two
variables are used to determine the trade-off for perfect information?
Accessibility versus completeness
Accessibility versus complexity
Accuracy versus complexity
Accuracy
versus completeness
Question 4 When
does information cleansing occur in the data warehouse?
During the ETL process
During
the ETL process and once it is in the data warehouse
During the ETL process and before it is in the data
warehouse
On the information, once it is in the data warehouse
Question 5 Which
of the following does not draw a parallel between the challenges in business
and the challenges of war?
Discerning patterns and meaning in the information
Responding to the resultant information
Collecting information
Accurate
and complete information
Question 6 Information
cleansing or scrubbing is the process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information.
True
False
Question 7 Business
intelligence (BI) refers to applications and technologies that are used to
gather, provide access to, and analyze data and information to support
decision-making efforts.
True
False
Question 8 The
primary purpose of a data warehouse is to perform transactional processes.
True
False
Question 9 The
Data Warehousing Institute estimates that low-quality information costs U.S.
businesses $60 billion annually.
True
False
Question 10 What is
the primary purpose of a data warehouse?
To disaggregate information throughout an organization into
multiple repositories in such a way that employees can make decisions and
undertake business analysis activities.
To aggregate information throughout an organization into a
single repository in such a way that employees can make decisions and undertake
business analysis activities.
To disaggregate information throughout an organization into
a single repository in such a way that employees can make decisions and
undertake business analysis activities.
To aggregate information throughout an organization into
multiple repositories in such a way that employees can make decisions and
undertake business analysis activities.
Question 11 Extraction,
transformation, and loading is a process that extracts information from
internal databases, transforms the information using a common set of enterprise
definitions, and loads the information into an external database.
True
False
Question 12 A
relational database contains information in a series of two-dimensional tables.
How is data contained in a data warehouse and data mart?
Information
is multidimensional, meaning it contains layers of columns and rows.
Information is multidimensional, meaning it contains a
single layer data in a table format.
Information is two-dimensional, meaning it contains a single
layer data in a table format.
Information is two-dimensional, meaning it contains layers
of columns and rows.
Question 13 What is
data mining?
The
process of analyzing data to extract information not offered by the raw data
alone
The common term for the representation of multidimensional
information
A particular attribute of information
Uses a variety of techniques to find patterns and
relationships in large volumes of information and infer rules from them that
predict future behavior and guide decision making
Question 14 A
dimension is a particular attribute of information. Each layer in a data
warehouse or data mart represents information according to an additional
dimension. What is the common term for the representation of multidimensional
information?
Table
Block
Cube
All of the above
Question 15 Which
of the following is one of the principle BI enablers?
Technology, processes, and customer culture
Technology, people, and customer culture
Technology, processes, and corporate culture
Technology,
people, and corporate culture
Question 16 Which
of the following describes ETL?
A process that transforms information using a common set of
enterprise definitions
A process that loads information into a data warehouse
A process that extracts information from internal and
external databases
All of
the above
Question 17 A cube
is the common term for the representation of multidimensional information.
True
False
Question 18 Which
of the following is not one of the principal BI enablers?
Corporate
processes
Corporate culture
People
Technology
Question 19 All of
the following are reasons why operational systems are not appropriate for
business analysis, except:
Does not include information from other operational
applications
Operational information is mainly current
Operational
systems are integrated
Operational information frequently has quality issues
Question 20 Which
of the following statements is true?
The
more complete and accurate an organization wants to get its information, the
more it costs
The more accurate an organization wants to get its
information, the less it costs
The less accurate an organization wants to get its
information, the more it costs
The more complete an organization wants to get its
information, the less it costs
Question 21 A data
mart is a company that collects and sells external data for a data warehouse.
True
False
Question 22 A
dimension is a particular attribute of information.
True
False
Question 23 The
data warehouse is a location for all of a business's information.
True
False
Question 24 Which
of the following statements is true regarding customer information?
Customer information can exist in several operational
systems
Customer information in each operational system could change
Customer information in each operational system can be
different
All of
the above
Question 25 What
does the Data Warehousing Institute estimate that low-quality information costs
U.S. businesses annually?
$600
billion
$6 billion
$5 million
$6 trillion
Question 26 A data
warehouse is a _________ collection of information-gathered from many different
___________ databases-that supports business analysis activities and
decision-making tasks.
Logical,
operational
Physical, transactional
Physical, operational
Logical, transactional
Question 27 With
careful planning, 100% complete and accurate information is possible.
True
False
Question 28 Which
of the following occurs during data cleansing?
Clean inconsistent information
Clean incorrect information
Clean incomplete information
All of
the above
Question 29 What is
a dimension?
A particular relational database.
A particular single repository.
A
particular attribute of information.
A particular entity of information.
Question 30 Lands'
End created an organization wide data warehouse so all its employees could
access organizational information. Lands' End soon found out that there could
be "too much of a good thing." Many of its employees would not use
the data warehouse because it was simply too big, too complicated, and had too
much irrelevant information. Lands' End knew there was valuable information in
its data warehouse, and it had to find a way for its employees to easily access
the information. What was Lands' End solution?
Build a better, more efficient data warehouse
Build a data-driven website
Build a better, more efficient transactional database
Build a
data mart
Question 31 Match
the following terms with their definition.
1. Data
warehouse - A logical collection of information, gathered from many different
operational databases, that supports business analysis activities and
decision-making tasks
2. Data mining
- The process of analyzing data to extract information not offered by the raw
data alone
3. ETL- A
process that extracts information from internal and external databases,
transforms the information, and loads the information into a data warehouse
4. Business
intelligence - Refers to applications and technologies that are used to gather,
provide access to, and analyze data and information to support decision-making
efforts
5. Information
cleansing or scrubbing - A process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information
Plug-In B18 Business Intelligence
Question 1 Data
latency is the time from which data are made available to the time when
analysis is complete.
True
False
Question 2 Improving
the quality of business decisions has a direct impact on costs and revenue.
True
False
Question 3 Data
is a strategic asset for a business and if the asset is not used the business
is wasting resources.
True
False
Question 4 Quantifiable
benefits, indirectly quantifiable benefits, unpredictable benefits, and
intangible benefits are the four primary categories of BI benefits.
True
False
Question 5 The
three forms of BI include operational, tactical, and value-added.
True
False
Question 6 Which
of the following is the result of BI that the data have been defined in
business terms and calculations and algorithms are easily accessed for
comprehension?
Understandable
Easily manipulated
Reliable
Consistent
Question 7 What
types of BI decisions include forecasting claim amounts and medical coverage
costs, classifying the most important elements that affect medical coverage;
predicting which customers will buy new insurance policies?
Retail and sales BI decisions
Insurance
BI decisions
Banking BI decisions
Operations management BI decisions
Question 8 Which
of the following is the result of BI that implies that the data have been
documented as the certified or approved data for the enterprise?
Understandable
Consistent
Easily manipulated
Reliable
Question 9 What
is decision latency?
The time duration to make data ready for analysis and
loading the data into the database
The time from which data are made available to the time when
analysis is complete
The
time it takes a human to comprehend the analytic results and determine an
appropriate action
None of the above
Question 10 Which
form of BI uses the time frame of days to weeks to months?
Operational BI
Tactical
BI
Strategic BI
All of the above
Question 11 Which
of the following is a form of statistical analysis?
Forecasting
Market basket analysis
Cluster analysis
All of the above
Question 12 Which
of the following is not one of the parallels between challenges in business and
those of war?
Discerning patterns and meaning in the information
Responding to the resultant information
Collecting information
Using
tactical business intelligence
Question 13 What is
a technique used to divide an information set into mutually exclusive groups
such that the members of each group are as close together as possible to one
another and the different groups are as far apart as possible?
Intelligent agent
Association detection
Market basket analysis
Cluster
analysis
Question 14 What is
the primary problem most organizations face today concerning information?
Data poor, information rich
Data
rich, information poor
Business intelligence rich, information rich
Business intelligence poor, information rich
Question 15 What
reveals the degree to which variables are related and the nature and frequency
of these relationships in the information?
Intelligent agent
Market basket analysis
Cluster analysis
Association
detection
Question 16 Which
type of BI achieves long-term organizational goals?
Operational BI
Tactical BI
Strategic
BI
All of the above
Question 17 What
types of BI decisions include forecasting levels of bad loans and fraudulent
credit card use, credit card spending by new customers, and which kinds of
customers will best respond to new loan offers?
Operations management BI decisions
Insurance BI decisions
Retail and sales BI decisions
Banking
BI decisions
Question 18 Which
of the following is a business benefit of BI?
Single point of access to information for managers only
BI available to financial organizational departments only
Up-to-the
minute information for everyone
All of the above
Question 19 What are
forecasts?
Predictions
made on the basis of time-series information
Time-stamped information collected at a particular frequency
Reveals the degree to which variables are related
All of the above
Question 20 What do
organizations using BI ask to find the root causes to problems and provide
solutions?
What
When
Where
Why
Question 21 Which
of the following is the result of BI that it is no longer required to have a
PhD in statistics to get sophisticated analytics delivered to users'
fingertips?
Reliable
Consistent
Understandable
Easily
manipulated
Question 22 What is
analysis latency?
The time duration to make data ready for analysis and
loading the data into the database
The
time from which data are made available to the time when analysis is complete
The time it takes a human to comprehend the analytic results
and determine an appropriate action
None of the above
Question 23 Which
of the following represents market basket analysis?
Analyzes website information
Analyzes checkout scanner information
Detects customers' buying behavior
All of
the above
Question 24 Which
form of BI has managers and analysts as its primary users?
Operational
BI
Tactical BI
Strategic BI
All of the above
Question 25 What
types of BI decisions include predicting sales, determining correct inventory
levels and distribution schedules among outlets, and loss prevention?
Retail
and sales BI decisions
Operations management BI decisions
Banking BI decisions
Insurance BI decisions
Question 26 Which
type of BI benefits are the results of discoveries made by creative users?
Indirectly quantifiable benefits
Intangible benefits
Quantifiable benefits
Unpredictable
benefits
Question 27 What is
time-series information?
Analyzes checkout scanner information
Time-stamped
information collected at a particular frequency
Reveals the degree to which variables are related
All of the above
Question 28 Which
type of BI benefits includes improved communication throughout the enterprise,
improved job satisfaction of empowered users, and improved knowledge sharing?
Intangible
benefits
Indirectly quantifiable benefits
Unpredictable benefits
Quantifiable benefits
Question 29 Which
type of BI conducts short-term analysis to achieve strategic goals?
Operational BI
Tactical
BI
Strategic BI
All of the above
Question 30 Which
form of BI uses real-time metrics for its data?
Operational
BI
Tactical BI
Strategic BI
All of the above
Question 31 Which
of the following is the result of BI that the processes that deliver the data
to the business community are well documents and there are no surprises such as
missing or inaccurate data?
Understandable
Easily manipulated
Reliable
Consistent
Question 32 Which
form of BI uses months to years as its time frame?
Operational BI
Tactical BI
Strategic
BI
All of the above
Question 33 Which
type of BI benefits includes working time saved in producing reports and
selling information to suppliers?
Quantifiable
benefits
Indirectly quantifiable benefits
Unpredictable benefits
Intangible benefits
Question 34 Which
of the following is one of the four main categories of BI benefits?
Directly quantifiable benefits
Predictable benefits
Tangible benefits
Quantifiable
benefits
Question 35
What types of BI decisions include predicting machinery
failures and finding key factors that control optimization of manufacturing
capacity?
Operations
management BI decisions
Banking BI decisions
Retail and sales BI decisions
Insurance BI decisions
