IS 3310 Midterm
an example of raw data from an automobile manufacturer would be
1 Subaru Outback sold January 7,2015 in Mount Kisco, New York for 25,000
four major types of enterprise applications
1) enterprise systems 2) supply chain management systems 3) customer relationship management systems 4) knowledge management systems
four generic strategies
1) lower cost leadership 2) product differentiation 3) focus on market niche 4) strengthen customer and supplier intimacy
Which of the following is the best definition of an information system?
A set of interrelated components that collect , process, store, distribute information to support decision making and control in an organization
What are some of the benefits named for using Excel in a business context?
All of the above (it is easy to use, it is easy to explore "what if?" scenarios, it automates data processing)
Which of the following is an example of a business using information systems to create new products and services?
Apple's creation of the ipad.
You have a client that needs to demonstrate that its past, present and future workforce plans were fit for purpose. Its data is in different formats, in varying degrees of accuracy and stored in multiple systems across the organization. What are your next steps to help your client quickly and easily access and understand all of this data?
Consolidate the data and create a visualization
A client is suffering a much higher rate of employee turnover than normal within its sector, including losing a significant amount of key talent. The direct cost of this (recruitment costs and lost revenue) is affecting the company's immediate profitability. This loss of talent was a cause of long-term concern in realizing the company's growth strategy. What two types of analysis would you perform to test a range of hypotheses to identify the most common drivers behind employees leaving the company?
Factor analysis and regression analysis
What is the first step you should take in managing data for a firm?
Identify the data needed to run the business
What is one of the reasons that R is a leading statistical data package?
It allows the import of data from multiple sources and formats
What is one of the reasons that R is a leading statistical data package?
It allows the import of data from multiple sources and multiple formats
How does Hadoop work?
It breaks up Big Data into multiple parts so each part can be processed and analyzed at the same time on multiple computers
an example of a business using information systems for supplier intimacy is
JCPenney's information system that allows its contract manufacturer to see what garments have been sold and need to be replaced
Which of the following statements about Linux is not true?
Linux is the primary OS used in quantum computing
A relocation control system that reports summaries on the total moving, house-hunting, and home financing costs for employees in all company divisions would fall into the category of a/an:
MIS
Which type of system would you use to determine the five suppliers with the worst record in delivering goods on time?
MIS
Walmart exemplifies the power of information systems coupled with excellent business practices and supportive management to achieve which of the following?
Operational efficiency
Which type of system would you use to change a production schedule if a key supplier was late in delivering goods?
SCM
In a relational database, the three basic operations used to develop useful sets of data are:
Select, project, join
Which of the following types of computer would you use to support a computer network?
Server
Which business objective were competitors seeking when they rushed to provide ATMs as well after citibank introduced the first ATMs in New York?
Survival
You have a client that has been spending months collecting and analyzing product data and is communicating the findings via basic spreadsheets and sets of powerpoint slides. The data set had become so large that these traditional approaches were not allowing users to interact and use the data at the required level of detail. What tool can connect volumes of data and visualize the data in real time?
Tableau
________ is a service provided by the Internet that uses universally accepted standards for storing, retrieving, formatting, and displaying information in a page format.
The World Wide Web
__________ is a service provided by the Internet that uses universally accepted standards for storing, retrieving, formatting, and displaying information in a page format
The World Wide Web
Which of the following is an interactive, multiuser operating system developed by Bell Laboratories in 1969 to be highly supportive of communications and networking?
UNIX
The enormous volume of data generated by Internet activity, such as web traffic, email, and social media is referred to as:
big data
smallest to largest
bit, byte, field, record, file, database
structured
can be saved into a file
An organization needs to understand why things are happening in their organization. What type of analytics should they use?
diagnostic analytics
Data mining is more ____________ than OLAP
discovery driven
table
grid of columns and rows
supercomputer
more sophisticated computer used for tasks requiring extremely rapid and complex calculations with thousands of variables
you
most important part of info system
cloud databases
relational database engines provided by cloud computing services; appeals to web focused businesses
core competency
relies on knowledge that is gained over many years of experience as well as knowledge research
relational DBMS
represent data as two dimensional tables; contains entities and attributes
vertical market applications
serve the needs of a specific industry
Operational or transaction databases are product oriented, handling transactions that update the database. In contrast, data warehouses are
subject oriented and nonvolatile
data marts
subset of data warehouse
analytics
the science of examining raw data
Which of the following statements regarding regression are true? Mark all that apply.
-Simple regression uses only one explanatory variable -Both simple regression and multiple regression are linear regressions -Multiple regression uses more than one explanatory variable
porter's competitive forces model
1) new market entrant 2) substitute products 3) customers 4) suppliers 5) traditional competitors
What does Adaptive and Autonomous analytics do?
Builds a real-world model, takes action and learns from the environment
Which of the following systems are especially suited to situations in which the procedure for arriving at a solution may not be fully predefined in advance?
DSS
Which of the following allows users to add, change, delete, or retrieve data in a database?
Data manipulation language
Which of the following statements about data warehouses is not true?
Data warehouse systems provide easy to use tools for managers to easily update data
Which type of software provides more control over text and graphic placement in the layout of a page than word processing software?
Desktop publishing software
Which type of system would you use to determine what trends in your supplier's industry will affect your firm the most in five years?
ESS
Hadoop Ecosystem
Enables distributed parallel processing of big data across inexpensive computers
You have been hired by Inspiration Inc. to help improve its profit margin. Inspiration Inc. is a business communications consulting firm that services many clients in different industries throughout the world. The firm provides its clients with customized written recommendations about how to best use the client's existing resources to improve the client's internal communications. The company has approximately 100 consultants, all of whom are located in its central headquarters in Chicago. What system do you recommend to improve Inspiration Inc.'s business processes and increase its profit margin?
Extranet, to enable quick collaboration via the Internet, minimize the time spent communicating with the client, and minimize the amount of paperwork needed
Which of the following statements is not true about cloud computing?
It removes the concern about data and systems security for businessess
________ is an operating system-independent, processor-independent, object-oriented programming language that has become a leading interactive programming environment for the web.
Java
MongoDB and Simple DB are both examples of
NoSQL databases
Which of the following enables users to view the same data in different ways using multiple dimensions?
OLAP
You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table?
One-to-one
You are working at a startup company that wants to embed analytics into their product. What tool would allow you to do this?
Python
Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables?
Relational DBMS
What are the relationships that the relational database is named for?
Relationships between entities
Which of the following is a high-speed network dedicated to storage that connects different kinds of storage devices, such as tape libraries and disk arrays so they can be shared by multiple servers?
SAN
Which of the following is an example of a legacy system?
Transaction processing system running on a mainframe
data
a daily sales report of each sales transaction that is sent to he chief operating officer
info
a daily sales report of each transaction over $100,000 that is sent to the division marketing manager
decision tree analysis
a decision support tool that uses a tree like graph of decisions and their possible consequences
Running a Java program on a computer requires:
a java virtual machine to be installed on the computer
SAS
a licensed software system for data analysis, graphs and report writing
data
a list of social security numbers
cloud computing
a model of computing in which firms and individuals obtain computing resources over the internet
data
a monthly production report that is sent to shop floor supervisors who do not use the report because they believe the figures reported are outdated and inaccurate
MIS
a relocation control system that reports summaries on the total moving, house hunting, and home financing costs for employees in all company divisions would fall into the category of
which of the following illustrates the use of information systems to achieve product differentiation
a shoe manufacturers use of info systems in selling custom, made to order shoes directly to customers
OLAP dice
a slice on more than two dimensions
OLAP slice
a subset of a multidimensional array
enterprise systems
also called ERP systems, integrate data into single system, speed communication, enable greater flexibility and enable managers to assemble overall view of operations
the largest provider of cloud based services in the US
amazon web services
qlikview
an analytics and visualization tool for advanced data investigation
info
an exception report of all accounts that are more than 90 days late which is sent to the accounts receivable manager
R
an open source software environment and language for statistical computing and graphics; leading statistical analysis package
business intelligence
an umbrella term that combines architectures, tools, databases, analytical tools, applications, and methodologies.
Pre configured hardware software systems that use both relational and non relational technology optimized for analyzing large datasets are referred to as
analytic platforms
Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as:
analytic platforms
think client
application program must be preinstalled on the client
adaptive analytics
ask "adapt to change?"
prescriptive analytics
ask "right course of action?"
predictive analytics
ask "what could happen?"
descriptive analytics
ask "what?"
diagnostic analytics
ask "why?"
A characteristic or quality describing an entity is called a(n):
attribute
data dictionary
automated or manual file storing definitions of data elements and their elements
multi tiered client/server architecture
balances load of network over several levels of services
input, processing, output
basic activities of an info system
Which broad area of data mining applications partitions a collection of objects into natural groupings with similar features?
clustering
All of the following are new technology related trends in MIS except
co-creation of business value
knowledge management system (KMS)
collect relevant knowledge and make it available wherever needed in the enterprise to improve business processes and management decisions; link to external sources of knowledge
time series analysis
collected over time
database operations "join"
combines relational tables to provide user with more info than available in individual tables
roll up
computing all of the data relationships for one or more dimensions
You are working in Excel with a large table of data that includes a column of student scores. You want to highlight the scores in the table so you can find the rows for the students who scored the top 10% of grades more easily. Which Excel visualization should you use?
conditional formatting
quality
conformance to specifications and absence of variation from specs
storage networking SANS
connect multiple storage devices on a separate high speed network dedicated to storage
You have a client that needs to demonstrate that its past, present and future workforce plans were fit for purpose. Its data is in different formats, in varying degrees of accuracy and stored in multiple systems across the organization. What are your next steps to help your client quickly and easily access and understand all of this data?
consolidate the data and create a visualization
operating system (OS)
control computers resource and blocks of data; provides services to application programs and users
organizations
coordinate work through structured hierarchy and business processes
database operations "project"
creates subset of columns in table
database operations "select"
creates subset of data of all records that meet stated criteria
semistructured
data that contains tags (XML or HTML)
Hadoop
designed for big data, open source software, breaks data down into sub problems and distributes the processing to many inexpensive computer processing nodes
non relational databases
developed to handle large data sets of data that is not easily organized into tables, columns, rows
The use of multiple computers linked by a communications network for processing is called:
distributed processing
segmentation analysis
divides a broad category into subsets that have or are perceived to have common features, needs, interests (similar to cluster)
When querying a dimensional database, a user went from summarized data to its underlying details. The function that served this purpose is
drill down
python
easy open source general programming language
unstructured
email, books, untagged audio
The six important business objectives of information system investment include all of the following except:
employee morale
virtualization has
enabled microprocessor to reduce the size of transistors to the width of an atom
effectiveness
enables an organization to accomplish its strategy
What is the most important benefit of an enterprise application?
enabling business functions and departments to share information
what is the most important benefit of an enterprise application?
enabling business functions and departments to share information
Which of the following systems are designed to support organization-wide process coordination and integration?
enterprise applications
A(n) ________ collects data from various key business processes and stores the data in a single comprehensive data repository, usable by many parts of the business.
enterprise system
Which of the following systems are designed to support organization-wide process coordination and integration?
enterprise systems
customers, cars and parts are examples of
entities
In terms of the data relationships found by data mining, sequences refers to:
events linked over time
text mining
extracts key elements from large unstructured data sets
What type of analysis can be used to analyze large number of dependent and independent variables, identifying the core set that will help gain meaningful insight?
factor analysis
primary key
field in table used for key fields
data mining
finds hidden patterns and relationships in large databases and infers rules from them to predict future behaviors
NOSQL DBMS
flexible, data sets stored across distributed machines, easier to scale and handles large volumes of unstructured and structured data
technology
foundation or platform that information systems build on computer hardware, software, data management technology, networking and telecommunications technology
Connecting geographically remote computers in a single network to create a "virtual supercomputer" is called:
grid computing
field
group of characters as words or numbers
file
group of records of same type
record
group of related fields
database
group of related files
the value chain model
helps a firm identify points at which info technology can most effectively enhance its competitive position
factor analysis
helps detect what aspects of the independent variables are related to the independent variables
tableau
helps take decisions and bring those insights to actions; in memory tool, connect multiple data soures
business model
how a company produces, delivers, and sells its products and services
In a ________ computing model, companies use their own infrastructure for essential computing tasks and adopt public cloud computing for less critical operations or additional processing during peak business periods.
hybrid cloud
Verizon's implementation of a web-based digital dashboard to provide managers with real-time information, such as customer complaints, is an example of:
improved decision making
Allowing Big Data to be processed in memory and distributed across a dedicated set of nodes can solve complex problems in near-real time with highly accurate insights. What is this process called?
in memory analytics
All of the following describe the effects of globalization except
increases in transaction costs
All of the following describe the effects of globalization except:
increases in transaction costs
people
info system requires skilled people to build, maintain and use them
interrelated components that manage info to support decision making and control and helps with analysis, visualization, and product creation
information system
the hardware and software a business uses to achieve objectives
information technology
activities in an info system that produce info
input, processing, output, feedback
supply chain management is a type of ____
inter organizational system
database mangement systems (DBMS)
interfaces between applications and physical data files; solves problems of traditional file
structured query language (SQL)
international standard, used by most popular DBMS
Supply chain management systems are considered to be a(n) ________ because they automate the flow of information across company boundaries.
interorganizational system
A table that links two tables that have a many-to-many relationship is often called a(n):
intersection relation
which of the following statements is not true about cloud computing
it removes the concern about data and systems security for business
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:
it typically focuses on a single subject area or line of business
A field identified in a record as holding the unique identifier for that record is called the:
key field
input hardware
keyboard, mouse, other
mainframes
large capacity, high performance computer that can process large amounts of data very rapidly
machine learning
like a human brain
primary secondary storage technologies
magnetic disk, optical disk, magnetic tape
the internet raises the bargaining power of customers most effectively by
making information available to everyone
a student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a _________ relationship
many to many
network economics
marginal costs of adding another participant are near zero; larger number of participants in internet greater value to all participants
Software applications that combine different components of online software applications are referred to as:
mashups
The average number of baseball tickets sold at a particular price is an example of
meaningful information
sentiment analysis software
mines emails, blogs, social media to detect opinions
output hardware
monitor, printer, speaker, other
OLAP drill down/up
navigating among levels of data ranging from the most summarized (up) to the most detailed (down)
SAS has advantages for both technical and non-technical users. What are they?
non technical users can interact with the point-click interface while technical users can perform more complex data management
OLAP is a tool that enables users to:
obtain answers online to ad hoc questions
In terms of the data relationships found by data mining, associations refers to
occurrences linked to a single event
In terms of the data relationships found by data mining, associations refers to:
occurrences linked to a single event
Cisco's WebEx is an example of which of the following types of collaboration tools?
online meeting
Which of the following is not an essential characteristic of cloud computing?
open source software
________ is free software created and updated by a worldwide community of programmers.
open source software
using info systems requires an understanding of _____
organization, people and technology
You are a new manager at a plumbing supply manufacturer where there are an unusually high number of returns for a new aerator used in production of high end faucets. In examining this problem you determine that the primary cause is the improperly designed die cast for the aerator. which dimension of a business problem does this reflect?
people
transaction processing system (TPS)
perform routine tasks
customer perspective
physical quality, reliability, quality of service and psychological quality
grid computing
power of geographically remote computers connected into single networks to act as virtual super computer
analytic platforms
preconfigured hardware and software
An organization is trying to determine if they should increase the production of their product. To help answer the question of how much their customers are likely to buy in the future, what type of analytics should this organization perform?
predictive analytics
business value chain model
primary activities, support activities, benchmarking and best practices
transaction processing
primary data; daily operations and short term
foreign key
primary key used in second table as look up field to identify records from original table
virtualization
process of presenting a set of computing resources so they can be accessed in ways that are unrestricted by physical configuration or geographic location
converting raw data into a more meaningful form is called
processing
main memory (RAM)
program instructions operating system instructions
horizontal market applications
provide capabilities common across all organizations and industries
management info system (MIS)
provide current performance
TQM
quality control in itself
efficiency
ratio of benefits to costs
Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.
referential integrity rules
Which of the following statements is true?
regression is a process that has errors
thin client
runs within a browser and does not need to be preinstalled, browser will load the code dynamically
data inconsistency
same attribute has different values
The client all gives you all email communication they have received in the last six months that have included the words "complaint", "manager", or "dissatisfied". What type of data is this?
semi structured
data definition capability
specifies structure of database content, used to create tables and define characteristics of fields
regression analysis
statistical process for estimating relationships between a dependent variable and one or more independent variables
data warehouse
stores current and historical data from many core operational transaction systems
data
stream of raw facts
normalization
streamlining complex groupings of data to minimize redundant data elements and awkward many to many relationships
A client presents you with data sets for analysis. These sets are well defined and include customers names, ages, and other identifying data. What type of data is this?
structured
________ systems integrate and share information from suppliers, manufacturers, distributors, and logistics companies.
supply chain management
servers
support computer networks sharing files and resources
decision support system (DSS)
support non routine decision making; model based data driven
executive support system (ESS)
support senior management; incorporate data about external events
online analytical processing (OLAP)
supports multidimensional data analysis, enabling users to view the same data in different ways using multiple dimensions and obtain online answers to ad hoc questions
A firm that invests in an information system because it is a necessity of doing business does so because it is seeking to achieve which of the following business objectives?
survival
enterprise applications
systems that span functional areas, focus on executing business processes across the firm and include all levels of management
Which of the following statements about client/server computing is not true?
the bulk of processing occurs on the client
data analytics
the exploration and quantitative analysis of all available structured and unstructured data to develop understanding, extract knowledge and formulate actionable results
simulation analysis
the imitation of the operation of a real world process or system over time
multivariate analysis
the observation and analysis of more than one statistical outcome variable at a time
sentiment analysis
the process of identifying and categorizing opinions expressed in a piece of text to determine whether the writers attitude towards a topic or issue is positive, negative or neutral
employee morale
the six important business objectives of info systems investment include all of the following except
Data management technology consists of:
the software governing the organization of data on physical storage media
A computerized system that performs and records the daily activities necessary to conduct business is classified as a(n):
transaction process system
business intelligence processing
transformed secondary data; medium and long term
You create a line chart in Excel, showing monthly rainfall levels over a period of 10 years. You want the chart to indicate whether rainfall is generally rising, falling, or remaining at a consistent level. What should you add to the chart?
trendline
A client computer networked to a server computer, with processing split between the two types of machines, is called a(n) ________ architecture.
two tiered client/server
A client computer networked to a server computer, with processing split between the two types of machines, is called a(n) ________ architecture.
two-tiered client/server
processed data
type of info
The client presents you with another set of data. This data is a compilation of all of the comments made on their social media page for the last six months. What type of data is this?
unstructured data
referential integrity rules
used by relational databases to ensure that relationships between coupled tables remain consistent
in memory computing
used in big data analysis; relies on RAM
data manipulation language
used to add, change, delete, retrieve data from database
pivot
used to change the dimensional orientation of a report or an ad hoc query-page display
virtual company
uses networks to link people, resources, and ally with other companies
two tiered client/server architecture
uses two types of machines
cache
very fast memory
Second Life is an example of a(n):
virtual world
A data ________ stores current and historical data of potential interest to decision makers throughout the company.
warehouse
the toy manufacturer you work for wants to exchange data with a chain of toy stores in order to improve their distribution and speed to market. The toy stores use different software than your firm. Which of the following tools or technologies presents the best solutions?
web servcies
Which of the following would you use to find out which websites with content related to database design were the most often linked to by other website?
web structure mining
Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites?
web structured mining
marketing and advertising
what field has info systems affected the most
program data dependency
when changes in program require changes to data accessed by program
synergies
when output of some units can be used as inputs to others units
cluster analysis
when you group a set of objects in a way that objects in the same group or cluster are more similar to one another than those in the other clusters
TPS
which type of system would you use to determine the five suppliers with the worst record in delivering goods on time
ESS
which type of system would you use to determine what trends in your suppliers industry will affect your firm the most in 5 years
DSS
which type of system would you use to forecast the return on investment if you used new suppliers with better delivery track records
