Question 1

When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a:

Accepted Answer

A)  data dump. 
B)  data ocean. 
C)  data lake. 
D)  data stream. 
A)  data dump. 
B)  data ocean. 
C)  data lake. 
D)  data stream.

Question 2

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

Accepted Answer

A)  large number of slaves. 
B)  single master server. 
C)  language library. 
D)  business intelligence. 
A)  large number of slaves. 
B)  single master server. 
C)  language library. 
D)  business intelligence.

Question 3

Transaction processing and management reporting tend to fit big data databases better than relational databases.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A)  viewable, volume, and variety. 
B)  volume, variety, and velocity. 
C)  verified, variety, and velocity. 
D)  vigilant, viewable, and verified. 
A)  viewable, volume, and variety. 
B)  volume, variety, and velocity. 
C)  verified, variety, and velocity. 
D)  vigilant, viewable, and verified.

Question 5

Neo4j is a wide-column NoSQL database management system developed by Oracle.

Accepted Answer

A) True 
 B)False

Question 6

Structured Query Language (SQL) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful information.

Accepted Answer

A) True 
 B)False

Question 7

Describe conceptually how big data differs from traditional relational database management systems.

Accepted Answer

Not only SQL and relational database man

Question 8

HDFS allows indexing which specifically allows applications real-time access to the data.

Accepted Answer

A) True 
 B)False

Question 9

Horse, an important scripting language, helps reduce the complexity of MapReduce.

Accepted Answer

A) True 
 B)False

Question 10

Descriptive analytics answers the question: "What happened yesterday?"

Accepted Answer

A) True 
 B)False

Question 11

The oldest form of analytics is:

Accepted Answer

A)  predictive analytics. 
B)  descriptive analytics. 
C)  prescriptive analytics. 
D)  comparative analytics. 
A)  predictive analytics. 
B)  descriptive analytics. 
C)  prescriptive analytics. 
D)  comparative analytics.

Question 12

OLAP, ROLAP, and TLAP are tools commonly used to load data into intermediate hypercube structures.

Accepted Answer

A) True 
 B)False

Question 13

At a basic level, analytics refers to:

Accepted Answer

A)  collecting data. 
B)  conducting a needs analysis. 
C)  analysis and interpretation of data. 
D)  normalizing data. 
A)  collecting data. 
B)  conducting a needs analysis. 
C)  analysis and interpretation of data. 
D)  normalizing data.

Question 14

________ tools commonly load data into intermediate hypercube structures.

Accepted Answer

A)  OLAP 
B)  MOLAP 
C)  ROLAP 
D)  TLAP 
A)  OLAP 
B)  MOLAP 
C)  ROLAP 
D)  TLAP

Question 15

The schema on write and schema on read are considered synonymous approaches.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  predictive analytics. 
B)  descriptive analytics. 
C)  prescriptive analytics. 
D)  comparative analytics. 
A)  predictive analytics. 
B)  descriptive analytics. 
C)  prescriptive analytics. 
D)  comparative analytics.

Question 17

Customers leave clues about their preferences when navigating a company's Web site.

Accepted Answer

A) True 
 B)False

Question 18

The goal of data mining related to analyzing data for unexpected relationships is:

Accepted Answer

A)  explanatory. 
B)  confirmatory. 
C)  exploratory. 
D)  laboratory. 
A)  explanatory. 
B)  confirmatory. 
C)  exploratory. 
D)  laboratory.

Question 19

An organization using HDFS realizes that hardware failure is a(n):

Accepted Answer

A)  norm. 
B)  irregularity. 
C)  anomaly. 
D)  inconsistency. 
A)  norm. 
B)  irregularity. 
C)  anomaly. 
D)  inconsistency.

Question 20

Big Data includes:

Accepted Answer

A)  large volumes of data with many different data types that are processed at very high speeds. 
B)  large volumes of data entry with a single data type processed at very high speeds. 
C)  large volumes of entity relationship diagrams (ER
D)  with many different data types that are processed at very high speeds. 
D)  large volumes of entity relationship diagrams (ER
D)  with a single data type processed at very high speeds. 
A)  large volumes of data with many different data types that are processed at very high speeds. 
B)  large volumes of data entry with a single data type processed at very high speeds. 
C)  large volumes of entity relationship diagrams (ER
D)  with many different data types that are processed at very high speeds. 
D)  large volumes of entity relationship diagrams (ER
D)  with a single data type processed at very high speeds.

When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a:

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

Transaction processing and management reporting tend to fit big data databases better than relational databases.

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

Neo4j is a wide-column NoSQL database management system developed by Oracle.

Structured Query Language (SQL) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful information.

Describe conceptually how big data differs from traditional relational database management systems.

HDFS allows indexing which specifically allows applications real-time access to the data.

Horse, an important scripting language, helps reduce the complexity of MapReduce.

Descriptive analytics answers the question: "What happened yesterday?"

The oldest form of analytics is:

OLAP, ROLAP, and TLAP are tools commonly used to load data into intermediate hypercube structures.

At a basic level, analytics refers to:

________ tools commonly load data into intermediate hypercube structures.

The schema on write and schema on read are considered synonymous approaches.

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

Customers leave clues about their preferences when navigating a company's Web site.

The goal of data mining related to analyzing data for unexpected relationships is:

An organization using HDFS realizes that hardware failure is a(n):

Big Data includes:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 11: Big Data and Analytics

When a data repository (including internal and external data) does NOT follow a predefined schema, this is called a:

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

Transaction processing and management reporting tend to fit big data databases better than relational databases.

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

Neo4j is a wide-column NoSQL database management system developed by Oracle.

Structured Query Language (SQL) is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful information.

Describe conceptually how big data differs from traditional relational database management systems.

HDFS allows indexing which specifically allows applications real-time access to the data.

Horse, an important scripting language, helps reduce the complexity of MapReduce.

Descriptive analytics answers the question: "What happened yesterday?"

The oldest form of analytics is:

OLAP, ROLAP, and TLAP are tools commonly used to load data into intermediate hypercube structures.

At a basic level, analytics refers to:

________ tools commonly load data into intermediate hypercube structures.

The schema on write and schema on read are considered synonymous approaches.

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

Customers leave clues about their preferences when navigating a company's Web site.

The goal of data mining related to analyzing data for unexpected relationships is:

An organization using HDFS realizes that hardware failure is a(n):

Big Data includes:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters