Question 1

Which of the following has (have)the broadest impact on an organization?
A)Decisions about hardware.
B)Decisions about software.
C)Decisions about data.
D)Both "decisions about hardware" and "decisions about software."
E)All of these have an equal impact.

Accepted Answer

Decisions about data have the broadest impact on an organization because data is the foundation of any information system and is used to make important business decisions. Hardware and software decisions are important, but their impact is primarily limited to the technical capabilities of the system.

Question 2

Master data are generated and captured by operational systems.

Accepted Answer

Master data refers to the core data within an organization that is essential to its operations and is typically non-transactional in nature, such as data about customers, products, employees, materials, suppliers, etc. It is not generated or captured by operational systems but rather managed and stored centrally to ensure consistency and accuracy across the organization. Operational systems may use and contribute to the refinement of master data, but they primarily deal with transactional data.

Question 3

Refer to Case 5.1 Data Problems at Target Canada. In order for SAP ERP system to work properly, data needs to be:
A)accurate.
B)managed properly.
C)contain RFID information.
D)reenginered.
E)All of the above.

Accepted Answer

The answer of Refer to Case 5.1 Data Problems at...

Question 4

In a data warehouse, existing data are constantly purged as new data come in.

Accepted Answer

In a data warehouse, existing data is not constantly purged as new data come in. Instead, the data is stored and maintained for analysis and reporting purposes. Purging may happen in cases of data aging or if the data is no longer relevant or useful for analysis.

Question 5

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Accepted Answer

Normalization involves organizing data to reduce redundancy and improve data integrity by ensuring that each attribute within a table is dependent only on the primary key.

Question 6

Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements.

Accepted Answer

Structured query language (SQL) is a relational database language that allows users to perform complex searches with simple statements.

Question 7

Tacit knowledge is the more objective, rational, and technical types of knowledge.

Accepted Answer

Tacit knowledge refers to the subjective and experiential knowledge that is difficult to articulate or codify, such as intuition, skills, insights, and personal beliefs. Explicit knowledge, on the other hand, is the more objective, rational, and technical types of knowledge that can be easily transmitted through language, symbols, or media.

Question 8

The data dictionary stores definitions of data elements, business functions that use the data elements, formats of the data elements, information on each attribute of an element and how the attribute should be updated.

Accepted Answer

The statement accurately describes the purpose and contents of a data dictionary.

Question 9

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way. They are sharing their tacit knowledge.

Accepted Answer

This is because tacit knowledge represents an individual's internalized knowledge that is often difficult to articulate or communicate to others, but can be shared through observation and explanation.

Question 10

A data mart can be implemented more quickly than a data warehouse.

Accepted Answer

A data mart is a subset of a data warehouse that focuses on a specific business area or department. As such, it typically requires less data and can be implemented more quickly than a full data warehouse.

Question 11

Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

Accepted Answer

The statement is incorrect. Explicit knowledge refers to knowledge that is formalized and codified, typically documented and easily communicated. It involves information that is easily transferable and shareable among individuals and organizations, such as facts, procedures and rules.

Question 12

It is difficult to manage data. For example, it is common for customers to move and for companies to go out of business. This is an example of ___________.
A)Data degradation
B)Data rot
C)Data security
D)Scattered data

Accepted Answer

Data degradation refers to the deterioration of data quality over time due to various factors such as data duplication, inaccurate data entry, and data obsolescence. In the case given, customers moving and companies going out of business are examples of data obsolescence, where the data becomes outdated or irrelevant.

Question 13

Knowledge is information in action.

Accepted Answer

Knowledge involves the application of information to solve problems or achieve goals, thus making it information in action.

Question 14

An organization's data warehouse generally maintains its operational data.

Accepted Answer

An organization's data warehouse does not usually maintain its operational data. Instead, it stores historical data and provides a consolidated view of data from different sources for analytical purposes. Operational data is usually stored in the organization's transactional databases.

Question 15

Which of the following is NOT a problem with Big Data?
A)Gathering data
B)Privacy
C)Security
D)Decision-making

Accepted Answer

Gathering data is generally not considered a problem with Big Data; the challenge lies more in managing, analyzing, and ensuring the privacy and security of the data.

Question 16

A data mart is a low-cost, scaled-down version of a data warehouse.

Accepted Answer

A data mart is a subset of a data warehouse that focuses on a specific business function or line of business. It is designed for a specific user group or department and typically contains a smaller amount of data. Therefore, it is a scaled-down version of a data warehouse with lower cost of implementation and maintenance.

Question 17

When you start a job, you are given an employee handbook which contains the company's tacit knowledge.

Accepted Answer

Tacit knowledge is the know-how or skills that employees have which are not documented, whereas an employee handbook typically contains explicit knowledge, which is documented information such as company policies and procedures.

Question 18

Which of the following is not a source for external data?
A)Commercial databases
B)Corporate databases
C)Corporate websites
D)Clickstream data
E)Government reports

Accepted Answer

Corporate databases belong to the company itself and are therefore not considered external sources of data. Commercial databases, government reports, and clickstream data are all examples of external data sources. While corporate websites may be owned by the company, they often contain information that is available to the public and can be considered an external source of data.

Question 19

Online analytical processing (OLAP)involves the analysis of accumulated data by end users.

Accepted Answer

OLAP is a technique used for analyzing large amounts of data from different perspectives. It allows end users to perform multidimensional analysis of data, which helps them gain insights into business trends, relationships, and patterns. OLAP is frequently used in business intelligence (BI) applications to support decision-making processes.

Question 20

Data marts are designed for the end-user needs in a strategic business unit or department.

Accepted Answer

Data marts are focused on specific business units or departments and are designed to meet their unique analytical needs. They are a subset of a larger data warehouse and typically contain a smaller amount of data that is more relevant to the department's specific goals and objectives.

Quiz 5: Data and Knowledge Management

Which of the following has (have) the broadest impact on an organization?