IS 3310 Midterm

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

lesson 7 & 8 strategic management

View Set

Color and the Electromagnetic Spectrum

View Set

Ch.14 Lesson 2: Adventure and Profit

View Set

Computer System Management Final Exam Review

View Set

Live Virtual Machine Lab 10.3: Module 10 Physical Network Security Concepts

View Set