Question 1

Data validation helps to ensure that every data value is correct and accurate.In Microsoft Word, you can use data validation to control the type of data or the values that users enter into a cell.

Accepted Answer

Data validation is a feature typically found in spreadsheet applications like Microsoft Excel, not in Microsoft Word, which is primarily a word processing application.

Question 2

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Accepted Answer

This statement correctly defines a data gap analysis.

Question 3

Consistent information asks if the aggregate or summary information is in agreement with detailed information.

Accepted Answer

Consistent information means that the summary or aggregate information matches the detailed information, so they are in agreement.

Question 4

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Accepted Answer

Ensuring that the total columns reflect the true total of the individual items is an important characteristic of accurate and reliable information, which is a hallmark of high-quality information. Therefore, the statement is true.

Question 5

Data validation includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Accepted Answer

Data validation is an important aspect of data governance that involves testing and evaluating data to ensure that it complies with policies and standards and is correct. Therefore, the statement is true.

Question 6

Determining if there are any duplicate customers in the data is an example of a unique characteristic of high-quality information.

Accepted Answer

Ensuring data accuracy and consistency is an important aspect of high-quality information, and identifying and removing duplicate entries is one way to achieve this.

Question 7

Identity management is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems.

Accepted Answer

Identity management primarily focuses on managing user identities, including authentication, authorization, roles, and privileges within or across system and enterprise boundaries. It does not primarily focus on gathering data or ensuring data uniformity across entities like customers, suppliers, etc., which is more related to data management or master data management practices.

Question 8

A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Accepted Answer

A data steward is indeed responsible for ensuring the policies and procedures related to data management are implemented across the organization, and they also function as a communicator between the MIS department and the business.

Question 9

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Accepted Answer

Data stewardship involves managing and overseeing an organization's data assets to ensure that they are of high quality and easily accessible to business users in a consistent manner.

Question 10

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Accepted Answer

Spelling accuracy is an important aspect of high-quality information, as it ensures that the information is reliable and credible. Incorrect spelling can lead to misunderstandings or even misinformation.

Question 11

Unique information asks if the information is current with respect to the business needs.

Accepted Answer

Unique information refers to data that is distinct and not duplicated elsewhere, rather than its currency or relevance to current business needs.

Question 12

Consistent information asks if there is a value missing from the information.

Accepted Answer

Consistent information refers to whether the information provided does not contain contradictions and aligns with itself, not necessarily to whether a value is missing.

Question 13

Determining if information is updated weekly, daily, or hourly is an example of an accurate characteristic of high-quality information.

Accepted Answer

This is true. The frequency of updates is an important factor in determining the quality and reliability of information. Updated information is more likely to be accurate and relevant.

Question 14

Complete information asks if there is an incorrect value in the information.

Accepted Answer

Complete information refers to a situation where all participants have full and identical knowledge relevant to a decision or situation, not about the correctness of values.

Question 15

Unique information asks if each transaction and event is represented only once in the information.

Accepted Answer

Unique information means that each transaction and event is represented only once in the information, therefore the statement is true.

Question 16

Accurate information asks if the aggregate or summary information is in agreement with detailed information.

Accepted Answer

The answer of Accurate information asks if the aggregate or...

Question 17

Timely information asks if each transaction and event is represented only once in the information.

Accepted Answer

Timely information refers to the promptness of information being available and accessible in time for decision-making, not to the uniqueness or singleness of transaction representation.

Question 18

Data latency includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Accepted Answer

Data latency refers to the time delay between the generation of data and its availability for use. It does not specifically refer to compliance tests for data governance policies.

Question 19

Complete information asks if there is a value missing from the information.

Accepted Answer

Complete information will have all the necessary values and there will not be any missing values.

Question 20

Timely information asks if the information is current with respect to the business needs.

Accepted Answer

Timely information is information that is current and up-to-date with respect to the business needs. This ensures that the information is relevant and can be used effectively in making business decisions.

Quiz 6: Valuing and Storing Organizational Information Databases