EXAM 2

________is a collection of data so large and complex that it is difficult to manage using traditional database management systems.

Big Data

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

Big Data can be structured, unstructured, or semi-structured.

Data warehouses and data marts are updated by user

False

Data warehouses are information silos

False

The process of acquiring, keeping, and managing data is becoming easier.

False

When various copies of the data agree, this is an example of data integrity.

False

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

Normalization

Which of the following is NOT a reason managing data is difficult.

The amount of data is decreasing exponentially with time.

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

True

A foreign key is a primary key in another file.

True

Facebook and Google want to bring internet access to the developing world so they can sell those people to advertisers.

True

A data ________ is a repository of historical data that are organized by subject to support decision makers in the organization

Warehouse

A ________ is a group of eight ________.

byte; bits

A data ________ stores vast amounts of data in their original format until they are required, rather than forcing the integration of large volumes of data before analysis.

data lake

From the mid-1950s until the early 1970s, organizations managed their data in a _________; this created ________.

file management environment; information silos

The ________ creates links between two tables.

foreign

Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance.

minimum; maximum

A circle with a vertical line represents the ________ cardinality symbol.

optional single

A(n) _____ is a logical grouping of related fields.

record

A standardized language used to manipulate data is _________.

structured query language