Question: MongoDB and SimpleDB are both examples of:

SQL databases.

open source databases.

NoSQL databases.

cloud databases.

big data databases.

Answer: NoSQL databases.-

Question: Data cleansing not only corrects errors but also:

removes duplicate data.

enforces consistency among different sets of data.

establishes logical relationships between data.

structures data.

normalizes data.

Answer: enforces consistency among different sets of data.

Question: _______ tools are used to analyze large unstructured data sets, such as email, memos, and survey responses to discover patterns and relationships.

Clustering

Classification

OLAP

In-memory

Text mining

Answer: Text mining -

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

defragmentation.

data normalization.

data auditing.

data scrubbing.

data optimization.

Answer: data scrubbing. -

Question: A database ________ describes a database entity.

Record

file

Field

value

Byte

Answer: Field

Question: Which of the following is not a method for performing a data quality audit?

Surveying managers about their perceptions of data quality

Surveying end users about their perceptions of data quality

Surveying entire data files

Surveying samples from data files

Surveying data definition and query files

Answer: Surveying data definition and query files-

Question: In data mining, which of the following involves using a series of existing values to determine what other future values will be?

Forecasting

Clustering

Sequences

Classifications

Associations

Answer: Forecasting

Question: Which of the following is a specialized language that programmers use to add and change data in the database?

Data manipulation language

Data definition language

Structured query language

DBMS

Data access language

Answer: Data definition language -

Question: Which of the following enables you to create a script that allows a web server to communicate with a back-end database?

Java

CGI

SQL

HTML

NoSQL

Answer: CGI

Question:

Answer: Sentiment analysis software -