MIS CH 2
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.
Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings?
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. Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues.
Which of the following are advantages of cloud databases over a traditional database
Are maintained by an external provider, such as Amazon or Oracle Can support both SQL and NoSQL databases Can be accessed through an application programming interface (API)
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?
Big data
Which type of database maintains the hardware and operating system offsite and is accessed via Internet-based applications?
Cloud database
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 of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?
Model building and evaluation
Which of the following is a task that an SQL statement would be expected to perform?
Retrieve data
From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.
The courses a student is taking Products a customer has ordered The employees who report to a specific manager in an organizational chart
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
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
Organizations often use data scrubbing software because it ______.
automatically analyzes data, then fixes any errors, and consistently formats the data according to an organization's guidelines
Establishing how an organization manages its data and making sure the organization adheres to these methods is a function called ______.
data administration
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
Organizations use data warehouses mainly to ______.
facilitate the analysis of data from multiple sources
The primary purpose of a business intelligence (BI) system is to ______.
help a business make strategic decisions based on its own data
Businesses use business intelligence (BI) systems to
help them make decisions that are informed by business data and facts
Forms structure data input to help ensure data _______ , meaning the information entered is accurate, timely, and useful.
integrity
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
To search a database for information, create a ___.
query
Which of the following correctly describes a type of data mart?
~Hybrid data marts combine data from a data warehouse and other collection systems. ~Independent data marts are separate from a data warehouse and are created in order to collect data relating only to particular business functions. ~Dependent data marts extract data from a data warehouse when it is needed.
Which of the following tasks can businesses perform with the help of in-memory computing?
~ Mapping alternate driving routes to help truckers avoid bad weather and traffic jams ~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
How is information artfully extracted from a database?
reports
To display or distribute information from a database, programmers or database administrators create ___.
reports
They must troubleshoot or solve problems with the database when necessary.
~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. ~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 improvements might be the direct outcome of a data quality audit?
~Elimination of redundant metadata and strengthened referential integrity ~Recommendations for a new data management design and prescriptions for preserving data quality ~Corrections in source data issues and ways to examine data over time
Which of the following statements correctly describes referential integrity?
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.
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
Organizing data so that data are in simple tables without any redundancies is known as __________.
data normalization
A link between tables in a relational database that defines how the data are related is called a _____.
relationship
Which of the following tasks can businesses perform with the help of in-memory computing?
~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
