ISTM 209: CHAPTERS 7-10 Final Exam
and All Correct Answers Graded A+
2025-2026 Updated.
reasons business analysis is difficult from operational databases - Answer
repository - Answer a central location in which data is stored and managed
data warehouse - Answer a logical collection of information - gathered from many different
operational databases - that supports business analysis activities and decision-making tasks
the data warehouse enables business users to be more effective in the following ways: - Answer
- developing customer profiles
- identifying new product opportunities
- improving business operations
- identifying financial issues
- analyzing trends
- understanding competitors
- understanding product performance
data warehouse components - Answer data mart, information cleansing, business
intelligence
data aggregation - Answer the collection of data from various sources for the purpose of
data processing
extraction, transformation, and loading (ETL) - Answer a process that extracts information
from internal and external databases, transforms the information using a common set of
enterprise definitions, and loads the information into a data warehouse
data mart - Answer contains a subset of data warehouse information
model of a typical data warehouse - Answer
dirty data - Answer erroneous or flawed data
, dirty data problems - Answer
information cleansing or scrubbing - Answer a process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information
contact information in information systems - Answer
standardizing customer name from operational systems - Answer
information cleansing activities - Answer
data quality audits - Answer determine the accuracy and completeness of its data
accurate and complete information - Answer
data point - Answer an individual item on a graph or a chart
data broker - Answer a business that collects personal information about consumers and
sells that information to other organizations
data lake - Answer a storage repository that holds a vast amount of raw data in its original
format until the business needs it
source data - Answer identifies the primary location where data is collected
data set - Answer an organized collection of data
comparative analysis - Answer can compare two or more data sets to identify patterns and
trends
competitive monitoring - Answer when 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
how can BI answer tough customer questions - Answer
and All Correct Answers Graded A+
2025-2026 Updated.
reasons business analysis is difficult from operational databases - Answer
repository - Answer a central location in which data is stored and managed
data warehouse - Answer a logical collection of information - gathered from many different
operational databases - that supports business analysis activities and decision-making tasks
the data warehouse enables business users to be more effective in the following ways: - Answer
- developing customer profiles
- identifying new product opportunities
- improving business operations
- identifying financial issues
- analyzing trends
- understanding competitors
- understanding product performance
data warehouse components - Answer data mart, information cleansing, business
intelligence
data aggregation - Answer the collection of data from various sources for the purpose of
data processing
extraction, transformation, and loading (ETL) - Answer a process that extracts information
from internal and external databases, transforms the information using a common set of
enterprise definitions, and loads the information into a data warehouse
data mart - Answer contains a subset of data warehouse information
model of a typical data warehouse - Answer
dirty data - Answer erroneous or flawed data
, dirty data problems - Answer
information cleansing or scrubbing - Answer a process that weeds out and fixes or discards
inconsistent, incorrect, or incomplete information
contact information in information systems - Answer
standardizing customer name from operational systems - Answer
information cleansing activities - Answer
data quality audits - Answer determine the accuracy and completeness of its data
accurate and complete information - Answer
data point - Answer an individual item on a graph or a chart
data broker - Answer a business that collects personal information about consumers and
sells that information to other organizations
data lake - Answer a storage repository that holds a vast amount of raw data in its original
format until the business needs it
source data - Answer identifies the primary location where data is collected
data set - Answer an organized collection of data
comparative analysis - Answer can compare two or more data sets to identify patterns and
trends
competitive monitoring - Answer when 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
how can BI answer tough customer questions - Answer
