ISYS 363 Ch. 6 Flashcards
To stay ahead of the competition, organizations have turned to _____________, using information systems to gather and analyze data and information from internal and external sources in order to make better business decisions.
business applications
transaction processing
Web sites
business intelligence
e-commerce
business intelligence
A key consideration related to business intelligence (BI) is that it focuses on ___________ data to aid in decision making.
past
redundant
future
aligned
predictive
past
An example of a type of unstructured data is:
transaction data.
sensor readings.
customer comments posted on a social media site.
clickstream data from a website.
spreadsheets.
customer comments posted on a social media site.
Today, organizations require a(n) _________ in order to monitor and analyze data and business processes, adjust business processes, and update organizational plans.
separate company
budget plan
random planning cycle
annual strategic plan
continuous planning process
continuous planning process
A ______ is a software application with which you create, store, organize, and retrieve data from a single database or several databases.
transaction
file
network
database management system
application program
database management system
A(n) ______ is something you collect data about.
row
entity
table
record
column
entity
A(n) _____________ is also known as an entity instance.
table
cell
record
attribute
column
record
Which of the following is a limitation of relational database management systems (RDBMS)?
RDBMS data are stored in tables.
RDBMS are not easily scalable in response to demand variations.
RDBMS allows for inserting data.
RDBMS support business processes.
RDBMS allow for different data types.
RDBMS are not easily scalable in response to demand variations.
The ________ database management system is capable of handling large volumes of unstructured data.
MySQL
NoSQL
file-based
client-based
RDBMS
NoSQL
A key function of RDMBS is the ____________, which enables users to retrieve data from the database to answer questions.
data dictionary
question
table
query
form
query
If your data needs exceed traditional RDBMSs and requires NoSQL, _______________ is considered a popular option.
DB2
MySQL
Oracle
Hadoop
SQL Server
Hadoop
The purpose of a(n) ________ is to store and distribute valuable data from an organization’s internal information systems and external sources for analysis and querying.
data dictionary
operational system
transaction processing system
data warehouse
master file
data warehouse
Which of the following statements about data marts is NOT true?
Data marts are considerably more expensive to develop than data warehouses.
Data marts can be targeted to a specific group of end users.
Data marts are often found in small and medium-sized businesses.
A data mart is a smaller-scope data warehouse.
Data marts can be implemented on simpler and less expensive hardware compared to data warehouses.
Data marts are considerably more expensive to develop than data warehouses.
The purpose of a key indicator report is to:
provide answers to unplanned questions.
provide access to greater levels of detail.
provide routine information at predefined intervals.
provide a summary of critical information on a regular schedule.
highlight situations that fall outside the expected normal range of values.
provide a summary of critical information on a regular schedule.
The purpose of online analytical processing (OLAP) is to provide:
expert decision making.
complex multidimensional data analyses.
predictive forecasts.
simple data summaries.
rapid posting of transaction data.
complex multidimensional data analyses.
The purpose of an OLAP cube is to:
allow data to be analyzed by multiple dimensions.
record a sales transaction.
facilitate e-commerce.
analyze an expert’s judgment.
allow data to be analyzed on a single dimension.
allow data to be analyzed by multiple dimensions.
________________ algorithms search for hidden patterns in large volumes of data in order to develop predictive models.
E-commerce
RDBMS
Data mining
OLTP
OLAP
Data mining
The type of data mining that is used to identify items that are frequently purchased together is called _________________ discovery.
predictive
intersection
sequence
class
association
association
Using a decision support system to determine market share is a(n) ____________ function.
production
marketing
human resources
finance
accounting
marketing
Which of the following is NOT a key purpose of business analytics?
Understand the data.
Predict business outcomes.
Build explanatory models.
Provide a detailed picture of the current state of a business.
Identify trends.
Provide a detailed picture of the current state of a business.
A common feature of a decision support system (DSS) is to perform _______ to examine alternative problem solutions.
correlation analysis
association discovery
what-if analysis
competitive intelligence
Web content mining
what-if analysis
A(n) ______ system uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.
OLAP
expert
competitive intelligence
data mining
decision support
expert
A key challenge of knowledge management systems is to identify and manage ______ knowledge assets and make them available to organization members.
explicit
private
tacit
textual
archival
tacit
_______ typically provide(s) push reporting, exception reporting, and pull reporting.
OLAP
Intelligent agents
Digital dashboards
Web crawlers
Neural networks
Digital dashboards
Which of the following is NOT a common purpose of a geographic information system?
Locate target customers.
Perform competitor analysis.
Identify optimal product mixes at specific locations.
Replicate an expert’s judgment.
Find optimal site locations.
Replicate an expert’s judgment.
a repository containing data from multiple large databases and other sources that is suitable for direct querying, analysis, or processing
data warehouse
a data warehouse that is limited in scope and customized for the decision support applications of a particular end-user group
data mart
a display delivering summary information to managers and executives to provide warnings, action notices, and summaries of business conditions
digital dashboard
a variety of database technologies enabling highly scalable databases that do not conform to RDBMS schemas
NoSQL: “Not only SQL”
knowledge assets that reflect the processes and procedures located in employees’ minds
tacit knowledge assets
a data mining technique used to find associations or correlations among sets of items
association discovery