Chapter 7

Which of the following is an example of why a database should be accessible through the web?

-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. -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 improvements might be the direct outcome of a data quality audit?

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

Which of the following is an example of an advantage of being able to access a database via the web?

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

Data mining is best described as ______.

A research and analysis technique AI to search large volumes of data and discover less-obvious patterns and trends

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

Model building and evaulation

Which of the following would be a reason why an organization would use web usage mining?

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

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

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.

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

Which statement best summarizes how organizations use data warehouses?

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

Which of the following correctly describes a type of data mart? More than one answer may be correct.

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 -Hybrid data marts combine data from a warehouse and other collection systems

Businesses use business intelligence (BI) systems to ___. Multiple choice question.

Help them make decisions that are informed by business data and facts

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.

which of the following is an example of a web experience that could be improved by web mining

To monitor the database and ensure that it functions when needed

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

-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. -It allows users to view data from different perspectives or angles and gain new insights

Which of the following tasks can businesses perform with the help of in-memory computing? More than one answer may be correct. Multiple select question.

-Predicting the impact of news on stock prices and conducting immediate transactions -Mapping alternative driving routes to help tucker avoid bad weather and traffic jams -altering online customers that the desired item us out if stock, before the order is placed

Which of the following statements correctly describes a defining characteristic of Big Data?

-The data are from structured and unstructured sources and exist in multiple forms. -The data are measured in terabytes (trillions of bytes) or even larger units.

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

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? Multiple choice question.

Web usage mining

Which of the following is a task that data administration would be responsible for?

-Deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app. -Determining that two-factor identification must be used to access data that the company has determined to be confidential. -Defining policies stating that employees may not share data with people who are not employees of the organization. incorrect

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 ______. Multiple choice question.

Improve site usability -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. -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.

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

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

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

It uses of data cubes allows users to conduct complex quires, analyses, and modeling by taking multiple dimensions of data ... into account na dviewing data from multiple viewpoints or slices

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.

Which of the following is an example of what an information policy could specify?

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

Which of the following is an example of a web experience that could be improved by web mining?

-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. -A subscription learning app that targets kindergarten students wants to meaningfully update its lessons so that visually impaired children can use them. -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.