MIS FINAL EXAM REVIEW

business analyst

A ________ is a person who is well versed in an organization's strategy and focuses on ensuring that business processes and information systems meet the organization's competitive strategies.

query

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should create a ________ to obtain the information that she wants.

loss of control over data location

Identify a characteristic that is a disadvantage of cloud-based hosting?

activities

In a business process, ________ are defined as collections of related tasks that receive inputs and produce outputs.

data warehouse

In large organizations, a group of people manage and run a(n) ________, which is a facility for managing an organization's BI data.

foreign key

In the following image, the VEND_CODE in the PRODUCT table represents a(n) __________ because it creates the logical connection between the two tables.

define system goals and scope

In the system definition phase of the systems development life cycle (SDLC), the first major task for an assembled project team is to ________.

strategic

The directors of a company meet to decide if they should start a new product line or not. This is an example of a(n) ________ decision.

defining the problem

The first and arguably the most important task for a problem-solving collaborative group is ___________.

trade-off

A ________ involves balancing three critical factors: requirements, cost, and time

business process

A ________ is a network of activities, repositories, roles, resources, and flows that interact to accomplish a business function.

data

A customer relationship management (CRM) system contains the names and phone numbers of customers. Such things stored in a CRM system are part of the ________ component.

data are duplicated in a database

A data integrity problem will occur only if ________.

systems thinking

A manager will essentially require ________ skills to clearly understand how the resources that his or her company uses are converted to desired outputs.

planning

A project manager defines the tasks that her team members have to perform and determines the schedule for carrying out each of the tasks. This project is in the ________ phase of project management.

cooperation

A student team, which is assigned a term project, meets and divides the work into sections and then team members work independently on their individual pieces. An hour before the project is due the team members meet again to assemble their independent pieces into a whole. Which of the following terms best describes this activity?

VPN

A(n) ________ uses the Internet to create the appearance of private, secure connections

create diseconomies of scale

According to Brooks' Law, adding more people to a late project will ________.

primary key

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________

increase

Automation moves work from people to machines. However, it can also _________________ the complexity of the system and require more time for change.

pooled

Cloud resources are ________ because many different organizations use the same physical hardware.

minimizes the risk of investing in technology that will soon become obsolete

Compared to in-house hosting, cloud-based hosting ________.

a single theme

Every table in a normalized database has ________.

form the project team

If a defined project is determined to be feasible in the systems development life cycle (SDLC), the next step is to _______

supervised data mining

In ________, data miners develop a model prior to the analysis and apply statistical techniques to data to estimate parameters of the model.

cluster analysis

In ________, statistical techniques can identify groups of entities that have similar characteristics

cross-selling

In marketing transactions, the fact that customers who buy product X also buy product Y creates a ________ opportunity. That is, "If they're buying X, sell them Y" or "If they're buying Y, sell them X."

deliverables

In systems development, documents, designs, prototypes, data models, database designs, and working data entry screens are examples of ________.

pilot

In the system implementation phase of the systems development life cycle (SDLC), with ________ installation, the organization implements the entire new system/business processes on a limited portion of the business.

Internet of Things

In this century, computing technology is now connected to virtually everything. This connectivity will continue to grow for many years. We commonly refer to this as the _______________________.

Change management

One of the most important things to consider regarding people when implementing a change to an IMS system or when deploying a new IMS system is?

attributes

Phone number, email address, first and last name, are all examples of ___________ because they describe the characteristics of an entity.

according to a schedule or as a result of an event or particular data condition

Push publishing delivers business intelligence ________

purchasing patterns

RFM analysis is used to analyze and rank customers according to their ________

Minicomputer

Smaller than a mainframe computer but larger than a PC, the _________________ was developed in the 1970s to give corporate departments and small companies direct access to computers.

critical path

The ________ is a sequence of activities that determine the earliest date by which a project can be completed.

CIO

The ________ must ensure that priorities consistent with the overall organizational strategy are developed, communicate them to the IS department and enforce them.

setting the ground rules for the project and team

The fundamental purpose of the starting phase of a project is ________.

elastic

The term ________ means that the computing resources leased can be increased or decreased dynamically in a short span of time and that organizations pay for just the resources that they use.

constructive criticism and feedback

The two key characteristics of collaboration are _______ and __________

learn basic computer skills

Users should not bother IS personnel for trivial reasons, so they have a responsibility to ________.

collaboratively

When working on your MIS 3100 class project, my expectations are that you and your group members work _________ with the goal of producing a high-quality deliverable.

computer hardware, software, data, procedures, and people

Which of the following accurately describes the five-component framework of information systems?

The management and use of information systems to help organizations achieve their goals and objectives

Which of the following best defines Management Information Systems (MIS)?

It involves high dependency on vendor

Which of the following characteristics is a disadvantage of cloud-based hosting?

virtual meetings

Which of the following choices would be used to facilitate synchronous communication between team members?

writing programs

Which of the following is NOT a responsibility of a systems analyst?

It serves as a user's gateway to the Internet.

Which of the following is a function of an ISP?

https

Which of the following protocols guarantees secure data transmission

data mining

Which of the following selections is not completed during data acquisition of the BI process?

developing friendships

Which of the following selections is not one of the four primary purposes of collaboration?

Data marts address the needs of a particular department or functional area of a business

Which of the following statements is true about data marts?

Analysts do not create a model or hypothesis before running the analysis.

Which of the following statements is true about unsupervised data mining?

accounting skills

Which of the following types of skills is most likely be outsourced to the lowest bidder?

Business intelligence

______ is defined as information containing patterns, relationships, and trends of various forms of data.

SQL

______ is the standard language for inserting, updating, and deleting data in a database.

Users

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

BigData

________ refers to data collections that are characterized by huge volume, rapid velocity, and great variety.

NoSQL

_________ is the term used to describe non-relational databases that support very high transaction rates processing relatively simple data structures.

organization's strategy

the process of creating a new application begins when the IS department aligns its priorities with the ________.