Business Info Systems Exam 2 (MIS-3,8,6,7)

Which of the following is an example of why a database should be accessible through the web? (More than one answer)

1.) A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. 2.) 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. 3.) 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.

Select two objectives that might typically be accomplished during the planning phase (the second stage) of the project management process.

1.) A meeting with project stakeholders is convened allowing these key players to review the Gantt chart and the project timeline. 2.) A Gantt chart is created or fine-tuned if one was started during the feasibility study.

Business management systems need three major components in order to provide the services expected by today's managers. These include:

1.) A predictive information system 2.) A decision-making information system 3.) A database management system (DBMS)

Select three objectives that might typically be accomplished during the initiation phase (the first stage) of the project management process.

1.) A projected timeline for deliverables is developed. 2.) A statement of work or other working agreement is created. 3.) Stakeholders in the project are identified.

Which of the following is an example of a web experience that could be improved by web mining? (More than one answer)

1.) A travel company wants to know what amenities people search for before booking a hotel for a vacation so that the company can increase the coverage of those amenities on their website. 2.) A small online retailer has noticed that most people viewing products from its gaming pages browse for about 5 minutes and end up making purchases, but over 75 percent of people viewing products from its home goods pages leave within the first 30 seconds. It wants information on how the two pages are different. 3.) A subscription learning app that targets kindergarten students wants to meaningfully update its lessons so that visually impaired children can use them.

Which of the following is an example of what an information policy could specify? (More than one answer)

1.) A user agreement on a website indicates that it will store the browsing history linked to the IP address for an indefinite amount of time and reserves the right to sell that information to interested parties. 2.) A large corporation grants access to salary information to the direct supervisors of employees and to members of the Human Resources department who administer payroll. 3.) A health insurance company stores data that patients self-report as inputs on its website, but does not link that data with information about the patient's search history.

Which of the following are examples of data objects that a relational database management system (RDBMS) may include? (More than one answer)

1.) Addresses of the company's wholesalers and the number of items in a company's inventory 2.) Names of customers and records of when merchandise was returned

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? (More than one answer)

1.) Append query 2.) Delete query 3.) Update query

Which of the following are advantages of cloud databases over a traditional database? (More than one answer)

1.) Are maintained by an external provider, such as Amazon or Oracle 2.) Can support both SQL and NoSQL databases 3.) Can be accessed through an application programming interface (API)

Which of the following tasks are NoSQL databases designed to do? (More than one answer)

1.) Create queries from the data created from web apps 2.) Analyze nonstructured data 3.) Manage large datasets across different platforms

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)

1.) Crosstab queries 2.) SQL specific queries 3.) Action queries

Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS).

1.) 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. 2.) 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.

Which of the following sets of characteristics specifically apply to relational databases? (More than one answer)

1.) Data tables in a relational database are linked by the fields they have in common. 2.) A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns).

Which of the following correctly describes a type of data mart? (More than one answer)

1.) Dependent data marts extract data from a data warehouse when it is needed. 2.) Hybrid data marts combine data from a data warehouse and other collection systems. 3.) 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 improvements might be the direct outcome of a data quality audit? (More than one answer)

1.) Elimination of redundant metadata and strengthened referential integrity 2.) Recommendations for a new data management design and prescriptions for preserving data quality 3.) Corrections in source data issues and ways to examine data over time

Select 3 activities that typically fall under the purview of an HR manager.

1.) Fraternization policies 2.) Dress policies 3.) Employment agreements

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?

1.) Is the change worth the expense and impact on employee morale? 2.) Where will the new system be housed? 3.) How will the new system interact with existing systems?

Why is online analytical processing (OLAP) software included in many business intelligence (BI) software applications? (More than one answer)

1.) It allows users to view data from different perspectives or angles and gain new insights. 2.) It allows for sophisticated data and trend analysis, data modeling, and forecasting. 3.) It allows reports and analytics to be exported to more user-friendly, front-end tools.

Ayala has decided to implement a new business management system. What are two advantages of hosting on-premises?

1.) It can be configured to meet the unique needs of the organization. 2.) Any changes deemed necessary can be implemented extremely quickly.

Jim, an HR director, does not want to change business management systems, even though it brings several advantages and falls within his department budget. What are two reasons why Jim might not want to make the change? (More than one answer)

1.) Jim believes changing to the new system will cause a decrease in productivity, at least in the short-term. 2.) Jim believes the change will create employee stress as they are required to adapt to a new system.

Select three objectives that might typically be accomplished during the closure phase (the last stage) of the project management process.

1.) Managers document the lessons they learned during the project's execution. 2.) Stakeholders discuss how closely the project met expectations. 3.) All associated contracts are ended.

Which of the following is an example of the type of information data mining can yield? (More than one answer)

1.) 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. 2.) 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

Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings?

1.) Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues. 2.) An in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for falling in their homes.

Which of the following tasks can businesses perform with the help of in-memory computing? (More than one answer)

1.) Predicting the impact of news on stock prices and conducting immediate transactions 2.) Alerting online customers that the desired item is out of stock, before the order is placed 3.) Mapping alternate driving routes to help truckers avoid bad weather and traffic jams

Select three popular inventory management systems.

1.) QuickBooks Enterprise 2.) SAP Material Management (SAP MM) 3.) Oracle NetSuite

Select three methods businesses use to house a business management system.

1.) SaaS solution 2.) Customized, cloud-based solution (PaaS or IaaS) 3.) On-premises custom solution

Select three common features of modern data visualization tools that accompany most business intelligence (BI) systems.

1.) Scroll-over features 2.) Search capabilities 3.) Dashboard presentation

Which of the following is an example of an advantage of being able to access a database via the web? (More than one answer)

1.) 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. 2.) Your company needs suppliers in all countries to be able to access your inventory database. 3.) 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.

Given the Four V's of Big Data, which of the following organizations most likely uses Big Data?

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.

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.

Analytics

What is the purpose of an SQL statement?

Answer questions about the database

The technology and processes used to gain intelligent, usable information from applicable databases across the Internet is referred to as ___ .

Big data analytics

Which type of database maintains the hardware and operating system offsite and is accessed via Internet-based applications?

Cloud database

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?

Custom cloud-based Solution (PaaS or IaaS)

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

How are data marts different from data warehouses?

Data marts focus on an individual department or business function and manage less data than a data warehouse.

What term describes the process organizations use to discover meaningful relationships and patterns among the data sets it has collected?

Data mining

Brooks Accounting is no stranger to audits—for their customers. Managers discovered some issues in services and billing they suspected were linked to their database practices rather than to employee competence. Brooks hired an outside firm to perform a data quality audit. Which statement best describes how the audit process identified problems?

Data profiling analyzed the accounting firm's data sources.

Which statement best summarizes how organizations use data warehouses?

Data warehouses are used to store data from multiple sources for collective analysis.

Which statement most accurately describes the value of data integrity to an organization?

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 best explains why traditional file systems have certain issues?

Each file is independent of another file in a traditional system.

Tracking the performance of employees will always be a critical component of management for this reason, most firms use ___.

Employee Evaluation Software

The third step in business process management provides managers with real-time (executable) decision making as well as the ability to play the "what-if" game by changing input variables (abstract) decision making. This is called the process __ step.

Execution

Which of the following is a tool commonly used by project managers?

Gantt chart (a horizontal bar chart that could be used to visualize a project schedule)

How does the structure of an online analytical processing (OLAP) database shape its core functionality?

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).

Which of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?

Model building and evaluation

The doubling of the number of transistors on each chip that occurs roughly every 18 months means that computer capability, and the corresponding software, also improve rapidly. This phenomenon is called _____ Law .

Moore's

Why is it important for all organizations, no matter how small, to create and implement organizational information policies?

Organizational data are a critical asset; it is important to ensure its security.

When using a flowchart as part of business process modeling notation, a ___ shows the project's beginning and ending points.

Oval

The 3rd step in business process management provides managers the ability to play the "what-if" game by changing input variables (abstract) decision making. This is the ___ step

Process Execution

The 2nd step of BPM involves the use of flow-charts and other tools to examine decision points and inputs. This step is called:

Process Modeling

For which task is a data mart more useful or appropriate than a data warehouse?

Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain

Which of the following is a task that an SQL statement would be expected to perform?

Retrieve data

When implementing a new business management system, which option provides managers with lowest initial start-up expenses.

Software-as-a-Service (SaaS) Option

A DBMS maximizes the benefits a database can provide. DBMS stands for Database Management ____.

System

Flowcharts are often used in business process modeling notation (BPMN), to provide a concise graphical depiction for documenting business processes. Match the flowchart symbol with its typical use. The Oval --> ______ The Arrow --> ______ The Rectangle --> ______ The Diamond --> ______

The Oval --> Shows the project's beginning and ending points. The Arrow --> Indicates the directional progress of the flowchart. The Rectangle --> Indicates an activity in the process The Diamond --> Represents decision points and typically hold questions.

Which statement best summarizes the primary advantages of performing a data quality audit?

The audit recommends ways the organization can improve its data quality and reduce costs through increasing data consistency.

What is conducted in the process execution step of business process management?

The business process execution language engine is run.

A mid-sized independent hardware store has recently merged with a large national chain. The local owners have long used a reliable database to manage inventory. Their database has been essential in balancing orders for seasonal merchandise with the problem of limited shelf space. The merger will soon entail managing many more types of data, as the national chain has approved lists of suppliers, precise requirements for recording transactions, specific human resources procedures, and more. Which statement best summarizes what the local managers will be able to do for the first time when they start using the parent company's database management system (DBMS)?

The managers will be able to create, edit, and store data in a secure manner across all data types required by the parent company.

Which statement best summarizes how a data governance (DG) plan is created?

The plan is tailored to the organization's specific goals, objectives, and activities.

Why do large, data-driven companies use analytic platforms?

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 must database administrators (DBA) be trained or experienced in using an organization's specific database platform?

They must troubleshoot or solve problems with the database when necessary.

What is the primary role of a database administrator (DBA)?

To monitor the database and ensure that it functions when needed

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?

Veracity

A corporate sales organization is hosting its annual regional meeting. It needs to book a hotel within the region where attendees will stay for three days and two nights. The hotel must have: 30 standard hotel rooms for its sales reps, 5 suites for the regional managers, and 5 conference rooms to hold training sessions. There also must be two restaurants within walking distance of the hotel that can accommodate a dinner reservation for 40 people. Which web mining technique would the organization use to narrow down the choices of hotels to those that fit these parameters?

Web content mining

Data mining is best described as ______.

a research and analysis technique in which data analysts employ mathematical tools and artificial intelligence (AI) to search large volumes of data and discover less-obvious patterns and trends

The four steps in a data quality audit are ______.

assessment, design, transformation, and monitoring

Referential integrity states that structural relationships in relational databases must ______.

be consistent: a foreign key field that references a primary key field must agree with that primary key

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.

benefits packages

Many managers, particularly in smaller firms, use companies such as Zenefits and BenefitFocus to manage their employees' ___.

benefits systems

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 ___

custom Cloud-based solution (PaaS or IaaS)

Establishing how an organization manages its data and making sure the organization adheres to these methods is a function called ______.

data administration

Data integrity is increased when ______.

data are centralized

Organizing data so that data are in simple tables without any redundancies is known as __________.

data normalization

The practice of data scrubbing is a vital part of data quality management because it ______.

ensures ongoing data validity by identifying and then fixing data errors

The 3rd stage of the project management (PM) process, in which managers constantly monitor the progress of the project and the project's resources. is the ___ phase.

execution

Organizations use data warehouses mainly to ______.

facilitate the analysis of data from multiple sources

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.

forms

Organizations perform data quality audits in order to ______.

gain an overall assessment of the strengths and weaknesses of their data

The primary purpose of a business intelligence (BI) system is to ______.

help a business make strategic decisions based on its own data

A database management system (DBMS) is a computer program that is used to ______.

help organize the data found in a database

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 ______.

improve site usability

Forms structure data input to help ensure data ____ , meaning the information entered is accurate, timely, and useful.

integrety

Businesses can use in-memory computing to conduct or support almost any task that ______.

involves the near-instantaneous processing and analysis of huge volumes of data

Providing a concise graphical depiction for documenting business processes, business process _____ notation (BPMN) often involves the use of flowcharts.

modeling

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.

on-premises option

The fifth and final step in business process management has managers adapting the process to enhance process performance. This is called the process ____.

optimization

In contrast to computerized systems, traditional file management systems can create issues with ______.

organization, repetition, and lack of consistency

During the second stage of the project management (PM) process, a Gantt chart is created, or fine-tuned if one was started during the feasibility study. This is called the ____ phase.

planning

The 2nd stage of the project management (PM) process, which involves meetings with project stakeholders is the ___ phase.

planning

The Important goals of data governance (DG) are to ______.

protect data from risk, misuse, regulatory noncompliance, and quality and cost issues

To search a database for information, create a ___.

query

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ___.

record

A link between tables in a relational database that defines how the data are related is called a _____.

relationship

Forms allow data to go into a database, ___ displays information coming out of a database.

reports

To display or distribute information from a database, programmers or database administrators create ___.

reports

The best way of implementing a new BI system is to make it as seamless as possible by using ___.

software with which the users (typically first line employees, supervisors, and junior management) are already familiar

The primary characteristic of a relational database is that it ______.

stores and allows access to data objects that are related to one another