Chapter 6

According to Gartner, more than ______ percent of the critical data in large Fortune 1000 companies' databases are inaccurate or incomplete.

25

Which of the following is not a true statement about performing a data quality audit?

A data quality audit can be performed by surveying data definition and query files

Clusters are occurrences linked to multiple events.

False

Data cleansing not only corrects errors but also:

enforces consistency among different sets of data that originated in a separate information system.

A data governance policy specifies all of the following except:

which type of business intelligence tool should be used.

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:

data cleansing.

Data scrubbing is a more intensive corrective process than data cleansing.

False

Implementing a web interface for an organization's internal database usually requires substantial changes to be made to the database.

False

In a client/server environment, a DBMS is located on a dedicated computer called a web server.

False

In-memory computing relies primarily on a computer's disk drives for data storage.

False

Multiple data marts are combined and streamlined to create a data warehouse.

False

Core operational transaction systems provide data to data warehouses.

True

High-speed analytic platforms use both relational and non-relational tools to analyze large data sets.

True

Many back-end databases cannot interpret commands written in HTML.

True

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

True

OLAP can manage and handle queries with very large sets of data.

True

The term data governance encompasses policies and procedures through which data can be managed as an organizational resource.

True

You can use OLAP to perform multidimensional data analysis.

True

______ establishes an organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information.

Data governance

Structured data accounts for the majority of organizational information and is one of the major sources of big data.

False