SIT Test 2

Ace your homework & exams now with Quizwiz!

Sustainable, or "green," MIS

production, management, use, and disposal of technology in a way that minimizes damage to the environment

What is data that humans, in interaction with computers, generate?

unstructured data

Database

collection of related tables

Warm site

computer equipment, but requires installation and configuration

What is it called when a manager has so much data and information that he or she cannot make a decision?

data rich, information poor

Hybrid Cloud

mix of private, public or community ex: private cloud of the company and a public cloud for customers, suppliers and partners financials on a private cloud and the rest of the company on a public cloud

Public cloud

multi-tenancy off-premise several organizations ex: amazon EC2, Windows azure save money

Community cloud

multi-tenancy off-premise several organizations ex: private hospital, all Colorado state gov't organizations pharmaceuticals and financial services

In a data warehouse information is:

multidimensional with layers

Cold site

no computer equipment just a place for employees

Cloud sharing sites

outright.com (accounting and finance) box.com

Backup and Recovery Plan

Hot site Cold site Warm site

Agile MIS infrastrucure

Support 50% growth- If an organization grows by 50 percent in a single year, its systems must be able to handle a 50 percent growth rate.

Analytical CRM

Supports back-office (accounting, finance, human resources, data warehouses, business intelligence) operations and strategic analysis

broad network access

all devices can access data and applications

Enterprise Resource Planning or ERP software packages can be purchased from several companies including

all of the above

In which of the five basic supply chain activities do you build relationships with suppliers to procure raw materials?

source

rapid elasticity

storage, network bandwidth, and computing capacity can be increased or decreased immediately, allowing for optimal scalability

infrastructure as a service

A service that delivers hardware networking capabilities, including the use of servers, networking, and storage over the cloud using a pay-per-use revenue model. No software. ex: Amazon EC2

Characteristics of an agile MIS infrastructure

Accessibility Availability - five 9's Maintainability - flexibility Portability - Mac, PC Reliability - Accurate Scalability - Growth Usability - iPod click wheel

Which of the following lists include all of the five characteristics common to high-quality information?

Accuracy, completeness, consistency, timeliness, and uniqueness

Which of the following occurs when everyone involved in sourcing, producing, and delivering the company's product works with the same information in an ERP system like SAP?

All of these are correct

Accenture Management Consulting

As-Is (2001) 200 different legacy financial applications WW To-Be (2004) Big-Bang SAP FI/CO implementation, Single-Instance, 2,500 licenses for core users Ride SAP applications for 2 or 3 versions Governance - project prioritization based on ROI. Predicted value Vs. Realized value Workforce doubled, IT expenses down 60%

Accenture - split audit and management consulting

As-Is (2001) 600 global and 1,500 local applications Complex, patchwork of legacy systems To-Be (2004) Single-vendor approach, simplify, rationalize SAP (Finance and HR) and Microsoft (Windows, Outlook e-mail and SQL DB) Outsource 86% to low cost regions. Only 14% permanent IT staff. Virtualization 250 to 115

Jet Blue and Dodge have both learned that because of social media today:

Both of the above

The main reasons for ERP failures include:

Both of the above

Advanced analytics

Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Production and materials management components of ERP

handle the various aspects of production planning and execution such as demand forecasting, production scheduling, job cost accounting, and quality control

Which ERP component can help an organization determine such things as the identification of individuals who are likely to leave the company unless additional compensation or benefits are provided?

human resource components

A sustainable MIS infrstructure

identifies ways that a company can grow in terms of computing resources while simultaneously becoming less dependent on hardware and energy consumption.

Logistics (Inbound & Outbound)

includes the processes that control the distribution, maintenance, and replacement of materials and personnel to support the supply chain Inbound logistics acquires raw materials and resources and distributes them to manufacturing as required. Outbound logistics distributes goods and services to customers ex: drones, radio frequency identification

The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information. What is this an example of?

increased scalability and performance

Analytical CRM can help you determine which type of marketing and sales campaign to launch and which customers to target so that you can achieve uplift. Uplift means?

increasing sales

This allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems?

integration

What did the UK Defense department do so that they did not have to do manual entry into multiple databases?

integration

Application integration

integration of a company's existing management information systems.

Data integration

integration of data from multiple sources, which provides a unified view of all data

Procurement

is the purchasing of goods and services to meet the needs of the supply chain. ex: 3D Printing

What is one of the biggest pitfalls associated with real-time information?

it continually changes

What is the primary tool that retrieves information and helps managers graphically design the answer to a question?

query-by-example tool

How would the banking industry use business intelligence?

understand customer credit card usage and nonpayment rates

Drones are now being used by Amazon to support logistics. What are drones?

unmanned aircraft that can fly autonomously, or without a human

In big data analytics more data is typically _______ than _______.

unstructured (80%); structured (20%)

Eintegration

use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.

Kaiser

used CRM to enforce more rigorous eye-screening for diabetic patients

On-demand self-service

users can increase storage and processing power as needed

What is supply chain visibility?

views all areas up and down the supply chain in real time like at GBI Bikes

Transactional information examples

withdrawing cash from an ATM, making an airline reservation, purchasing stocks, daily sales, hourly employee payroll, product orders, shipping an order

Data center

(Server farm), A facility used to house MIS including telecommunications and storage systems Google, Microsoft, Amazon - Columbia River in the North West

Foreign key

A primary key of one table that appears an attribute in another table

Three most common core ERP components

1. Accounting and finance FI/CO 2. Production and materials management MM/PP 3. Human resource HR

Three main links of supply chain

1. Materials flow from suppliers 2. Transformation of materials into products 3. Distribution of products to customers

Instead of shipping parts from Germany, Porsche uses what new local procurement process, building parts layer by layer in an additive process - a three-dimensional solid object from a digital model?

3D Printing

Server

A computer dedicated to providing information in response to requests

Three key main integration tools include:

All of the above CRM ERP SCM

Article - Strategic IT Transformation Accenture (World's largest Management Consulting Organization)

As-Is (2001) Anderson Consulting became > Accenture IT is a cost center, decentralized, mixed approach, legacy systems To-Be (2004) (Best-of Breed or One Platform?) New IT Infrastructure, One-Firm approach, centralized, business within a business Support business requirements

MIS infrastructurre supporting operations

Backup and recovery plan - weekly Disaster recovery plan Business continuity plan

Kaplan and Norton developed the _______ so that companies could measure ERP success as well as to clarify their strategy and translate it into action.

Balanced scoreboard

What is it called when distorted product-demand information like Dodge Dealers discounting Vipers and artificially increasing demand, ripples from one partner to the next throughout the supply chain?

Bullwhip effect

Which application's primary business benefits include sales forecasts, sales strategies, and marketing campaigns?

CRM

What is an organization performing when it asks CRM questions such as "who are our best and worst customers"?

CRM analyzing technologies

What is an organization performing when it asks CRM questions such as "which customers are at risk of leaving"?

CRM predicting technologies

Corporate social responsibility

Companies' acknowledged responsibility to society

Hardware

Consists of the physical devices associated with a computer system

Which of the choices below does not represent an organization that requires up-to-the-second information?

Construction companies

The data warehouse compiles information from internal databases and external databases through _______.

ETL

What is the key word in ERP? Hint: You have one single database for the entire _______.

Enterprise

Which of the following occurs when the same data field has different values?

Information inconsistency issue

What do data warehouses support?

Only analytical processing (OLAP): business analysis and decision-making both a and b

What is a real-time system?

Provides real-time information in response to query requests

Sustainable data centers

Quincy, Washington Reduces carbon emissions - hydroelectricity, not coal Reduces required floor Space - MS = 10 football fields Chooses Geographic location - cheap land, electricity

3 Evolution's of CRM

Reporting - Identify customers across other applications Analysis - Segment customers - best and worst customers Predicting - Make predictions - which customers are at risk of leaving?

Which of the following was one of the first CRM components built to address the issue that sales representatives were struggling with overwhelming amounts of customer account information that they were required to maintain and track in the sales process?

Sales force automation system

Cloud computing

Stores, manages, processes data and applications over the internet Easy for SME to gain access to LE computing power!

Downstream SCM

Supplier-> Customer

Software

The set of instructions the hardware executes to carry out specific tasks

Which of the following are examples of transactional information?

airline tickets, sales receipts, and packing slips

Union Bank of California

created a disaster recovery plan that includes multiple data centers in diverse locations, mirrored sites which can take over at the flick of a switch, hot sites - where staff can walk in and start working exactly as they would if they were in their normal location - and a vast amount of redundancy.

Effective and efficient supply chain management systems can enable Procter & Gamble to:

decrease buyer power increase supplier power increase switching costs create entry barriers increase efficiencies- competitive advantage all of these are correct

What is erroneous or flawed data?

dirty data

Walmart and Procter & Gamble (P&G) implemented a tremendously successful SCM system. The system linked Wal-Mart's ________ centers directly to P&G's ________ centers.

distribution; manufacturing

Nestle had poor information and was unable to evaluate its business effectively. The problem was that its 9 million records including 550,000 vendors were:

duplicated inaccurate incomplete all of the above

What is information redundancy?

duplication of data storing the same data in multiple places storing duplicate data in multiple places All of these are correct.

What is data mining?

extracting information to find trends and patterns and relationships in large volumes of information

Materials management

includes activities that govern the flow of tangible, physical materials through the supply chain such as shipping, transport, distribution, and warehousing. ex: robotics

What is dynamic information?

includes data that change based on user action

Data visualization uses _______ that display information graphically so that it can be more easily understood.

infographics- periodic table of elements

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

record

Which of the following stores information about a person, place, thing, transaction, or event?

record

Charles Schwab

recouped the cost of a multimillion-dollar CRM system in less than two years. System segmented its customers in terms of serious and nonserious investors

Cube

representation of multidimensional information

Forward integration

sends information entered into a given system automatically to all downstream systems and processes

Backward integration

sends information entered into a given system automatically to all upstream systems and processes

SCM disruptive technologies

3D printing Radio frequency identification Drones Robotics

Using CRM to measure success effectively, only requires tracking _______ sales, marketing or customer service metrics.

5 to 7

Through data mining, Best Buy discovered the pattern/trend that _______ of their customers were responsible for _____ of their sales.

7, 43

Client

A computer designed to request information from a server

Why is the ability to look at information based on different dimensions critical to a businesses success?

Ans: The ability to look at information from different dimensions can add tremendous business insight By slicing-and-dicing the information a business can uncover great unexpected insights

Record

Collection of related fields - person, place, thing, transaction one customer

Table

Collection of related records

Who is the person responsible for creating the original website content?

Content creator

Virtualized Computing

Creates multiple "virtual" machines on a single computing device (SAP -1,400 servers) Multiple OS + multiple SW applications

Upstream SCM

Customer-> Supplier

What is the cost to the business of sending multiple identical marketing materials to the same customers?

Expense Risk of alienating customers

Which of the following is not one of the three main integration tools?

FI

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Database management system

Software as a service

Delivers applications over the cloud using a pay-per-use revenue model.

Which of the following would not be considered part of the timely characteristic of high-quality information?

Is the zip code missing in the address?

What is the primary problem with redundant information?

It is difficult to determine which values are the most current. It is often inconsistent. It is difficult to determine which values are the most accurate. All of these are correct.

If you were looking for an ERP or Enterprise Resource Planning software package specifically for a small enterprise _______ might be the best company or vendor to look into.

NetSuite

Which of the following is a common CRM sales metric?

Number of new customers

Which city did Golfsmith discover through BI; was the worst possible location for a new mega golf store?

Phoenix

Organizations can find their most valuable customers through RFM, which stands for?

Recency (how recently a customer purchased items), frequency (how frequently a customer purchased items), monetary value (the monetary value of each customer purchase)

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Relational database management system

Organizations that use CRM to increase sales and improve operations

Ritz-Carlton Hotels Harrah's Harley-Davidson

Platform as a service

Supports the deployment of entire systems including hardware, networking, and applications using a pay-per-use revenue model

Cloud fabric

The software that makes possible the benefits of cloud computing, such as multi-tenancy

What is a primary key?

a field that uniquely identifies a given record in a table

Jay Wright works at a top accounting firm in Salt Lake City and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products. Jay's duties provide value-add to his company and would be categorized as occurring at the different information ________.

formats

Hot site

fully equipped facility, resume business immediately, NY, SF

A data warehouse:

logical collection of information - from many different operational databases Supports business analysis and decision-making all of the above

A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.

logical; operational

Accounting and finance components of ERP

manage accounting data and financial processes within the enterprise with functions such as general ledger, accounts payable, accounts receivable, budgeting, and asset management

QBE or Query By Example is a query methodology in Access used primarily by

managers

MIS infrastructure

plans to build, deploy, use, and share data, processes, and MIS assets ex: hardware, software, networrk, client- requests info., serve- provides info.

Imagine you need to find information on customer Steve Smith. You may have 20 customers with the same name so a _______ helps to identify each record uniquely.

primary key

What is procurement?

purchase goods and services like large McDonald's potatoes to meet the needs of the supply chain

Field

single unit of data customer name, address, email

Which of the following occurs when everyone involved in sourcing, producing, and delivering the company's product works with the same information in an ERP system like SAP?

-Eliminates redundancies -Cuts down wasted time -Removes misinformation all of these are correct

Grid Computing

A collection of computers, geographically dispersed, coordinated to solve a common problem

Network

A communications system created by linking two or more devices and establishing a standard methodology in which they can communicate

Enterprise architect

A person grounded in technology, fluent in business, and able to provide the important bridge between MIS and the business

Which software application's primary business benefits include forecasting, planning, purchasing, material management, warehousing, inventory, and distribution?

ERP

Single-tenancy

Each customer must purchase individual system

What takes information entered into a given system like sales, and sends it automatically to all downstream systems and processes like billing?

Forward integration

Forward/backward integration of customer information

Forward: Sales system-> Order entry system-> Order fulfillment system-> Billing system Backward: Billing system-> Order fulfillment system-> Order entry system-> Sales system

Three components of a sustainable MIS infrastructure

Grid computing Virtualized computing Cloud computing

Harley-Davidson

Has obtained great success through CRM

Three Primary Side Effects Of Businesses' Expanded Use Of Technology

Increased electronic waste Increased energy consumption Increased carbon emissions

Database advantages

Increased flexibility Increased scalability and performance Reduced information redundance Increased information security Increased information integrity

Reasons ERP systems are powerful tools include?

Logical solution to incompatible applications Global information sharing and reporting Avoid pain and expense of fixing legacy systems all of the above

Dynamic scaling

Means that the MIS infrastructure can be automatically scaled up or down based on needed requirements.

In 2015, a tiered ERP architecture can include:

On premise - ERP system - HQ On demand - Cloud ERP applications - mobility On device all of the above

Which CRM system supports the traditional transactional processing for day to day front office customer transactions?

Operational CRM

The benefits of CRM

Organizations can find their most valuable customers through RFM

Which of the following is not one of the three phases in the evolution of CRM?

Processing

What is the purchasing of goods and services such as large McDonald's potatoes, to meet the needs of the supply chain?

Procurement

Three components of supply chain management

Procurement Logistics Materials management

Which of the following is an example of Analytical information?

Product statistics Trend projection Sales projection Both B and C'

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

Reduces disk space requirements Makes updating information easier Improves information quality all of the above

Which of the following is an extended ERP componenet?

SCM CRM BI all of these are correct

DreamWorks Shrek

Shrek 1 = 5 million computer hours Shrek 2 = 10 Shrek 3 = 20

Operational CRM

Supports traditional transactional processing for day-to-day front-office (customers)

What is enterprise resource planning?

The integration of all departments and functions throughout an organization into a single IT system so that employees can make decisions by viewing enterprise wide information on all business operations.

What is customer relationship management (CRM)?

a means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability

Multi-tenancy

a single instance of a system serves multiple customers - Financials? Customers share pooled computing resources

Green Computing

Using computing resources efficiently - PCs, Servers... Power management / energy efficient devices - TBL,3BL,PPP Alternative energy sources for powering and cooling - Google barges

What occurs when a website can know enough about a person's likes and dislikes that it can fashion offers that are more likely to appeal to that person?

Website Personalization

Which question below represents a CRM reporting technology example?

What is the total revenue by customer?

Which question below represents a CRM analyzing technology question?

Why did sales not meet forecast?

What is the primary difference between a database and data warehouse?

a database stores information for a single application, whereas a data warehouse stores information from multiple databases, or multiple applications, and external information such as industry information

Who are the primary users of ERP systems? Hint: They use the SAP FI, CO, MM and PP modules.

accounting, finance, logistics, and production

Which of the following is one of the three business areas of supply chain management?

all of the above

Several historic large ERP failures include:

all of the above software customization, cost Nike, Hershey, K-Mart

Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial decisions and analysis tasks?

analytical information

How would the marketing industry use business intelligence?

analyze customer demographic

How would the airline industry use business intelligence?

analyze popular vacation locations with current flight listings

Which of the following is not one of the three most common core ERP components focusing on internal operations?

business intelligence

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

change

Measured service

clients can monitor and measure transaction and use of resources

Gordon Moore

co-founder of Intel, the world's largest producer of computer chips or microprocessors, observed in 1965 that continued advances in technological innovation made it possible to reduce the size of a computer chip (the brains of a computer, or even a cell phone now) while doubling its capacity every two years.

Which of the following implies that aggregate or summary information is in agreement with detailed information?

consistency

What type of website like Zappos is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

data-driven website

What is at the heart or center of any ERP system so that you have one version of the truth?

database

Private cloud

single-tenancy on-premise one organization ex: bank, gov't, corporation use if you are worried about your finances

Moore's Law

smaller, faster, cheaper - chip performance per dollar doubles every 18 months

What modifies existing software according to the business's or user's requirements?

software customization

SCM stands for:

supply chain management

What is enterprise resource planning (ERP)?

the integration of all departments and functions throughout an organization into a single IT system (or integrated set of IT systems) so employees can make decisions by viewing enterprisewide information about all business operations EX: SAP, Sage, NetSuite

What is supply chain management (SCM)?

the management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability

Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following except:

the success of the organization depends on appreciating and leveraging the low-quality information.

Why do relational databases use primary keys and foreign keys?

to create logical relationships

Human resource components of ERP

track employee information including payroll, benefits, compensation, performance assessment, and assumes compliance with the legal requirements of multiple jurisdictions and tax authorities

Which of the following represents sales force automation?

tracking all of the steps in the sales process automatically

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

transactional information

Analytical information examples

trends, sales, product statistics, future growth projections, cost/benefit analysis, sales forecast, market trends, industry trends and regulations

Which of the following is an advantage of using a data-driven website like Zappos?

• Easy to eliminate human errors • Easy to manage content • Easy to store large amounts of data all of the above


Related study sets

CAPM Leftover Definitions (some are in other areas, use only for final study)

View Set

MG 417 Project Management - Ch. 11

View Set

NU230 Therapeutics : Chapter 15- patient education and health promotion

View Set

Chapter 13 Cloud service models and cloud security

View Set