Databases Adaptive Learning

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. Reason: Correct. There is no one-size-fits-all DG plan, given the many differences between organizations' business data and how they use it.

The four steps in a data quality audit are ______.

assessment, design, transformation, and monitoring Reason: Correct. Assessing the quality of source data, designing quality processes, creating maps that correct or transform data, and checking data over a given time period are the four steps of a data audit.

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

protect data from risk, misuse, regulatory noncompliance, and quality and cost issues Reason: Correct. These goals all help to guarantee the quality, usability, and security of an organization's data.

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 Reason: Correct. The purpose of data scrubbing is to regularly detect and clean up data mistakes such as syntax errors, duplicate records, and misspellings.

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

Reason: Correct. The company's redesign of the website made it easier for consumers to buy the product they were searching for. This is an example of improved site usability.

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. Reason: Correct. DBA make sure that the database works when it is needed.

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

To monitor the database and ensure that it functions when needed Reason: Correct. DBA also fulfill this role by troubleshooting problems with the database when they occur.

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 Reason: Correct. The purpose of data scrubbing is to regularly detect and clean up data mistakes such as syntax errors, duplicate records, and misspellings.

Organizations perform data quality audits in order to ______.

gain an overall assessment of the strengths and weaknesses of their data Reason: Correct. A data quality audit will reveal the state of data quality and any actions that should be taken to improve it.

Which of the following is an example of what an information policy could specify? More than one answer may apply. Multiple select question.

-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. Reason: This answer should be selected. One function of organizational information policy is to specify the rules regarding how data will be collected and structured. -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. Reason: This answer should be selected. One function of organizational information policy is to clearly outline how data are maintained and where such data will be distributed. -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. Reason: This answer should be selected. One function of an organizational information policy is to specify the rules regarding who has access to the data.

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

Organizational data are a critical asset; it is important to ensure its security. Reason: Correct. Organizational information policies are designed to protect an organization's data by defining how the data are structured and maintained, who has access to it, and how it is distributed.

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

-A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work. Reason: This answer should be selected. An advantage of connecting to a database via the web is that users are able to access the database using their own digital devices. -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. Reason: This answer should be selected. An advantage of connecting to a database via the web is that people from different organizations can be given access to the database. -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. Reason: This answer should be selected. An advantage of connecting to a database via the web is that increasing global web connectivity means the database can be accessed throughout the world.

hich of the following is a task that data administration would be responsible for? More than one answer may apply. Multiple select question.

-Determining that two-factor identification must be used to access data that the company has determined to be confidential. Reason: This answer should be selected. Data administration is responsible for defining security policies around how data are accessed by internal and external users. -Defining policies stating that employees may not share data with people who are not employees of the organization. Reason: This answer should be selected. One of the tasks of data administration is to develop policies around how organizations use their data. -Deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app. Reason: This answer should be selected. Data planning is one of the tasks for which data administration is responsible.

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

-A subscription learning app that targets kindergarten students wants to meaningfully update its lessons so that visually impaired children can use them. Reason: This answer should be selected. Increasing accessibility is one of the ways that web mining is used to improve web experiences. -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. Reason: This answer should be selected. Given that people leave the home goods page almost immediately after they land there, a usability issue may be occurring. Improving usability is one of the ways web mining is used to improve web experiences. -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. Reason: This answer should be selected. This travel company is looking to enhance their SEO, which is one of the ways web mining is used to improve web experiences.

Which of the following is an example of an advantage of being able to access a database via the web? More than one answer may be correct.

-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. Reason: This answer should be selected. One of the advantages of being able to access a database via the web is that most users know how to operate a web browser. New reps will understand how to get to your database with minimal training, allowing the training to focus on the content of the database. -Your company needs suppliers in all countries to be able to access your inventory database. Reason: This answer should be selected. One of the advantages of being able to access a database via the web is its global reach. -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. Reason: This answer should be selected. One of the advantages of being able to access a database via the web is that it can be accessed via any device with Internet connectivity, including mobile devices.