MIS 301 Final Exam

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
Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks?
analytical information
Which of the following are examples of transactional information?
airline ticket, sales receipts, and packing slips
Which of the following are examples of analytical information?
future growth analysis, sales projections, and product statistics
Which of the following lists include all of the five characteristics common to high-quality information?
accuracy, completeness, consistency, timeliness, and uniqueness
What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?
master data management
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
database management system
What type of keys do you need to use to create a relational database model?
primary and foreign keys
Which of the following is true in regard to the elimination of redundant information?
improves information quality
What are the rules that enforce basic and fundamental information-based constraints?
relational integrity constraints
Which of the following will enforce business rules vital to an organization’s success and often require more insight and knowledge than relational integrity constraints?
business critical integrity constraints
What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
data-driven website
A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.
logical; operational
Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________.
standardizing information
What is extraction, transformation, and loading?
It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
What is the ultimate outcome of a data warehouse?
data marts
Which of the following contains a subset of data warehouse information?
data mart
Which of the following is the common term for the representation of multidimensional information?
cube
What are the two main objectives associated with data mining?
uncovering trends and patterns
What is unstructured data?
not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages
What is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools?
big data
What is distributed computing?
processes and manages algorithms across many machines in a computing environment
What analyzes unstructured data to find trends and patterns in words and sentences?
text analysis
What has moved beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more?
data visualization tools
What refers to the overall management of the availability, usability, integrity, and security of company data?
data governance
Which of the choices below offers a common example of a LAN?
All of the above
Which of the choices below offers a common example of a WAN?
The Internet
What represents the loss of a network signal strength measured in decibels (dB) and occurs because the transmissions gradually dissipate in strength over longer distances or radio interference or physical obstructions like walls impact communication signals?
Attenuation
What receives and repeats a signal extending its attenuation or range?
Repeater
What measures network performance by the maximum amount of data that can pass from one point to another in a unit of time?
bandwidth
Which of the following terms refers to the smallest element of data and has a value of either 0 or 1?
bit
What is a packet?
a single unit of binary data routed through a network
What is a protocol?
a standard that specifies the format of data as well as the rules to be followed during transmission
What is the standard Internet protocol, which provides the technical foundation for the public Internet?
transmission control protocol/Internet protocol (TCP/IP)
What is Dynamic Host Configuration Protocol (DHCP)?
allows dynamic IP address allocation so users do not have to have a preconfigured IP address to use the network
What is the conversion of IP addresses that identifies labels that use a variety of recognizable naming conventions?
domain name system (DNS)
What is the efficient coexistence of telephone, video, and data communication within a single network, offering convenience and flexibility not possible with separate infrastructures?
network convergence
Which of the following statements is inaccurate in reference to unified communications?
UC increases communication expenses.
What is a VPN?
a direct private network that creates a “private tunnel” within the Internet to connect to the corporate server
What are the two main methods for encrypting network traffic on the web?
SSL and SHTTP
To create an SSL connection, a web server requires a ________, which is an electronic document that confirms the identity of a website or server and verifies that a public key belongs to a trustworthy individual or company.
SSL certificate
What is the worldwide gap giving advantage to those with access to technology?
digital divide
What is a wireless PAN technology that transmits signals over short distances among cell phones, computers, and other devices?
bluetooth
The bandwidths associated with Wi-Fi are separated according to several wireless networking standards, known as ________, for carrying out wireless local area network communication.
802.11
What is worldwide interoperability for microware access (WiMAX)?
a communications technology aimed at providing high-speed wireless data over metropolitan area networks
Which business application uses electronic tags and labels to identify objects wirelessly over short distances?
radio-frequency identification
What is a device that measures the acceleration (the rate of change of velocity) of an item and is used to track truck speeds or taxi cab speeds?
RFID accelerometer
Which tags do NOT depend on a silicon microchip and use plastic or conductive polymers instead of silicon-based microchips allowing them to be washed or exposed to water without damaging the chip?
chipless RFID
Which business application consists of hardware, software, and data that provide location information for display on a multidimensional map?
geographic information systems
What do both GPS and GIS use?
location-based services (LBS) applications that use location information to provide a service
What allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems?
integration
What takes information entered into a given system and sends it automatically to all downstream systems and processes?
forward integration
What are several different types of software that sit between and provide connectivity for two or more software applications?
middleware
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
In which of the five basic supply chain activities do you build relationships with suppliers to procure raw materials?
source
Where would you find the manufacturer and distributor in a typical supply chain?
in the middle
Who are the primary users of SCM systems?
customers, resellers, partners, suppliers, and distributors
What is the ability to view all areas up and down the supply chain in real time?
supply chain visibility
What is it called when distorted product-demand information ripples from one partner to the next throughout the supply chain?
bullwhip effect
What is the purchasing of goods and services to meet the needs of the supply chain?
procurement
What includes activities that govern the flow of tangible, physical materials through the supply chain such as shipping, transport, distribution, and warehousing?
materials management
What uses electronic tags and labels to identify objects wirelessly over short distances?
RFID
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
Which of the following is not one of the three phases in the evolution of CRM?
processing
What is an organization performing when it asks questions such as “which customers are at risk of leaving”?
CRM predicting technologies
Which of the following operational CRM technologies does the sales department typically use?
sales management, contact management, opportunity management
Which of the following operational CRM technologies does the marketing department typically use?
list generator, campaign management, cross-selling and up-selling
Which of the following operational CRM technologies does the customer service department typically use?
contact center, web-based self-service, call scripting
What is McDonald’s performing when it asks its customers if they would like to super-size their meals?
up-selling
What is the primary difference between contact management and opportunity management?
Contact management deals with existing customers; opportunity management deals with new customers.
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
What discovers optimal sales channels by selecting the right partners and identifying mutual customers?
partner relationship management
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 enterprisewide information on all business operations.
What are the primary business benefits of an ERP system?
forecasting, planning, purchasing, material management, warehousing, inventory, and distribution
Which of the following is not one of the three most common core ERP components focusing on internal operations?
Business intelligence
What modifies software to meet specific user or business requirements?
software customization
What is the systems development life cycle?
the overall process for developing information systems from planning and analysis through implementation and maintenance
Which of the following represents the phases in the SDLC?
plan, analysis, design, develop, test, implement, maintain
In which phase does the firm analyze its end-user business requirements and refine project goals into defined functions and operations of the intended system?
analysis phase
Which of the following does a project manager perform?
all of the above
Which phase of the SDLC gathers business requirements?
analysis
What illustrates the movement of information between external entities and the processes and data stores within the system?
data flow diagram
What are computer-aided software engineering (CASE) tools?
software suites that automate systems analysis, design, and development
What are defects in the code of an information system?
bugs
What assesses if the entire system meets the design requirements of the users?
alpha testing
Which implementation uses both the legacy system and new system until all users verify that the new system functions correctly?
parallel implementation
Which reports provide an internal report that highlights situations occurring outside of the normal operating range for a condition or standard?
exception reports
What is a set of policies, procedures, standards, processes, practices, tools, techniques, and tasks that people apply to technical and management challenges?
methodology
What is the success rate for a project using the waterfall methodology?
1 in 10
Which of the following describes agile?
all of the above
Which methodology uses small teams to produce small pieces of deliverable software using sprints, or 30-day intervals, to achieve an appointed goal?
SCRUM
What is a service-oriented architecture?
A business-driven enterprise architecture that supports integrating a business as linked, repeatable activities, tasks, or services.
What is the capability of services to be joined together on demand to create composite services, or disassembled just as easily into their functional component?
loose coupling
What is political feasibility?
measures how well the solution will be accepted in a given opportunity
What measures how well a solution meets the identified system requirements to solve the problems and take advantage of opportunities?
operational feasibility
What is the number one reason that IT projects fall behind schedule or fail?
unclear or missing business requirements
Who are individuals and organizations actively involved in the project or whose interests might be affected as a result of project execution or project completion?
project stakeholders
What is a graphical network model that depicts a project’s tasks and the relationships between those tasks?
PERT chart
What is the critical path?
the sequence of activities that determine the earliest date by which the project can be completed
All of the following are challenges of outsourcing, except
reduced frustration and expense related to hiring and retaining employees in an exceptionally tight job market.