IS-397 Midterm
improve site usability
A company's periodic web mining exercise to determine its best-selling products resulted in the discovery that a product sold in conjunction with a movie released 10 years ago has recently become coveted by nostalgia fans. The company redesigned its website so that interested consumers can purchase the product right on the homepage. This company has used web mining to ______.
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? More than one answer may be correct.
Moore's Law
Advances in technology greatly impact the capabilities of business management systems. The doubling of the number of transistors on each chip that occurs roughly every 18 months reflects the speed of this technology advance. This phenomenon is called ___ .
Business Process
All the steps required for the HR department to onboard a new employee
benefits packages
Along with their pay, HR managers often need to track employee hiring dates, marital status, number of dependents, cafeteria choices, and usage, in order to accurately manage their employees' ___ . For this reason, nearly all firms use a management system to ensure this is done correctly.
quickly gather and analyze specific organizational data to provide information that guides decision making
Analytic platforms are designed to ______.
Data Analytics
Assisting managers by examining large quantities of data and parsing it into usable information is what makes data __ software so valuable in today's business world.
It can be configured to meet the unique needs of the organization. Any changes deemed necessary can be implemented extremely quickly.
Ayala has decided to implement a new business management system. What are two advantages of hosting on-premises?
Integrated Customer Relationship Management System
Because sales are such a fundamental element of most businesses, all enterprise resource planning (ERP) systems include an
Division of labor
Breaking down a business process into its component activities so that employees can become efficient experts at that activity
A database management system (DBMS) A decision-making information system A predictive information system
Business management systems need three major components in order to provide the services expected by today's managers. These include:
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 ______.
help them make decisions that are informed by business data and facts
Businesses use business intelligence (BI) systems to ___.
Inventory Management Systems
Calculating re-ordering points and order quantity levels are key advantages of modern ___ .
Data visualization
Conveying meaning from big data analytics to managers who need to make decisions based on this data.
Processes
Every business function will have a set of business ....... to accomplish the specific goals of the function.
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? More than one answer may be correct.
Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain
For which task is a data mart more useful or appropriate than a data warehouse?
integrity
Forms structure data input to help ensure data......, meaning the information entered is accurate, timely, and useful.
Products a customer has ordered The employees who report to a specific manager in an organizational chart The courses a student is taking
From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.
A leading news website that uses data about its visitors' and followers' activities to shape its news coverage, customize news alerts, and gain advertisers and subscribers.
Given the Four V's of Big Data, which of the following organizations most likely uses Big Data?
Business Process Management
Goal of Business Process.... is to continually increase process efficiency.
Data marts focus on an individual department or business function and manage less data than a data warehouse.
How are data marts different from data warehouses?
Its use of data cubes allows users to conduct complex queries, analyses, and modeling by taking multiple dimensions of data (types or levels) into account and viewing data from multiple viewpoints or "slices" (such as by date and location).
How does the structure of an online analytical processing (OLAP) database shape its core functionality?
Smaller Businesses
Hubspot CRM, Zoho CRM, and Freshasales CRM aim to meet the needs of...... that might not use a full enterprise resource planning system
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?
Record
In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .
Gantt
In the early 20th century, Henry __ developed a horizontal bar chart that could be used to visualize a project schedule. Today, his chart is the most widely used tool in project management.
In data warehousing scenarios Where data retrieval speed is prioritized
In which of the following scenarios is denormalization beneficial?
Compensation management software
Inappropriate and inconsistent pay can demotivate the strongest workforce, for this reason, many firms use ___.
Sara, an executive with McMurtry Management, has decided that her organization needs to update its business management system. What three questions should she consider prior to choosing a system?
Is the change worth the expense and impact on employee morale? Where will the new system be housed? How will the new system interact with existing systems?
On-premises option
Jameson, a senior executive, wants significant control of his business management system so that he can implement changes to quickly adapt to the dynamic business environment. The system that would best meet these needs would be a ___ system.
Custom cloud-based Solution (PaaS or IaaS)
Jose's business management system needs to meet very unique needs. He also has a very small IT department. Which business management system should Jose adopt?
evaluation
Kronos Workforce Ready, BambooHR, PerformancePro, and others, provide packages designed to meet the employee ___ needs of smaller firms.
Business Processes
Management information systems because they can be used to communicate, coordinate, and monitor business activities, can be indispensable when it comes to using...
Activities
Managers and management information systems can begin the process of increasing process efficiency by breaking each business process into its constituent ___.
Process Management Development
Managers are able to visualize the entire process and see how each activity interacts with other activities and the business process itself during
Employee process software
Many states require significant documentation of substandard performance prior to any employee demotion or dismissal, while an equitable means of ranking performance can serve as a strong motivator. For this reason, many managers use employee.... software to efficiently meet these needs.
Business process management
Mapping and analyzing business processes allows managers to gain control over unwiedly and often chaotic processes, allowing them to focus on creating efficiencies. This is part of...
Power BI matches Microsoft Looker matches Google Tableau matches Salesforce
Match the data analytics software platform with its parent company.
data normalization
Organizing data so that data are in simple tables without any redundancies is known as __________.
Examining the design of the process Modeling the Process Running the process Monitoring the process Initiating process improvements
Place the 5 steps of business process management (BPM) in order with the first step at the top.
TVM (Time Value of Money)
Principle that states that a dollar in your hand today is worth more than a dollar you will receive in the future because a dollar in hand today can be invested to turn into more money in the future.
Activity
Process comprises the entirety of what an organization accomplishes in order to deliver a product. A specific step in a business process is called an...
Business Process Modeling Notation (BPMN)
Providing a concise graphical depiction for documenting business processes... often involves the use of flowcharts
Customer Relationship Management (CRM)
Salesforce remains one of the largest suppliers of... software solutions
Modeling
Second step in business process management, analysts use flow-charts to depict workflow and the sequence of operations and decision points.
Data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area. Data warehouses are used to analyze long-term, historical data for an organization's strategic purposes, because they store data from different time periods and subject areas.
Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS).
Tableau by Salesforce Oracle Analytics Cloud SAP Analytics Cloud
Select three major data analytics software platforms.
A meeting with project stakeholders is convened allowing these key players to review the Gantt chart and the project timeline. A Gantt chart is created or fine-tuned if one was started during the feasibility study.
Select two objectives that might typically be accomplished during the planning phase (the second stage) of the project management process.
Universal Product Codes (UPC) Radio Frequency Identification (RFID)
Select two technologies that advanced the efficiency of inventory management systems.
Oval Arrow Rectangle Diamond
Shows the projects beginning and ending points Indicates the directional progress of the flowchart Indicates an activity in the process Represents decision points and typically hold questions
custom Cloud-based solution (PaaS or IaaS)
Skyler, an executive, wants to implement a business management system that can be quickly scaled as he anticipates rapidly changing database storage needs. He likes his uniquely developed current system but wants increased security from hackers while decreasing his need for a large IT department. Skyler should choose a ___
Data Management System
The 3 main components of a business management system include a decision-making information system, a predictive information system, and a ___.
stores and allows access to data objects that are related to one another
The primary characteristic of a relational database is that it ______.
Intelligence
The software and processes that allow organizations to capitalize on the power of big data and predictive analytics is referred to as business....
Resource
The strategic use of employees to allow organizations to operate efficiently and gain competitive advantage is referred to as human..... management
Big data analytics
The technology and processes used to gain intelligent, usable information from databases.
Visualization tools
These display information in a manner that make it easier for managers to assimilate or to see patterns.
Data mining
This accesses external databases as well as data that the firm has collected itself (internal data).
Predictive analytics
This uses algorithms to determine the most likely outcomes given a set of inputs.
Business intelligence (BI)
This uses data mining techniques combines and then adds data visualization tools so that managers can make faster, more informed, decisions.
Reports
To display or distribute information from a database, programmers or database administrators create ___.
Efficient at accessing a subset of columns Scalable across large clusters Beneficial for data compression
What are the advantages of using column-oriented databases?
Access level Perimeter level Database level
What are the primary layers of database security?
Activities are examined and divided into their individual components.
What is conducted in the process design step of business process management?
The business process execution language engine is run.
What is conducted in the process execution step of business process management?
Answer questions about the database
What is the purpose of an SQL statement?
Managers track the individual components of the process as well as the process as a whole so that the performance of the engine can be measured.
What occurs during the process monitoring step of business process management?
Firewalls VPNs
What security measures are commonly used at the perimeter level of database security?
Software-as-a-Service (SaaS) Option
When implementing a new business management system, which option provides managers with lowest initial start-up expenses.
employees will be less anxious if they are somewhat familiar with the system already using a system that employees are used to will probably reduce training time
When selecting an inventory management solution, two reasons managers should opt for a system that integrates easily with existing business management software are ___ and ___.
Normalization
Which database design strategy is likely to be used where transaction integrity is critical?
Frequent backup of data Continual monitoring of database performance Implementation of security measures like encryption
Which of the following are considered best practices for database administration?
Monitoring and adjusting storage parameters Fine-tuning queries and indexing strategies Regularly updating and patching database software
Which of the following are methods database administrators use to optimize database performance?
Defining data Querying data Manipulating data
Which of the following are primary functions of SQL in database management?
Avoid anomalies during database operations. Reduce data redundancy. Maintain data consistency.
Which of the following are primary goals of database normalization?
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? More than one answer may be correct.
The data are measured in terabytes (trillions of bytes) or even larger units. The data are from structured and unstructured sources and exist in multiple forms.
Which of the following statements correctly describes a defining characteristic of Big Data? More than one answer may be correct.
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? More than one answer may be correct.
RDBMS allow users to view, add, revise, and remove data. RDBMS have features that support the quality and security of data.
Which of the following statements describe the capabilities of relational database management system (RDBMS)? More than one answer may be correct.
Create queries from the data created from web apps Manage large datasets across different platforms Analyze nonstructured data
Which of the following tasks are NoSQL databases designed to do? More than one answer may be correct.
Alerting online customers that the desired item is out of stock, before the order is placed Predicting the impact of news on stock prices and conducting immediate transactions 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? More than one answer may be correct.
An e-commerce business looking to improve the customer experience on its website to boost sales wants to know what types of sites users go to after visiting their website and putting items in their cart, but not completing a purchase. A new social media platform wants to increase engagement and is looking to know what content its most frequent users spend the most time engaging with.
Which of the following would be a reason why an organization would use web usage mining? More than one answer may be correct.
Each file is independent of another file in a traditional system.
Which statement best explains why traditional file systems have certain issues?
Data warehouses are used to store data from multiple sources for collective analysis.
Which statement best summarizes how organizations use data warehouses?
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)?
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?
Antivirus software
Which tool is not typically used in a zero-trust security approach?
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?
It allows users to view data from different perspectives or angles and gain new insights. It allows reports and analytics to be exported to more user-friendly, front-end tools. It allows for sophisticated data and trend analysis, data modeling, and forecasting.
Why is online analytical processing (OLAP) software included in many business intelligence (BI) software applications? More than one answer may be correct.
Requirement for scalability across distributed systems Demand for rapid querying of large volumes of data
Why might a company choose a NoSQL database over a relational database?
Veracity
A leading manufacturer of fitness trackers partners with a large health insurance network. Insurance network members receive a discounted fitness tracker and financial rewards for setting and achieving tracked personal fitness goals. Which characteristic of the resulting Big Data would be most directly affected by a tracker software error that counted users' arm movements as steps?
Storage size can be quickly scaled to meet changing needs Reduces the need for a large IT staff More secure from hackers
Emerson has decided to implement a new business management system. What are three advantages of choosing a cloud-based custom option such as a platform as a service (PaaS) or an infrastructure as a service (IaaS) system, over an on-premises option?
Hybrid data marts combine data from a data warehouse and other collection systems. Dependent data marts extract data from a data warehouse when it is needed. Independent data marts are separate from a data warehouse and are created in order to collect data relating only to particular business functions.
Which of the following correctly describes a type of data mart? More than one answer may be correct.
Healthcare for patient data analysis and reporting Finance for handling and analyzing large data sets Marketing to analyze sales and advertising success
Which of the following correctly identify how SQL is used in different industries?
The likelihood of a Gen-X female who makes $50,000 and is divorced with no children will take a trip within a year of her divorce being finalized Middle-aged males who are members of their local church bible study group are more inclined to vote than younger males who are also members of local bible study groups.
Which of the following is an example of the type of information data mining can yield? More than one answer may be correct.
