information technology final test bank

To display a value associated with and located in a table of values in Excel, the cell formula could call the _________ function.

=VLOOKUP()

A BI tool provided by Excel that allows for aggregation and simple visualization of data is called ________________.

pivot tables

SAP presents the user with a menu system that can be navigated by ______________.

entering the screen T_Code

To answer a business questions like “How many customers do we have in each state?”, a user of Microsoft Access would create a(n) ___________?

all of the above

When using SAP, the last step in the procurement process is to:

post the outgoing payment

The Excel function that allows for conditional display of data within a cell is ________.

=IF()

Organizations use Microsoft Visio to model their organizational business processes by creating a __________ diagrams using the _______________ template.

swimlane, cross-functional flowchart

A user establishes relationships between Access tables by ________________.

connecting primary keys to foreign keys in the relationship window

When using SAP's sales processes, the warehouse manager uses the ________ screen in the SAP system to ship items to customers.

outbound delivery

A system can be defined as:

Group of components interacting to achieve some purpose

Application delivery and support ensure all the following EXCEPT:

users receive correct data

Which is a part of IT Governance?

risk management

Which of the following is not something done during application development?

sell the product

What is a common entry level position to the IT organization?

help desk

Which of the following is NOT one of the five components of the information system?

management

What category does Information Systems fit into?

all of the above

The amount data increases over time in a _____________ manner.

exponential

Which of the following are information types:

d. both a. and c.

Which of these is not a type of data?

megadata

Which of the following are sources of data?

d. both a. and c.

This type of data management asset is based around critical nouns of business, fairly static and generally fall into 4 categories: people, things, places and concepts

master data

Characteristics of _________ are accurate, timely, relevant, just sufficient, worth its cost, and secured.

high quality data

Which is a goal of data visualization?

all of the above

This is an example of a discrete variable.

zip code

Example of a continuous variable.

revenue

Which of the following is recommended for continuous data?

d. b and c

Which of the following is not a goal of data visualization?

inspect and cleanse data

Which of the following are important rules of thumb with regards to data visualization?

all of the above

Which graph would provide the best illustration of trends based on growth per year?

line chart

What is the objective for utilizing visual representation of information?

support decision making

Which of the following is not part of the Business Process?

explains an action

What is a Business Process?

a set of activities that accomplish a specific function

Which of the following is a component of a Business Process?

d. both a and b

What is an example of a business facing process?

strategic planning

The following symbol used to document a business process that indicates the beginning or ending of a process and links to other related processes.

terminator

Which of the following is the purpose of why organizations needs the business process

c. a and b are correct

Which level of process modeling shows end-to-end processes across the above operational areas

level two

What is the general function of a (Transaction Processing Systems) TPS?

to track day to day business events

What kind of information system is a neural network?

artificial intelligence system

Used by the highest level employees to review internal and external data to make big business decisions

executive information system

Who would most commonly use an Office Automation System?

clerical staff

What is a major characteristic of a Transaction Processing System?

high level of accuracy is needed

What is the most commonly used Decision Support System?

microsoft excel

What is EDI?

electronic data interchange

Which of the following is incorrect regarding Collaborative Systems?

collaborative systems can only work when all group members are logged in at the same time

An example of a transaction in a business environment is:

all of the above

Which of the following best describes an Organizational type of classification?

supports entire organization’s activities with an integrated package

what is an information silo?

data isolated in separate information systems

which of the following is the most expensive part of ERP?

labor

Which of the following is the most used ERP system?

SAP

Which of the following is not a problem posed by information silos?

retention rates

How do organizations solve the problems of information silos?

data integration into a single database and revise applications to use that database

ERP system benefit(s) include _______.

c. both a and b

Which of the following is a possible solution for information silos?

d. both a and b

________ is a dynamic process where a group of people work together to achieve common objectives.

collaboration

Which type of communication requires all team members to be available to collaborate at the same time?

synchronous

Which one of the following best describes Web 2.0?

encourages reader feedback

Big Data refers to data sets that are at least a ______ or larger in size?

petabyte

Which of the following devices is NOT considered to be an example of an Internet of Things (IoT) device?

laptop

Two key activities of collaboration are:

communication and iteration

What does “IoT” stand for?

internet of things

What is the most used social media metric used by companies?

hits/visits/page view

The process of converting a poorly structured table into two or more well-structured tables is called

normalization

_____ is data that is used to describe data.

metadata

Users create the requirements for data entered into the database. Developers then convert those requirements into ______?

data models

What is a Primary Key?

a value that identifies a unique row in a rable

What is the user’s role in development of a database?

c. a and b

What is responsible for creating tables and defining their relationships?

database management system (DBMS)

Which of the following can be a problem with multi-user databases?

lost update problem

A study that determines whether a requested system makes economic and operational sense for an organization is a:

feasibility study

Which of the following contains the best estimate of a project’s scope, benefit, cost, risks, and resource requirements?

baseline project plan

Studies have found that  ___% to ___ % of all IT projects fail at one stage or another.

40% to 60%

A _________ outlines at a high level all work required to complete the project.

project scope statement

Post-project reviews will

ensure that future projects can avoid any issues that may have occurred during the execution of the just completed project

The project closedown phase includes all of the following actions except?

communicate the project status

What structure breakdown divides the project into manageable and logically ordered tasks and subtasks?

work breakdown structure

Attacks exploit _________.

vulnerabilities

An asset is _______.

people, property, and information

Which of the following is a risk of cybercrimes?

financial losses

Vulnerability is:

a gap in our protection efforts

Asset + Threat + Vulnerability =

risk

Which of the following is not one of the four functions of information security in an organization?

creates security technology for the organization

_______ is defined as an action, process, device, or system that can prevent, or mitigate the effects of, threats to a computer, server or network.

countermeasure