ISYS 363 Ch. 6

Question 1

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

Answer 1

business intelligence

Question 2

A key consideration related to business intelligence (BI) is that it focuses on ___________ data to aid in decision making.

past

redundant

future

aligned

predictive

Answer 2

past

Question 3

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.

Answer 3

customer comments posted on a social media site.

Question 4

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

Answer 4

continuous planning process

Question 5

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

Answer 5

database management system

Question 6

A(n) ______ is something you collect data about.

row

entity

table

record

column

Answer 6

entity

Question 7

A(n) _____________ is also known as an entity instance.

table

cell

record

attribute

column

Answer 7

record

Question 8

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.

Answer 8

RDBMS are not easily scalable in response to demand variations.

Question 9

The ________ database management system is capable of handling large volumes of unstructured data.

MySQL

NoSQL

file-based

client-based

RDBMS

Answer 9

NoSQL

Question 10

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

Answer 10

query

Question 11

If your data needs exceed traditional RDBMSs and requires NoSQL, _______________ is considered a popular option.

DB2

MySQL

Oracle

Hadoop

SQL Server

Answer 11

Hadoop

Question 12

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

Answer 12

data warehouse

Question 13

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.

Answer 13

Data marts are considerably more expensive to develop than data warehouses.

Question 14

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.

Answer 14

provide a summary of critical information on a regular schedule.

Question 15

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.

Answer 15

complex multidimensional data analyses.

Question 16

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.

Answer 16

allow data to be analyzed by multiple dimensions.

Question 17

________________ algorithms search for hidden patterns in large volumes of data in order to develop predictive models.

E-commerce

RDBMS

Data mining

OLTP

OLAP

Answer 17

Data mining

Question 18

The type of data mining that is used to identify items that are frequently purchased together is called _________________ discovery.

predictive

intersection

sequence

class

association

Answer 18

association

Question 19

Using a decision support system to determine market share is a(n) ____________ function.

production

marketing

human resources

finance

accounting

Answer 19

marketing

Question 20

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.

Answer 20

Provide a detailed picture of the current state of a business.

Question 21

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

Answer 21

what-if analysis

Question 22

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

Answer 22

expert

Question 23

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

Answer 23

tacit

Question 24

_______ typically provide(s) push reporting, exception reporting, and pull reporting.

OLAP

Intelligent agents

Digital dashboards

Web crawlers

Neural networks

Answer 24

Digital dashboards

Question 25

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.

Answer 25

Replicate an expert’s judgment.

Question 26

a repository containing data from multiple large databases and other sources that is suitable for direct querying, analysis, or processing

Answer 26

data warehouse

Question 27

a data warehouse that is limited in scope and customized for the decision support applications of a particular end-user group

Answer 27

data mart

Question 28

a display delivering summary information to managers and executives to provide warnings, action notices, and summaries of business conditions

Answer 28

digital dashboard

Question 29

a variety of database technologies enabling highly scalable databases that do not conform to RDBMS schemas

Answer 29

NoSQL: “Not only SQL”

Question 30

knowledge assets that reflect the processes and procedures located in employees’ minds

Answer 30

tacit knowledge assets

Question 31

a data mining technique used to find associations or correlations among sets of items

Answer 31

association discovery