information systems exam 1

What is the goal of the modeling step of business process management?

Provide recommendations on handling labor and supply imbalances.

What occurs in the process execution step of business process management?

The business process execution language engine is run.

Under what type of system are employees encouraged to halt the manufacturing process in the event of a manufacturing error or safety risk?

lean manufact system

Manufacturing practices that emphasize developing efficient and smooth supply lines and minimizing excess inventory, delays, and waste are

lean techniques

What is a main component of the belief action outcome framework (BAO) that organizations provide to address the economic, environmental, and social impacts that result from their day-to-day operations?

sustainability reports

A common SQL term used in queries is FROM. FROM allows the user to choose the _____ of the database in which the query is located.

table

When creating a relationship in a relational database management system (DBMS), which object is used?

table

What is legendary GE CEO Jack Welch quoted as saying about competition?

"If you don't have a competitive advantage, don't compete."

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ______ data.

3rd party

Which of the following is an example of a process that uses Six Sigma techniques? More than one answer may be selected.

A clothing manufacturer only orders from supply partners who can meet their specified delivery windows. A food manufacturer that sells canned goods has a manufacturing process in place that will not factory seal and label cans until the desired weight has been confirmed to be within .01 oz of the desired weight.

Which of the following scenarios is an example allocating resources to solve a problem? More than one answer may be selected.

A dad decides to set aside an hour every night to help his son with math. A corporation decides to have all of its workers go through training so they know how to use new machinery.

Which of the following is an example of a primary function of human resource information system? More than one answer may be correct.

A small company selects employees who should be considered for promotion by determining which employees have received the top 10% of performance evaluation scores over a three-year period. An independent bookstore wants to open a new store in a neighboring city and needs to determine how many employees it should hire based on the characteristics and square footage of the new store. A large corporation is switching to an open floor plan and needs to determine where each employee will sit.

What is conducted in the process design step of business process management?

Activities are examined and divided into their individual components.

What is conducted in the process modeling step of business process management?

Analysts use flowcharts and other tools to depict workflow.

Which of the following is an example of an advantage that a modern inventory management system provides? More than one answer may be selected.

Automatic reordering occurs when inventory levels dip below a pre-established threshold. Production is scaled up or scaled down depending on the pace of orders received and the amount of inventory currently available. Competing products are quickly developed based on products that have shown initial success.

In the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the _____ table.

CUSTOMERS

When working in Tableau, users can assume which three roles?

Creators Explorers Builders Viewers

Which of the following statements best defines the purpose of data analytics?

Data analytics helps increase organizational performance by drawing meaning from large amounts of data.

What typically happens during Step 3 of business process management just before the execution process is fully automated?

Decision makers compare engine output to previous business activity.

What was the driving principle behind McGregor's Theory Y?

Employees are capable of working without constant supervision.

Because many business executives desire to create a data-driven decision making culture, which three of the following are competencies organizations invest in to support DDDM?

English literature expertise data proficiency agility in analytics and data analysis building a data-driven community

Which of these reports are commonly provided by Management Information Systems (MIS) to assist in making structured decisions? More than one answer may be correct.

Exception reports, production reports, and forecasting reports are provided by MIS to support structured decision making.

Corporate-level managers/executives are responsible for making decisions that impact profitability and the short-term and long-term success of an organization. To get the information they need, managers rely on output provided from

Executive Support Systems (ESS).

Common database field names for a Members table would include which fields?

FirstName LastName CellPhone ShortText

What is the goal of the process design step of business process management (BPM)?

Identify redundancies and inefficiencies in existing processes.

A company's annual sales conference has been cancelled, but the sales force still needs to receive new product information as soon as possible. An international firm is looking to hire the best candidates worldwide. A consulting firm must conduct remote training. Which of these statements explain what videoconferencing can uniquely provide in these situations?

In addition to "meeting" others through video, documents can be shown, screens shared, and nonverbal messages can be conveyed.

Which three of the following statements about management filters are true?

Included in many software applications, management filters may be predefined by the organization to eliminate time-consuming data searches. They allow managers to target the specific information needed for decision making.

Which statements about the analytical hierarchy process (AHP) model are true? Select all the correct answer options. Check All That Apply

It is a multi-criteria programming model that uses an analytical hierarchy process for decision making. It allows for many variables or conditions to be considered and prioritized, resulting in the selection of the best alternatives or projects. It analyzes intricate situations and scenarios by deconstructing the problem into a visible hierarchy that can be analyzed through comparison.

From the following list, select all the ways in which management information systems (MIS) have changed the management of organizations.

Managers (and employees) can communicate different types of information in a greater variety of ways. Managers can have more information and data about the organization to help them make smarter decisions. Managers across departments have replaced the information technology (IT) department in most organizations. Managers can trust that employees have read the workplace policies and understand their role in the organization.

What occurs during the process optimization step of business process management?

Managers adapt (modify) the process to enhance process performance.

Which businesses are currently considered direct competitors? More than one answer may be correct.

McDonald's and Burger King Aquafina and Dasani McDonald's and DiGiorno Wendy's and Taco Bell

Which of the following is a popular Microsoft data analytics program that offers business intelligence as well as data visualization?

POWER BI

Using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the ______ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results.

SELECT

In a data warehouse, data is analyzed using business intelligence (BI) tools, ________ clients, and a variety of analytics applications designed to interpret the data.

SQL

The first two steps in business process management (BPM) are examining the design of the process and modeling the process. What are the third and fourth steps of the process?

Step 3: running the process; Step 4: monitoring the process

Which step of business process management allows managers to create a continually improving process?

Step 5: process optimization

What provides the structure for structured decisions and tasks in the workplace? More than one answer may be correct.

Structured decisions and tasks are supported by defined procedures and routine because they typically involve routine operations and/or common situations or problems.

A manager wants to accurately predict how many light-up three-wheeled scooters they'll need to meet holiday demand. Which component of supply chain management would the manager be using to determine the appropriate number to produce?

Supply chain planning

Popular applications used by today's organizations in web mining include Google Analytics, Data Miner, and

Tableau

Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?

Tableau

Why did Max Weber believe that personal responsibility, ethical behavior, and charity were fundamental to capitalism?

These are the basic principles of Protestantism.

According to Adam Smith, what are three ways that businesses can make labor more efficient?

They can have workers specialize in a single, simple task. They can reduce the distance between manufacturing steps or facilities. They can invent machines to multiply the productivity of workers.

When designing a solution, why is it important to consider all outcomes?

This will allow you to create multiple plans in order to visualize all possible solutions.

From the following list, select all the characteristics of unstructured management decisions.

Unstructured decisions are strategic decisions that require more insight and judgment than structured decisions, so they are typically made by higher-level management.

What is a downfall to just-in-time manufacturing and inventory management?

When supply chain disruptions occur, a lack of sufficient inventory on hand can lead to widespread shortages.

Which of the following is an example of an industry that requires just-in-time inventory management to remain profitable? More than one answer may be selected.

a fast-fashion retailer that sells knock offs of recent trends targeted to teenage girls a small concert venue that hosts 40-50 regional acts a year

Data integrity means the database is reliable, ________, and aligned to the goals of the organization.

accurate

In addition to advancements in computer hardware, what drove improvements to POS (point-of-sale) systems in the 1990s?

an increasingly diverse group of users and their needs

The process of investigating raw data of various types to uncover trends and correlations, and to answer specifically crafted questions is the role of data ______.

analytics

Data mining is a means of ________ data that can help organizations find patterns and relationships within data sets.

analyzing

Protecting private or sensitive information by eliminating or encrypting information is the goal of data _____.

anonymization

When investigating a solution, what information is it important for you to identify?

any additional information you may need how much time or money you have available to fix the problem

A marketing manager wants to determine which marketing campaign for a specific product was the most successful as determined by the amount of revenue generated. She uses the company's MKIS to determine how much revenue was generated for each of the three major campaigns run that year to determine revenue generated as compared to the cost of the campaign. This is an example of using an MKIS to

assist with cost-benefit analysis.

Unstructured decisions include which of the following decisions or activities? More than one answer option may be correct. Check All That Apply

capital budgeting decision strategic goal development

The first modern transaction processing system was

cash register

A record is a ________ of related fields in a data file.

collection

To create a relationship between commontwo tables, you must use a ________ field that is present in both tables.

common

In a multiple-criteria decision analysis (MCDA), what are you doing when you are identifying available options?

comparing different options in order to determine which are best candidates for measure

What is the server in a client-server network?

computer hardware

What is the last step in the Five Whys?

consult with members of the organization

The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally

creating your visuals.

When creating a database field, we set ________ for each field to decrease data input mistakes.

data types

A database management system (DBMS) is a computer program that is used to create, process, and administer a

database

Which element of a PESTEL analysis is represented by the use of data mining information from the Bureau of Labor Statistics to gain insight into regional employment figures?

economic

How do managers use personal computers for their business needs? More than one answer may be correct.

email, spreadsheets and data base

From the following list, select all the business practices that are both "green" or environmentally responsible and sustainable in terms of a business's current and long-term success and the environment.

encouraging employees to telecommute using teleconferencing for meetings shifting to a shorter, four-day workweek

Which type of MIS report pinpoints outliers that vary from the norm, such as when a production quota falls below forecasted levels?

exception reports

The first step in business process management examines business activities and breaks them down into their individual components. This is called the process decomposition step.

false

The third step in business process management provides managers with real-time (executable) decision making as well as the ability to play the "what-if" game by changing input variables (abstract) decision making. This is called the process modeling step.

false

Making use of the research and development conducted by the market innovator and then developing a competing product at a lower price is referred to as the ________ strategy.

fast follower

Over 50 percent of all innovative products fail in the market, while over 80 percent of the successors to the products succeed. This is a key tenet of ________ strategy.

fast-follower

A marketing manager requests and receives a report on consumers who use a competing brand of laundry detergent. Included in this report is demographic information such as age, gender, and geographic location; frequency with which the product is purchased; estimated amount of revenue generated by this product per geographic location; and qualities that consumers rank as important to their purchasing decision. These reports represent what function of a marketing information system (MKIS)?

gathering marketing data

Management information systems (MIS) for communication directly support organizational decision making by

helping managers communicate, obtain, discuss, and understand the information necessary for strategic decisions.

What is the third step when applying multiple-criteria decision analysis (MCDA)?

identify and select objectives and criteria

Database forms structure data input to ensure data

integrity

One of the features of using web mining is that it improves website usability. This usability refers to how easily website users can ________ with the site.

interact

Which outcome of the balanced scorecard framework measures how efficiently a business is operating?

internal business processes

From the following list, select the types of markets that Professor Michael E. Porter showed were suitable for both price leadership strategies and product differentiation strategies.

international markets

Henry Mintzberg classifies management roles into three types. Which of the following roles does this researcher identify? More than one answer may be correct.

interpersonal informational decisional

Which of the following is a reason that Six Sigma methodologies rely heavily on data analysis?

its focus on reducing variation and eliminating product defects

In his text, "The Human Side of Enterprise," Douglas McGregor focused on

manager attitudes toward their employees.

When discussing personally identifiable information (PII), which three of the following are usually anonymized? Check All That Apply

names phone numbers social media activity SS #'s

When supply chain disruptions occur, a lack of sufficient inventory on hand can lead to widespread shortages.

new comp

Telecommuting is considered an employee benefit because

not commuting to work adds flexibility to telecommuters' schedules.

Databases maintain data and information about various types of data

objects

Quantifiable values that validate how effectively an organization is accomplishing significant business objectives are called key

performance indicators (KPIs).

OLAP is used to support businesses in a wide range of areas including ________.

performance management financial reporting simulation model software downloads

During the optimization process step of business process management, what are two key things manager look for in the process?

potential slowdowns and savings opportunities

Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft _____ BI.

power

In the six-step process analysts use to create data-driven decisions, the step during which data cleansing occurs to ensure that high-quality data is ready for processing is the _____ step.

process

The first step in business process management, in which analysts often "storyboard" the processes in an attempt to view the entire system prior to investigating each component is called

process design.

The third step in business process management provides managers the ability to play the "what-if" game by changing input variables (abstract) decision making. This step is called

process execution.

The second step of business process management (BPM) involves the use of flowcharts and other tools to examine decision points and inputs. This step is called

process modeling.

In the fourth step in business process management, managers track the individual components of the process as well as the process as a whole so engine performance can be measured. This step is called

process monitoring

When competitors seek to gain competitive advantage through price leadership or by making product improvements, Professors W. Chan Kim and Renee Mauborgne would say they are using a(n)

red ocean strategy.

In order to be considered open data, databases must provide access rights so that they can be

redistributed.

Which of the following are the tenets of lean manufacturing that Dr. James Womack included in his book The Machine that Changed the World? More than one answer may be selected.

relentlessly pursuing perfection creating products that consumers aren't aware that they want including redundant steps as an extra measure of quality control

Information in a database table is made up of ________ called records or objects, and ________ called fields.

rows columns fields objects

From the following list, select all of the performance areas that are typically observed by middle managers and operational managers. Check All That Apply

sales employee performance adherence to organizational guidelines

Trends in data analytics include which three of the following?

scalable AI virtual analytics composable data data analytics as a core business function

Data-driven decision making (DDDM) can be facilitated through a six-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?

share

Database policies should be created and implemented by all organizations, regardless of the ________ of the organization.

size

The main tools used by data analysts include which three of the following?

spreadsheets Punnett squares databases and query languages data visualization tools

An independent data mart is a(n) ________ system created separate from a data warehouse and focused on specific organizational functions.

stand-alone

Structured Query Language (SQL)-specific queries use specific SQL ________ to execute the query.

statements

During which step of business process management are bottlenecks and excesses in the engine identified?

step 4 process monitoring

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.

structured

A business must not only look at its direct competitors, but also must contend with those firms that offer a product that a consumer might alternatively choose. For example, McDonald's and Burger King can be considered competitors and if one firm raises prices the other firm might gain its customers. However, if both firms raise their prices, customers may choose to purchase pizza instead. Porter refers to this as the force of

subs

Coca-Cola and PepsiCo dominate the soft drink market. However, during the 2000s, many customers switched from soft drinks to water, causing Coca-Cola and PepsiCo to develop Dasani and Aquafina. The ability of customers to switch from one product to an alternate product illustrates what Porter called the force of

subs

Data governance involves the staff, procedures, and technologies needed to ________ and protect the data and data properties of an entity.

supervise

Apple uses Corning's glass products for all its devices, such as the Gorilla Glass 6 used in the iPhone 11 series. To ensure that it continues to have a strong relationship with this glass industry leader, Apple has invested nearly $500 million toward Corning's advanced glass research division. By building up this relationship, Apple seeks to maintain some control over which of Porter's 5 forces?

suppliers

In the Five Whys, why is it important to continue to ask why after asking why the problem occurred?

this will help you understand the root cause of the problem, not just a surface issue that may have arose

In the fifth and final step in business process management, managers adapt the process to enhance process performance. This is called the process optimization step.

true

In the fourth step of business process management, managers measure the performance of the engine. This is called the process monitoring step.

true

The main function of executive support systems (ESSs) is to

turn data into information to support high-level decision making.

In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are)

two dashes: "- -."

When a large number of buyers seek to purchase a firm's products even when prices increase, Porter's force of customers can be said to have

weakened

One of the ways web mining improves web experiences is through site visibility. Site visibility includes how and ________ the website appears when queries are executed in a search engine.

when

Adam Smith argued for the division of labor because he believed that

workers who specialize in a task perform it more efficiently and can help identify ways to mechanize it.