Question 1

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

Accepted Answer

Online analytical processing (OLAP) is a technology that allows users to analyze large amounts of data from multiple perspectives quickly. It is designed to support multidimensional analysis of complex data sets, enabling end users to gain insight into organizational trends and interactively explore data from different angles. OLAP tools are used to perform complex calculations, generate summary reports, and produce interactive visualizations, making it an essential tool for business intelligence and data analytics.

Question 2

The management of data across the entire organization is most accurately defined as:
A) Data integration.
B) Data control.
C) Data governance.
D) Data administration.

Accepted Answer

Data governance involves the management of data throughout the entire organization, including the policies, procedures, and rules that control data usage and access. Data integration refers to the process of combining data from multiple sources into a unified view. Data control and administration are important aspects of data governance but do not encompass the entire scope of data management across an organization.

Question 3

A relational database typically consists of one large two-dimensional table.

Accepted Answer

A relational database consists of multiple tables, each with their own fields and relationships to other tables.

Question 4

The use of databases enables organizations to (choose all that apply):
A) Eliminate data redundancy.
B) Minimize data isolation.
C) Minimize data inconsistency.
D) Minimize data security risks.
E) Eliminate data integrity.

Accepted Answer

The answer of The use of databases enables organizations to...

Question 5

Which of the following problems do organizations face when managing data?
A) Collecting the vast amounts of data that are being generated
B) Storing the data that are being collected
C) Processing and analyzing the data that are being stored
D) All of these

Accepted Answer

Organizations face all of these problems when managing data. With the increasing amount of data being generated, it becomes difficult for organizations to collect and store them. Processing and analyzing the collected data are additional challenges faced by organizations.

Question 6

Data redundancy refers to:
A) Storing data in a single central location.
B) Sharing data with others.
C) Having copies of the same data in multiple locations.
D) All of these

Accepted Answer

Data redundancy refers to having copies of the same data in multiple locations. Storing data in a single central location is not data redundancy, but rather a single point of failure. Sharing data with others is also not necessarily data redundancy, as the data may only be stored in one location. Therefore, the best choice is C.

Question 7

____ is the cumulative store of subjective or experiential learning.
A) Tacit knowledge
B) Explicit knowledge
C) Intellectual capital
D) None of these

Accepted Answer

Tacit knowledge refers to the knowledge that is gained through experience and subjective learning. It is difficult to transfer or document tacit knowledge, as it is mainly stored in the minds of individuals.

Question 8

Knowledge management systems (KMS) are used by organizations to capture, store, and disseminate knowledge within the organization.

Accepted Answer

KMS are designed for knowledge sharing within an organization to improve decision-making, avoid redundant work, and stimulate innovation.

Question 9

NoSQL databases can process both structured and unstructured data.

Accepted Answer

NoSQL databases are designed to handle unstructured, semi-structured, and structured data, making them more versatile than traditional relational databases.

Question 10

In the United States, federal law requires companies to store, evaluate, and disclose financial data for fixed periods of time, even if the company no longer has any use for the data.

Accepted Answer

This is true under various federal laws and regulations such as the Sarbanes-Oxley Act and SEC regulations.

Question 11

The term "data rot" refers to
A) Data that no longer serve a purpose.
B) The deterioration of the medium on which the data are stored.
C) Data that are irrelevant or contain errors.
D) All of these

Accepted Answer

Data rot refers to the deterioration of the medium on which the data are stored, which can lead to the loss or corruption of the data over time. It is not related to whether the data serve a purpose or contain errors.

Question 12

A data model is the diagrammatic representation of a database that clearly defines a database's ___ , ____ and ____.
A) Entities, attributes, relationships.
B) Entity classes, hierarchy, files.
C) Data hierarchy, data attributes, data files.
D) Entity classes, entity attributes, entity files.

Accepted Answer

A data model clearly defines the entities (objects or concepts) within a database, the attributes (characteristics or properties) of those entities, and the relationships between the entities.

Question 13

_____ is a method for analyzing and reducing a relational database to its most streamlined form.
A) Structured query
B) Normalization
C) Query-by-example
D) Relational analysis

Accepted Answer

Normalization is a method used to eliminate redundancy and dependency in a relational database. It involves breaking down a database into smaller, more manageable tables and establishing relationships between them. This helps to reduce data duplication, which improves data consistency and accuracy.

Question 14

Operational data that are constantly updated are stored in:
A) Data warehouses.
B) Data marts.
C) Databases.
D) All of these

Accepted Answer

Operational data that are constantly updated are stored in databases. While data warehouses and data marts are used for storing historical data and analyzing it, databases are used for storing current operational data.

Question 15

A standardized language used to manipulate data is _____.
A) MS-Access
B) Oracle
C) Query-by-example language
D) None of these

Accepted Answer

Query-by-example language (QBE) is a standardized language used to manipulate data. MS-Access and Oracle are database management systems, but do not directly relate to a standardized language for manipulating data. "None of these" is not the correct answer as QBE is a valid option.

Question 16

A database must be associated with only one computer program or information system.

Accepted Answer

A database can be used by multiple computer programs or information systems, as long as they are designed to communicate with that specific database. Examples include databases used by multiple applications within an organization or cloud-based databases accessible by multiple users from various devices.

Question 17

A data warehouse is a low-cost, scaled-down version of a data mart designed for the end-user needs in a department in a large organization.

Accepted Answer

A data warehouse is a large, centralized repository of data used for strategic decision making by executives and other high-level stakeholders in an organization, while a data mart is a smaller, department-specific subset of that data intended for use by end-users in that particular department. Therefore, a data warehouse is not a scaled-down version of a data mart.

Question 18

The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security.

Accepted Answer

This statement is true. The data dictionary is a centralized repository that contains metadata about the data used within an organization, including definitions, data types, relationships, and security measures. The data dictionary helps ensure consistent use and understanding of data across the organization.

Question 19

A group of related fields is generally called a data file.

Accepted Answer

A group of related fields is generally called a database or a table in a database management system. A data file can refer to a file containing data, but it is not specifically used to describe a group of related fields.

Question 20

Social data is not a form of big data.

Accepted Answer

Social data refers to the vast amount of information that is generated from social media and other online platforms, which falls under the category of big data due to its variety, volume and velocity.

Quiz 5: Data and Knowledge Management

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

The management of data across the entire organization is most accurately defined as:

A relational database typically consists of one large two-dimensional table.

The use of databases enables organizations to (choose all that apply) :

Which of the following problems do organizations face when managing data?

Data redundancy refers to:

____ is the cumulative store of subjective or experiential learning.

Knowledge management systems (KMS) are used by organizations to capture, store, and disseminate knowledge within the organization.

NoSQL databases can process both structured and unstructured data.

In the United States, federal law requires companies to store, evaluate, and disclose financial data for fixed periods of time, even if the company no longer has any use for the data.

The term "data rot" refers to

A data model is the diagrammatic representation of a database that clearly defines a database's _ , and __.

_____ is a method for analyzing and reducing a relational database to its most streamlined form.

Operational data that are constantly updated are stored in:

A standardized language used to manipulate data is _____.

A database must be associated with only one computer program or information system.

A data warehouse is a low-cost, scaled-down version of a data mart designed for the end-user needs in a department in a large organization.

The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security.

A group of related fields is generally called a data file.

Social data is not a form of big data.