Question 1

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called

Accepted Answer

Data scrubbing is the process of identifying and correcting inaccurate, incomplete, improperly formatted, or redundant data in a database or file. It is also known as data cleansing or data cleaning. The other options are not relevant to this process.

Question 2

The policies and processes for managing the integrity and security of data in a firm are referred to as data governance.

Accepted Answer

This statement is true. Data governance encompasses the policies and procedures put in place to ensure the accuracy, consistency, and security of an organization's data assets.

Question 3

Data scrubbing is a more intensive corrective process than data cleansing.

Accepted Answer

The answer of Data scrubbing is a more intensive corrective...

Question 4

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Accepted Answer

This scenario illustrates the challenge of data inconsistency, as the person's name is not consistently recorded in the database, resulting in multiple variations of the same name being used for the same person and causing duplication or errors in the mailing list.

Question 5

What are the differences between data mining and OLAP? When would you advise a company to use OLAP?

Accepted Answer

The answer of What are the differences between data mining...

Question 6

Which of the following is not a method for performing a data quality audit?

Accepted Answer

The answer of Which of the following is not a...

Question 7

The organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n)

Accepted Answer

An information policy outlines the rules and guidelines for managing and handling information within an organization, including sharing, disseminating, acquiring, standardizing, classifying, and inventorying information.

Question 8

The organizational function that is in charge of policies and procedures for managing internal data resources is called data administration.

Accepted Answer

Data administration is the organizational function that is responsible for managing internal data resources, including policies and procedures for data management, data quality, data security, and data governance.

Question 9

Data cleansing not only corrects errors but also

Accepted Answer

The answer of Data cleansing not only corrects errors but...

Question 10

The special organizational function whose responsibilities include physical database design and maintenance is called

Accepted Answer

The responsibilities of physical database design and maintenance fall under the domain of database administration. Data administration is a broader term that encompasses all aspects of managing an organization's data, including strategic planning and policy development. Information policy administration refers to the development and enforcement of policies related to information management within an organization. Data auditing involves conducting regular assessments of data quality and ensuring compliance with relevant regulations. Database management refers to the overall management of an organization's databases, including planning, design, implementation, and maintenance.

Quiz 6: Foundations of Business Intelligence: Databases and Information Management