MIS 4
Which of the following correctly describes a type of data mart?
-Dependent data marts extract data from a data warehouse when it is needed. -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.
Which of the following statements describe the capabilities of relational database management system (RDBMS)?
- RDBMS have features that support the quality and security of data. - RDBMS allow users to view, add, revise, and remove data.
Which of the following is an example of what an information policy could specify?
-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 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 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.
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 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.
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.
Analytic platforms are designed to ______.
quickly gather and analyze specific organizational data to provide information that guides decision making
The primary characteristic of a relational database is that it ______.
stores and allows access to data objects that are related to one another
Which of the following sets of characteristics specifically apply to relational databases?
-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 is an example of what an information policy could specify?
-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 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 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
Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS).
-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. -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.
Which statement explains the difference between a database and a database management system (DBMS)?
A DBMS is a software program designed to organize and administer databases.
For the past 10 years, a restaurant has been running a customer loyalty program, rewarding customers with discounts and treats. Records of these rewards have been kept in odd notes and multiple spreadsheets used in different ways by various employees who have come and gone over the years. Because of this, some customers are not getting their rewards, while others are receiving rewards they have not earned. Overall, the restaurant is losing money and business with this program. How can a database management system (DBMS) help with this problem?
A DBMS will help the owners manage the data they already have to run their customer loyalty program more efficiently.
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.
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 statement best summarizes how organizations use data warehouses?
Data warehouses are used to store data from multiple sources for collective analysis.
Data integrity is increased when ______.
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?
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.
Which of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?
Model building and evaluation
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.
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 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.
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
This is a screenshot of a portion of a datasheet.(Drag the correct response to the empty box) Where could you click to switch to the Design view?
View
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
Database management system (DBMS) make it easier to secure data and information because they ______.
allow for the creation of access constraints
Data integrity is increased when ______.
data are centralized
Organizations use data warehouses mainly to ______.
facilitate the analysis of data from multiple sources
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
In contrast to computerized systems, traditional file management systems can create issues with ______.
organization, repetition, and lack of consistency
The Important goals of data governance (DG) are to ______.
protect data from risk, misuse, regulatory noncompliance, and quality and cost issues
In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .
record
A relational database management system (RDBMS) is a type of DBMS whose primary function is to ______.
show how data are connected through relationships
Which of the following is a task that data administration would be responsible for?
-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. -Deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app.
