IS

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

High Quality Data

What is a major characteristic of a Transaction Processing System?

High level of accuracy is needed

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

Hits/visits/page view

A user establishes relationships between Access tables by ________________.

connecting primary keys to foreign keys in the relationship window

Which of the following is the most used ERP system?

SAP

Which of the following are sources of data?

TPS Systems & Social Media Data

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

Table, Query, Form

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

40% to 60%

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

=IF()

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

=VLOOKUP()

Vulnerability is:

A gap in our protection efforts

What is a Business Process?

A set of activities that accomplish a specific function

What is a Primary Key?

A value that identifies a unique row in a table

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

Actors & Resources

What kind of information system is a neural network?

Artificial intelligence system

Which of the following is recommended for continuous data?

Bar Charts & Line Charts

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

Baseline project plan

Who would most commonly use an Office Automation System?

Clerical Staff

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

Communicate the project status

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

Collaboration

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

Two key activities of collaboration are:

Communication and Iteration

_______ 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

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

Creates security technology for the organization

How do organizations solve the problems of information silos?

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

What is an information silo?

Data isolated in separate information systems

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

Data models

What is responsible for creating tables and defining their relationships?

Database Management System (DBMS)

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

EAI & ERP

What is EDI?

Electronic Data Interchange

Which one of the following best describes Web 2.0?

Encourages reader feedback

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

Entering the screen T_Code

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

Executive Information System

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

Explains an action

The amount data increases over time in a _____________ manner.

Exponential

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

Feasibility study

Which of the following is a risk of cybercrimes?

Financial losses

A system can be defined as:

Group of components interacting to achieve some purpose

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

Help desk

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

Inspect and Cleanse Data

What does "IoT" stand for?

Internet of Things

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

Labor

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

Laptop

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

Level two

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

Line Chart

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

Lost Update Problem

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

Management

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

Which of these is not a type of data?

Megadata

_____ is data that is used to describe data.

Metadata

What is the most commonly used Decision Support System?

Microsoft Excel

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

Normalization

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

Outbound Delivery

What category does Information Systems fit into?

People, Technology, Organization

An asset is _______.

People, property, and information

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

Petabyte

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

Pivot Tables

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

Reduce risk, Scalable & Enforce policies, produce consistent results

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

Retention Rates

Example of a continuous variable.

Revenue

Asset + Threat + Vulnerability =

Risk

Which is a part of IT Governance?

Risk Management

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

Sell the product

An example of a transaction in a business environment is:

Selling a product, Shipping a box, Hiring an employee

What is an example of a business facing process?

Strategic planning

Which is a goal of data visualization?

Support Decision making, Support graphical calculation, See data in context

What is the objective for utilizing visual representation of information?

Support decision making

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

Supports entire organization's activities with an integrated package

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

Synchronous

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

ERP system benefit(s) include _______.

The elimination of redundant processes & The elimination of redundant tasks

Which of the following are information types:

Transactional information & Analytical information

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

To track day to day business events.

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

Users are final judges as to the data in the database & Users should review the data models before developing the database

Application delivery and support ensure all the following EXCEPT:

Users receive correct data

Attacks exploit _________.

Vulnerabilities

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

Who are you creating this for? What type of data are you using?, Choose the correct scale. (So you do not mislead the audience)

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

Work Breakdown Structure

This is an example of a discrete variable.

Zip code

Post-project reviews will

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

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

post the outgoing payment

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

project scope statement

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

swimlane, Cross-Functional Flowchart