1)

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

2)

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

production

marketing

human resources

finance

accounting

3)

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

4)

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.

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

6)

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.

7)

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

8)

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

DB2

MySQL

Oracle

Hadoop

SQL Server

9)

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

predictive

intersection

sequence

class

association

10)

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

11)

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.

12)

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

table

cell

record

attribute

column

13)

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

14)

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

15)

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

16)

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

row

entity

table

record

column

17)

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.

18)

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

OLAP

Intelligent agents

Digital dashboards

Web crawlers

Neural networks

19)

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

MySQL

NoSQL

file-based

client-based

RDBMS

20)

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.

21)

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

E-commerce

RDBMS

Data mining

OLTP

OLAP

22)

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.

23)

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

24)

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.

25)

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

past

redundant

future

aligned

predictive