Database Design : Chapter 9, 10, 11

At a basic level, analytics refers to:

analysis and interpretation of data.

All of the following are ways to consolidate data EXCEPT:__

data rollup and integration.

Descriptive, predictive, and ________ are the three main types of analytics.

prescriptive

External data sources present problems for data quality because:

there is a lack of control over data quality.

The three 'v's commonly associated with big data include:

volume, variety, and velocity.

Operational and informational systems are generally separated because of which of the following factors?

A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications.

Which of the following factors drive the need for data warehousing?

Businesses need an integrated view of company information.

Which of the following organizational trends does not encourage the need for data warehousing?

Downsizing

The development of the relational data model did not contribute to the emergence of data warehousing.

False

When multiple systems in an organization are synchronized, the need for data warehousing increases.

False

The Hadoop framework consists of the ________ algorithm to solve large scale problems.

MapReduce

Advances in computer hardware, particularly the emergence of affordable mass storage and parallel computer architectures, was one of the key advances that led to the emergence of data warehousing.

True

Informational systems are designed to support decision making based on historical point-in-time and prediction data.

True

The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.

True

The process of transforming data from a detailed to a summary level is called:

aggregating.

All of the following are tasks of data cleansing EXCEPT:

creating foreign keys.

Conformance means that:

data are stored, exchanged or presented in a format that is specified by its metadata.

Including data capture controls (i.e., dropdown lists) helps reduce ________ deteriorated data problems.

data entry

When we consider data in the data warehouse to be time-variant, we mean:

data in the warehouse contain a time dimension so that they may be used to study trends and changes.

The Hadoop Distributed File System (HDFS) is the foundation of a ________ infrastructure of Hadoop.

data management

Converting data from the format of its source to the format of its destination is called:

data transformation.

Allowing users to dive deeper into the view of data with online analytical processing (OLAP) is an important part of:

descriptive analytics.

When online analytical processing (OLAP) studies last year's sales, this represents:

descriptive analytics.

The best place to improve data entry across all applications is:

in the database definitions.

Big Data includes:

large volumes of data with many different data types that are processed at very high speeds.

Data federation is a technique which:

provides a virtual view of integrated data without actually creating one centralized database.

Event-driven propagation:

pushes data to duplicate sites as an event occurs.

One simple task of a data quality audit is to:

statistically profile all files.

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

subject-oriented.

Which of the following is a basic method for single field transformation?

table lookup

Which of the following advances in information systems contributed to the emergence of data warehousing?

Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms.

A technique using pattern recognition to upgrade the quality of raw data is called:

data scrubbing.

Data governance can be defined as:

high-level organizational groups and processes that oversee data stewardship.

The analysis of summarized data to support decision making is called:

informational processing.

The process of combining data from various sources into a single table or view is called:

joining.

It is true that in an HDFS cluster the DataNodes are the:

large number of slaves.

Informational and operational data differ in all of the following ways EXCEPT:

level of detail.

Data quality ROI stands for:

risk of incarceration.

Informational systems are designed for all of the following EXCEPT:

running a business in real time.

It is true that in an HDFS cluster the NameNode is the:

single master server.

One characteristic of quality data which pertains to the expectation for the time between when data are expected and when they are available for use is:

timeliness.

Quality data can be defined as being:

unique