ISYS 363 Final Exam !
lean manufacturing
- fredrick taylor - reaches all employees - minimizing waste
threats
A PESTEL (political, economic, socio-cultural, technological, environmental, and legal) analysis provides management with a framework to evaluate its organization's external opportunities and .
query
A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a
blue
According to Professors W. Chan Kim and Renee Mauborgne, creating an entirely new market is an example of a _______ ocean strategy.
Suppliers, Customers, Substitues
Porter's 5 Forces include existing competitors, new competitors, and which 3 of the following?
Niche markets Broad markets
Porter's generic business strategies fall into two separate categories, either price leadership, or product differentiation. He showed that these two strategies could be used in which two market types?
broad markets niche markets
Porter's generic business strategies fall into two separate categories, either price leadership, or product differentiation. He showed that these two strategies could be used in which two market types?
- Update query - Delete query - Append query
Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries?
Plant, Personnel, Purse
When conducting a SWOT analysis, managers examine factors that impact their organization's internal strengths and weaknesses. These factors are sometimes refered to as the 5 Ps. The 5 Ps include which 3 of the following?
The audit recommends ways the organization can improve its data quality and reduce costs through increasing data consistency.
Which statement best summarizes the primary advantages of performing a data quality audit?
A DBMS is a software program designed to organize and administer databases.
Which statement explains the difference between a database and a database management system (DBMS)?
threats.
A SWOT analysis attempts to identify, an organization's (or an individual's) internal strengths and weaknesses and examines external opportunities and
A firm's external threats. A firm's internal strengths. A firm's internal weaknesses.
A SWOT analysis examines which 3 of the following?
monopolistic competition
According to Professor Porter, a business must differentiate itself from its competitors. One method is to encourage customers to believe that an organization provides higher quality goods or better service, then the organization can charge a premium, or gain market share, or (ideally) both. For example, by placing a swoop icon on a sweatshirt, Nike is able to charge a higher price. This methodology is called ______.
red
According to Professors W. Chan Kim and Renee Mauborgne, the same market to gain competitive advantage is an example of a _______ ocean strategy.
Private, public, hybrid, community cloud
According to the National Institute of Standards and Technology (NIST) there are four Cloud computing deployment models.
Greater Capacity
Allows for more high-demand devices to connect over single network. This means more people can transmit data at the same time.
record
In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .
Cloud computing in today's business environment.
- In the United States, 96% of all organizations use the Cloud in one form or another. - 70% of global businesses backup some portion of their data using a Cloud service provider. - 93% of small businesses backup some portion of their data using a Cloud provider.
quickly gather and analyze specific organizational data to provide information that guides decision making
Analytic platforms are designed to ______.
competitive advantage
Attributes that allow firms to provide goods and services with higher perceived values than their competitors are referred to as competitive.
disruptive
Using technology to transform a market or to create an entirely new market is called creating a ________ innovation.
scale
Walmart uses economies of _________ to pressure suppliers to lower their prices, allowing Walmart to offer lower prices to its customers and decrease competition.
Answer questions about the database
What is the purpose of an SQL statement?
- It can provide virtual applications software. - Broad network access - There is significant storage capacity.
Which of the following are benefits of Cloud computing?
- Google apps - Smartsheet - Microsoft Office 365
Which of the following are examples of Software as a Service (Saas)?
- Provide mobile software development kits (SDKs) that assist in app development. - Hosting of hardware and software - Multi-language program development
Which of the following services are often provided by Platform as a Service (PaaS) vendors.
substitute
A business must not only look at its direct competitors, but also must contend with those firms that offer a product that a consumer might alternatively choose. For example, McDonald's and Burger King can be considered competitors and if one firm raises prices the other firm might gain its customers. However, if both firms raise their prices, customers may choose to purchase pizza instead. Porter refers to this as the force of ___________ in the market.
- Crosstab queries - Action queries - SQL specific queries
A query is a request for information stored in a database. One of the benefits of using a database to store information is the ability to run a query. In relational database management systems (RDBMS), there are a variety of query tools that are used to execute and run queries. Which of the following are tools used to run queries in an RDBMS?
six sigma
Because of its focus on reducing variation to eliminate product defects, which process methodology relies most heavily upon data analysis?
- Analyzing large volumes of data that are stored in the cloud - Organizing user-generated comments from your company's Twitter, Facebook, and Instagram pages
For which of the following tasks would it be more appropriate to use a NoSQL database than a SQL database?
5
In 1979, Professor Michael E. Porter published "How Competitive Forces Shape Strategy" in the Harvard Business Review. In this paper, he described factors that impact businesses. The became known as Porter's _______ forces.
organization, repetition, and lack of consistency
In contrast to computerized systems, traditional file management systems can create issues with ______.
fast follower
Over 50% of all innovative products fail in the market, while over 80% of the successors to the products succeed. This is a key tenet of the ______-________ strategy.
first-mover advantage
That employees will learn from experience how to use technologies to develop a product, gaining a "head start" over any competition that attempts to enter the market is considered a _________.
Hybrid cloud
The Cloud infrastructure is a composition of two or more distinct Cloud infrastructures that remain unique entities but are bound together by standardized or proprietary technology.
Public cloud
The Cloud infrastructure is provisioned for open use by the general public. It may be owned, managed, and operated by a business, academic, or government organization, or some combination of them.
stores and allows access to data objects that are related to one another
The primary characteristic of a relational database is that it ______.
collaboration
There are many benefits of Cloud computing. One of the benefits is ___________________ that enables organizations to communicate and share data/information more efficiently and is facilitated because multiple users can share and work on files at the same time.
5 P's
When conducting a SWOT analysis, managers examine factors that impact their organization's internal strengths and weaknesses. These factors are sometimes refered to as the _________.
- personnel (human resources) - plant (physical resources) - processes (Activities that create value) - purse (financial strength) - past experiences (reputation and intangible assets)
When determining an organizations or individuals internal strengths and weaknesses, managers should examine five key factors or five p's.
- Can support both SQL and NoSQL databases - Can be accessed through an application programming interface (API) - Are maintained by an external provider, such as Amazon or Oracle
Which of the following are advantages of cloud databases over a traditional database?
- Addresses of the company's wholesalers and the number of items in a company's inventory - Names of customers and records of when merchandise was returned
Which of the following are examples of data objects that a relational database management system (RDBMS) may include?
Retrieve data
Which of the following is a task that an SQL statement would be expected to perform?
- A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns). - Data tables in a relational database are linked by the fields they have in common.
Which of the following sets of characteristics specifically apply to relational databases?
- Data tables in a relational database are linked by the fields they have in common. - A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns).
Which of the following sets of characteristics specifically apply to relational databases?
Suppliers
Apple uses Corning's glass products for all its devices, such as the Gorilla Glass 6 used in the iPhone 11 series. To ensure that it continue to have a strong relationship with this glass industry leader, Apple has invested nearly $500 million toward Corning's advanced glass research division. By building up this relationship, Apple seeks to maintain some control over which of Porter's 5 forces?
The force of new competitors.
Barriers to entry can protect existing firms from which of Porter's 5 forces?
inventory
Because for many businesses, particularly in the retail and manufacturing sectors, this remains the largest operating expense, incremental improvements to _________ management can translate to huge overall savings
involves the near-instantaneous processing and analysis of huge volumes of data
Businesses can use in-memory computing to conduct or support almost any task that ______.
Community cloud
Cloud infrastructure for exclusive use by a specific community of consumers from organizations that have shared concerns (mission, security requirements, policy and compliance).
Private cloud
Cloud infrastructure is provisioned for exclusive use by a single organization comprising multiple consumers, e.g., business units). - It may be owned, managed, and operated by the organization, a third party, or some combination of them, and may exist on or off premises.
Economic
Data mining information from the Bureau of Labor Statistics can provide insight into regional employment figures. This illustrates how data analysis can be used to examine which factor of the PESTEL analysis?
Six Sigma procedure
During the Measure and Analyze steps of the ________ ___________, collecting data and using data analytics are essential.
- Products a customer has ordered - The courses a student is taking - The employees who report to a specific manager in an organizational chart
From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.
content
Geographically distributed network server groups that work together to deliver more efficient delivery of Internet and Web content are called ___________ Delivery Networks (CDN).
Elasticity
How quickly consumer demand changes with a change in price is referred to as ___________ of demand.
big data
In analyzing transactions, Walmart discovered that many people who buy Children's Tylenol in their stores also buy orange juice in the same transaction. They used this information to discount Children's Tylenol but raise the price of orange juice during flu season. What is the name of the approach Walmart used to discover this information?
- Consumers often become accustomed to products that they adopt and a firm that attempts to compete must create a product that meets the specifications established by the initial entrants. - The firm's employees will learn from experience how to use technologies and processes to develop the product. - The first firm to enter the market has an opportunity to secure important raw materials and to develop necessary logistics lines ahead of any other competitors.
In the 1980s, Professors Marvin B. Lieberman and David B. Montgomery of UCLA's Anderson School of Management examined the advantages and disadvantages of being the first firm to enter a product into the market. Three advantages they described included were:
- The firm's employees will learn from experience how to use technologies and processes to develop the product. - The first firm to enter the market has an opportunity to secure important raw materials and to develop necessary logistics lines ahead of any other competitors. - Consumers often become accustomed to products that they adopt and a firm that attempts to compete must create a product that meets the specifications established by the initial entrants.
In the 1980s, Professors Marvin B. Lieberman and David B. Montgomery of UCLA's Anderson School of Management examined the advantages and disadvantages of being the first firm to enter a product into the market. Three advantages they described included were:
disruptive innovation.
Karl Benz invented the internal combustion automobile in 1885. Adam Smith described the efficiencies of division of labor (the assembly line) in 1776. However, when Henry Ford combined these two to produce an inexpensive automobile with the Model T in 1908, he transformed the personal transportation market. Professor Clayton Christensen called this a ___________.
decrease
Large and small businesses find they can _________ their reliance on internal IT infrastructure and reduce cost by utilizing Cloud-based technologies.
defects, errors, mistakes
Lean manufacturing techniques seek to eliminate waste in the production process, in contrast, Six Sigma seeks to eliminate
Six Sigma
MIS tools that analysts commonly use to determining the causes of variances include scatter diagrams, histograms and Pareto charts. For this reason, MIS are critical in the implementation of ___ techniques.
fast-follower
Making use of the research and development conducted by the innovator, and then developing a competing product at a lower price is referred to as the ___ strategy.
personnel (workforce)
Managers often use an organization's human resource management system to evaluate the relative strength or weakness of its ___.
Sociocultural technological
Managers often use the PESTEL analysis to examine the political, economic, environmental, legal and which 2 other issues facing an organization?
PESTEL
Managers use different methodologies and tools to evaluate external opportunities and threats. One popular process examines the political, economic, socio-cultural, technological, environmental, and legal issues facing an organization and is referred to as a analysis.
Environmental
Modern supply chain management systems access National Weather Service databases to track weather events that could impact logistics. This is an example of using MIS to monitor which element of a PESTEL analysis? Multiple choice question.
Faster Connection/Data Transfer Speeds
Networks will support 500 mbps to 10 Gbps of download speed. Speeds vary by location and carrier. At the top end, that's over 100 times the speed of 4G.
Amazon Web Services (AWS)
Offers a broad set of global Cloud-based products including compute, storage, databases, analytics, networking, mobile, developer tools, management tools, IoT, security, and enterprise solutions.
Kamatera Performance Cloud
Offers a range of flexible Cloud infrastructure services including Cloud servers, cloud block storage, private cloud network, cloud firewall, and fully managed Cloud.
Google Cloud
Offers a suite of modular Cloud computing services including data storage, data analytics, computing, and machine learning. Google also offers serverless computing, IaaS, and PaaS.
Sales Force
Offers cloud solutions for Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP).
Lower Latency
On 4G networks, the time that passes when a device is asked to perform a task to when it is completed is between 40-50 milliseconds. It is estimated 5G can reduce this by 75%.
Price leadership Product differentiation
Professor Michael E. Porter added to his five-forces model by highlighting basic strategies that businesses must follow if they wish to gain competitive advantage. He stated that these strategies fell into which two separate categories?
movers
Professors Marvin B. Lieberman and David B. Montgomery of UCLA's Anderson School of Management examined the advantages and disadvantages of being the first firm to enter a product into the market. They coined this the first-__________ advantage.
be consistent: a foreign key field that references a primary key field must agree with that primary key
Referential integrity states that structural relationships in relational databases must ______.
- Append query - Delete query - Update query
Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries?
- Delete query - Append query - Update query
Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries?
Lean
Requiring a modern communications system, a process that actively encourages all employees to halt the manufacturing process if safety risks are observed is the __ process.
disruptive innovation
Sears, which revolutionized catalog (mail order) sales, failed to make the online leap and while Amazon capitalized on this technology, Amazon successfully used ___
- JIT requires exceptionally smooth supply chains. - Parts, and often even labor, are not purchased until the moment they are needed in the assembly process. - JIT faces significant challenges during supply disruptions such as those that occur during natural disasters.
Select three characteristics of just-in-time (JIT) manufacturing and inventory management.
lean
Techniques that focus on continual employee training and on developing efficient supply lines and creating relationships with suppliers to continually smooth these lines to minimize excess inventory or delays as well as to minimize waste are referred to as _______ techniques.
Six Sigma
Techniques that seek to reduce variance in output to less than 3.4 errors per 1,000,000 manufacturing steps are referred to as ___.
competitors
The ability for a firm to enjoy significant profit margins decreases as the number of _______ offering essentially the same products or services increases.
barriers
The second of Porter's 5 forces refers to the ease with which a new competitor can enter the market. Strong ________ to entry decrease the strength of this force.
software
There are a number of Cloud service vendors that provide a variety of Cloud services. Generally, Cloud computing services are classified in three ways: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and _________ as a Service (SaaS).
external threats
When external opportunities match with internal strengths, managers should choose an aggressive strategy, particularly when facing weak _________ _______.
- Your product is primarily sold in developing countries where most of your suppliers are small business owners who access the Internet via a mobile device instead of a computer. - Your company needs suppliers in all countries to be able to access your inventory database. - Turnover among telephone customer service representatives at your company is high and they receive only brief training before they interact with customers. Reps need to be able to access your sales database to assist customers who call.
Which of the following is an example of an advantage of being able to access a database via the web?
- A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database. - A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. - A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative.
Which of the following is an example of why a database should be accessible through the web?
- A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database. - A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative. - A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work.
Which of the following is an example of why a database should be accessible through the web?
- A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative. - A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. - A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database.
Which of the following is an example of why a database should be accessible through the web?
- Referential integrity applies to data quality within the structure of a relational database. - For referential integrity to exist, data on both sides of the table relationship must be present.
Which of the following statements correctly describes referential integrity?
- Analyze nonstructured data - Manage large datasets across different platforms - Create queries from the data created from web apps
Which of the following tasks are NoSQL databases designed to do?
- Predicting the impact of news on stock prices and conducting immediate transactions - Alerting online customers that the desired item is out of stock, before the order is placed - Mapping alternate driving routes to help truckers avoid bad weather and traffic jams
Which of the following tasks can businesses perform with the help of in-memory computing?
Each file is independent of another file in a traditional system.
Which statement best explains why traditional file systems have certain issues?
Databases and database management system (DBMS) with a high level of data integrity enable more efficient data maintenance in support of organizational goals.
Which statement most accurately describes the value of data integrity to an organization?
Cloud database
Which type of database maintains the hardware and operating system offsite and is accessed via Internet-based applications?
They generate vast amounts of organizational data and need to be able to rapidly analyze and interpret this information to make informed business decisions.
Why do large, data-driven companies use analytic platforms?
