a data warehouse is a ____ collection of information, gathered from many different ____ databases, that supports business analysis activities and decision-making tasks
question
operational systems are integrated
answer
which of the following is incorrect in terms of data warehousing and business intelligence
question
OLAP and analytical processing
answer
what do data warehouses support
question
combine strategic information
answer
the primary purpose of a data warehouse is to ____
question
standardizing information
answer
gender can be referred to in many ways in a data warehouse; ensuring gender is referenced the same way is an example of ____
question
all of these
answer
why were data warehouses created: numbers and types of operational databases increased as businesses grew; many companies had information scattered across multiple systems with different formulas; completing reporting requests from numerous operational systems took days or weeks
question
it is process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
answer
what is extraction, transformation, and loading
question
competitor and industry information, mailing lists, and stock market analysis
answer
which of the following are examples of external databases in the data warehouse model
question
competitor information
answer
which of the following is an example of an external database in the data warehouse model
question
all of these
answer
which of the following describes ETL: a process that extracts information from internal and external databases; a process that transforms information using a common set of enterprise definitions; a process that loads information into a data warehoues
question
all of these
answer
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
question
all of these
answer
which of the following occurs during data cleansing: clean missing records; clean redundant records; clean inaccurate data
question
clean redundant customer data
answer
which of the following occurs during data cleansing
question
the more complete and accurate an organization wants its information to be, the more it costs
answer
which of the following statements is true
question
marketing sales, inventory, and billing
answer
within the beginning stage of the data warehouse models process, which of the following are included in the internal databases
question
data marts
answer
what is the ultimate outcome of a data warehouse
question
data mart
answer
which of the following contains a subset of data warehouse information
question
data warehouses have a more organization wide focus, data marts have functional focus
answer
what are the primary differences between a data warehouses and a data mart
question
cube
answer
which of the following is the common term for the representation of multidimensional information
question
information scrapping
answer
what is another term for information cleansing
question
data quality audit
answer
what determines the accuracy and completeness of organizational data
question
identifies missing records or attributes
answer
which of the following is not an information cleansing activity
question
dirty data
answer
what is erroneous or flawed data
question
all of these
answer
which of the following is a problem associated with dirty data: duplicate data; incorrect data; violates business rules
question
duplicate data
answer
which of the following is a problem associated with dirty data
question
all of these
answer
which of the following is a problem associated with dirty data: inaccurate data; misleading data; non-formatted data
question
all of these
answer
which of the following is a problem associated with dirty data: inaccurate data; nonintegrated data; violates business rules
question
violates business rules
answer
which of the following is a problem associated with dirty data
question
non-formatted data
answer
which of the following is a problem associated with dirty data
question
misleading data
answer
which of the following is a problem associated with dirty data
question
all of these
answer
business analysis is difficult from operational databases; which of the following is a reason why: every department has its own method for recording data; data standards do not apply across departments; the data if available, were often incorrect or incomplete
question
effective direct data access
answer
business analysis is difficult from operational databases; which of the following is not a reason why
question
specific data
answer
which of the following is not a dirty data problem
question
McAffee
answer
companies can choose information cleansing software from several vendors; which of the following is not a vendor mentioned in your text
question
dirty data
answer
what is erroneous or flawed data
question
data rich, information poor
answer
what is it called when a manager has too much data and information to make a decision
question
all of these
answer
which of the following questions can be answered using business intelligence: where has the business been? where is the business now? where is the business going?
question
business intelligence
answer
what is information that people use to support their decision-making efforts
question
analyze popular vacation locations with current flight listings
answer
how would the airline industry use business intelligence
question
understand customer credit card usage and nonpayment rates
answer
how would the banking industry use business intelligence
question
compare the demographics of patients with critical illnesses
answer
how would the health care industry use business intelligence
question
predict claim amounts and medical coverage costs
answer
how would the insurance industry use business intelligence
question
track crime patterns, locations, and criminal behavior
answer
how would the law enforcement industry use business intelligence
question
analyze customer demographics
answer
how would the marketing industry use business intelligence
question
predict sales, inventory levels, and distribution
answer
how would the retail industry use business intelligence
question
predict hardware failures
answer
how would the technology industry use business intelligence
question
data set
answer
what is an organized collection of data
question
data map
answer
what is a technique for establishing a match, or balance, between the source data and the target data warehouse
question
data point
answer
what is an individual item on a graph or a chart
question
repository
answer
what is a central location in which data is stored and managed
question
data aggregation
answer
what is a collection of data from various sources for the purpose of data processing
question
data broker
answer
what is a business that collects personal information about consumers and sells that information to other organizations
question
comparative analysis
answer
____ can compare two or more data sets to identify patterns and trends
question
competitive monitoring
answer
BI can help managers with ___________, where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.
question
data-driven decision management
answer
which of the following is an approach to business governance that values decisions that can be backed up with verifiable data
question
source data
answer
which of the following identifies the primary location where data is collected
question
data lake
answer
what is a storage repository that holds a vast amount of raw data in its original format until the business needs it
question
a business that collects personal information about consumers and sells that information to other organizations
answer
what is a data broker
question
a storage repository that holds a vast amount of raw data in its original format until the business needs it
answer
what is a data lake
question
a technique for establishing a match, or balance, between the source data and the target data warehouse
answer
what is a data map
question
an approach to business governance that values decisions that can be backed up with verifiable data
answer
what is data-driven decision management
question
identifies the primary location where data is collected
answer
what is source data
question
an individual item on a graph or chart
answer
what is a data point
question
all of these are examples of how industries use business intelligence
answer
Business intelligence can provide managers with the ability to make better decisions. Which of the following is not an example of how different industries use business intelligence? Analyze popular vacation locations with current flight listings; Understand customer credit card usage and nonpayment rates; Compare the demographics of patients with critical illnesses
question
identify the primary locations where data is collected
answer
business intelligence can provide managers with the ability to make better decisions; which of the following is not an example of how different industries use business intelligence
question
a historical perspective offers important variables for determining trends and patterns
answer
Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business has been?
question
looking at the current business situation allows managers to take effective action to solve issues before they grow out of control
answer
Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?
question
setting strategic direction is critical for planning and creating solid business strategies
answer
Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is going?
question
4% higher, 6% higher
answer
Data-driven decision management is usually undertaken as a way to gain a competitive advantage. A study from the MIT Center for Digital Business found that organizations driven most by data-based decision making had _________ productivity rates and ____________ profits.
question
when sharing data, the data matches with the data warehouse and users get the data they need
answer
Business analysis is difficult from operational databases. Which of the following is not a reason why?
question
the data is standardized
answer
Business analysis is difficult from operational databases. Which of the following is not a reason why?
question
all of these
answer
What does standardization of data elements accomplish? greater accuracy; completeness and consistency; increase in the quality of information
question
all of these
answer
in which ways does a data warehouse enable business users to be more effective: analyzing trends; identifying financial issues; understanding competitors
question
transactional
answer
businesses collect a tremendous amount of ____ information as part of their routine operations
question
dashboard
answer
Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
