Chapter 6 - Business Intelligence A+
Q&As 2024
Business Intelligence - ANS-The use of IS to gather and analyze information from both
external and internal sources to make better decisions, and the data derived from these
processes (it is the number one necessities according to CIOs, key players include
independent pure play analytic companies such as SAS and MicroStrategy along with
larger integrated companies such as IBM, SAP, Oracle, and Microsoft)
Continuous planning process - ANS-A strategic business planning process involving
continuous monitoring and adjusting of business processes to enable rapid reaction to
changing business conditions (Monitor → Analyze →Manage → Plan)
Big Data Movement - ANS-Collecting, analyzing, and using internal and external data to
gain and sustain competitive advantage; characterized as being of high volume, variety,
and velocity; there is structured data (ex. transaction data), semi-structured data (ex.
clickstreams/sensors) and unstructured data (ex. audio/video)
Entity - ANS-Something data are collected about, such as people or classes
Tables - ANS-A collection of related records in a database where each row is a record
and each column is an attribute (with unique identifiers such as numbers)
Record - ANS-A collection of related attributes about a single entity (row)
Attribute - ANS-One piece of information about an entity in a database (column)
RDBMS - ANS-A database management system based on the relational model (may
not be able to handle Big Data)
NoSQL - ANS-Highly-scalable databases that do not confirm to RDBMS schemas (offer
much more scalable models with high flexibility)
Data model - ANS-A map or diagram that represents the entities of a database and their
relationships (what data will be captured and how it will be represented)
Data type - ANS-The type of an attribute in a database (helps organize and sort the
, data)
Data dictionary - ANS-A document prepared by database designers to describe the
characteristics of all items in a database (attribute, type, values, business rules)
Business rules - ANS-Policies by which a business runs
Structure Query Language (SQL) - ANS-The most common language used to interface
with databases for non-technical users
Operational systems - ANS-The systems that are used to interact with customers and
run a business in real time; the data is a current representation of the state of the
business; its users are online customers and sales administrators; it performs using
narrow and simple updates and queries
Online transaction processing (OLTP) - ANS-Immediate automatic responses to the
request from multiple concurrent transactions of customers
Informational systems - ANS-A system designed to support decision-making based on
stable point-in-time or historical data; its primary users are managers, business
analysts, and customers; it's easy to access and use and includes broad and complex
queries and analyses
Master data management - ANS-Consolidating master data (most important data in
business operations) so as to facilitate arriving at a single version of the truth
Data warehouses - ANS-A repository containing data from multiple large databases and
other sources that is suitable for direct querying, analysis, or processing
Data mart - ANS-A data warehouse that is limited in scope and customized for the
decision support applications of a particular end-user group; can be deployed on less
powerful hardware (only around 10 gigabytes)
Scheduled Reports - ANS-A report produced at predefined intervals to support the
routine informational needs of managerial-level decision making
Drill-down Reports - ANS-A report that provides details behind the summary values on
key-indicator or exception report
Exception Report - ANS-A report providing users with information about situations
Q&As 2024
Business Intelligence - ANS-The use of IS to gather and analyze information from both
external and internal sources to make better decisions, and the data derived from these
processes (it is the number one necessities according to CIOs, key players include
independent pure play analytic companies such as SAS and MicroStrategy along with
larger integrated companies such as IBM, SAP, Oracle, and Microsoft)
Continuous planning process - ANS-A strategic business planning process involving
continuous monitoring and adjusting of business processes to enable rapid reaction to
changing business conditions (Monitor → Analyze →Manage → Plan)
Big Data Movement - ANS-Collecting, analyzing, and using internal and external data to
gain and sustain competitive advantage; characterized as being of high volume, variety,
and velocity; there is structured data (ex. transaction data), semi-structured data (ex.
clickstreams/sensors) and unstructured data (ex. audio/video)
Entity - ANS-Something data are collected about, such as people or classes
Tables - ANS-A collection of related records in a database where each row is a record
and each column is an attribute (with unique identifiers such as numbers)
Record - ANS-A collection of related attributes about a single entity (row)
Attribute - ANS-One piece of information about an entity in a database (column)
RDBMS - ANS-A database management system based on the relational model (may
not be able to handle Big Data)
NoSQL - ANS-Highly-scalable databases that do not confirm to RDBMS schemas (offer
much more scalable models with high flexibility)
Data model - ANS-A map or diagram that represents the entities of a database and their
relationships (what data will be captured and how it will be represented)
Data type - ANS-The type of an attribute in a database (helps organize and sort the
, data)
Data dictionary - ANS-A document prepared by database designers to describe the
characteristics of all items in a database (attribute, type, values, business rules)
Business rules - ANS-Policies by which a business runs
Structure Query Language (SQL) - ANS-The most common language used to interface
with databases for non-technical users
Operational systems - ANS-The systems that are used to interact with customers and
run a business in real time; the data is a current representation of the state of the
business; its users are online customers and sales administrators; it performs using
narrow and simple updates and queries
Online transaction processing (OLTP) - ANS-Immediate automatic responses to the
request from multiple concurrent transactions of customers
Informational systems - ANS-A system designed to support decision-making based on
stable point-in-time or historical data; its primary users are managers, business
analysts, and customers; it's easy to access and use and includes broad and complex
queries and analyses
Master data management - ANS-Consolidating master data (most important data in
business operations) so as to facilitate arriving at a single version of the truth
Data warehouses - ANS-A repository containing data from multiple large databases and
other sources that is suitable for direct querying, analysis, or processing
Data mart - ANS-A data warehouse that is limited in scope and customized for the
decision support applications of a particular end-user group; can be deployed on less
powerful hardware (only around 10 gigabytes)
Scheduled Reports - ANS-A report produced at predefined intervals to support the
routine informational needs of managerial-level decision making
Drill-down Reports - ANS-A report that provides details behind the summary values on
key-indicator or exception report
Exception Report - ANS-A report providing users with information about situations
