Exam 5: Data and Knowledge Management

After the data is stored in your organization's databases, it must be accessible to users in a data warehouse in order to help your organization to make decisions.

In a relational database, every row represents a(n)_____.

Refer to the Braintree case. Knowledge management systems such as Confluence allows organizations to: ____________.

An entity is a person, place, thing, or event about which information is maintained.

Discuss the advantages of the database approach.

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

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

Refer to Case 5.1 Data Problems at Target Canada. In order for SAP ERP system to work properly, data needs to be:

A _______ is eight ________.

The process of moving data from various sources into the data warehouse is called:

An attribute is any characteristic or quality that describes a particular entity.

When data are normalized, attributes in the table depend only on the _____.

Master data are a set of core data that span all of an enterprise's information systems.

A(n)_____ represents a single character, such as a letter, number, or symbol.

The secondary key is a field that identifies a record with complete uniqueness.

Compared to data warehouses, data marts have which one of the following characteristics?

The relational database model is based on the concept of three-dimensional tables.

Which of the following is NOT a problem with Big Data?

A database management system is primarily a(n)_____.

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.