BCOR 2205 Final Review QUESTIONS AND
CORRECT ANSWERS (VERIFIED AND WELL
DETAILED ANSWERS) LATEST UPDATE 2024/2025
what is analytical data? - ✔✔encomapsses all organizational data, its main purpose is to
support managerial tasks
what is transactional data? - ✔✔all the data contained within a business process or unit of
work
how do you calculate accuracy in a confusion matrix - ✔✔accuracy = TP + TN / All Cases
how do you calculate the true positive rate - ✔✔true positive rate = TP / TP + FN
how do you calculate the true negative rate - ✔✔True negative rate = TN / TN + FP
what is prescriptive data? - ✔✔prescriptive data finds a solution to an issue in addition to
finding the problem
what is predictive data - ✔✔predicts what will happen in the future based on the data
what does ETL mean? - ✔✔Extract, Transform, Load
rank Wan, Lan, and Man in order largest to smalles - ✔✔Wan, Man, Lan
What is a database? - ✔✔An organized collection of related data
, What is a data warehouse? - ✔✔a large store of data accumulated from a wide range of
sources within a company and used to guide management decisions.
What is a data mart? - ✔✔A subset of a data warehouse, intended for a specific department
or set of users in the organization
What is a data lake? - ✔✔Unstructured data storage technology for Big Data
What is a DSL modem? - ✔✔DSL (digital subscriber line) modems are device that uses the
same telephone lines used for analog telephones to provide internet connectivity.
What does TCP mean? - ✔✔Transmission Control Protocol
- verifies that all packets arrive to the destination
what is the process of data to knowledge - ✔✔data -> information -> business intelligence ->
knowledge
what is data - ✔✔raw facts that describe the characteristics of an event or object
What is information? - ✔✔Data converted into a meaningful and useful context
what is business intelligence - ✔✔Information collected from multiple sources that analyzes
patterns, trends, and relationships for strategic decision making
What is knowledge? - ✔✔Skills, experience, and expertise coupled with information and
intelligence that create a person's intellectual resources
*ex. not firing someone under performing because you know they are having family trouble*
CORRECT ANSWERS (VERIFIED AND WELL
DETAILED ANSWERS) LATEST UPDATE 2024/2025
what is analytical data? - ✔✔encomapsses all organizational data, its main purpose is to
support managerial tasks
what is transactional data? - ✔✔all the data contained within a business process or unit of
work
how do you calculate accuracy in a confusion matrix - ✔✔accuracy = TP + TN / All Cases
how do you calculate the true positive rate - ✔✔true positive rate = TP / TP + FN
how do you calculate the true negative rate - ✔✔True negative rate = TN / TN + FP
what is prescriptive data? - ✔✔prescriptive data finds a solution to an issue in addition to
finding the problem
what is predictive data - ✔✔predicts what will happen in the future based on the data
what does ETL mean? - ✔✔Extract, Transform, Load
rank Wan, Lan, and Man in order largest to smalles - ✔✔Wan, Man, Lan
What is a database? - ✔✔An organized collection of related data
, What is a data warehouse? - ✔✔a large store of data accumulated from a wide range of
sources within a company and used to guide management decisions.
What is a data mart? - ✔✔A subset of a data warehouse, intended for a specific department
or set of users in the organization
What is a data lake? - ✔✔Unstructured data storage technology for Big Data
What is a DSL modem? - ✔✔DSL (digital subscriber line) modems are device that uses the
same telephone lines used for analog telephones to provide internet connectivity.
What does TCP mean? - ✔✔Transmission Control Protocol
- verifies that all packets arrive to the destination
what is the process of data to knowledge - ✔✔data -> information -> business intelligence ->
knowledge
what is data - ✔✔raw facts that describe the characteristics of an event or object
What is information? - ✔✔Data converted into a meaningful and useful context
what is business intelligence - ✔✔Information collected from multiple sources that analyzes
patterns, trends, and relationships for strategic decision making
What is knowledge? - ✔✔Skills, experience, and expertise coupled with information and
intelligence that create a person's intellectual resources
*ex. not firing someone under performing because you know they are having family trouble*
