Question 1

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

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. B

Question 2

HDFS is an acronym for Hadoop distributed file system.

Accepted Answer

A) True 
 B)False  True

Question 3

JSON is commonly used in conjunction with the 'document store' NoSQL database model.

Accepted Answer

A) True 
 B)False  True

Question 4

A business owner that needs carefully normalized tables would likely need a relational database instead of a NoSQL database.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A)  adaptive 
B)  comparative 
C)  prescriptive 
D)  decisive 
A)  adaptive 
B)  comparative 
C)  prescriptive 
D)  decisive

Question 6

NoSQL databases DO NOT support ACID (atomicity, consistency, isolation, and durability).

Accepted Answer

A) True 
 B)False

Question 7

Application of statistical and computational methods to predict data events 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 8

MapReduce is an algorithm for massive parallel processing utilized by Hadoop.

Accepted Answer

A) True 
 B)False

Question 9

There are four main types of NoSQL database data models that include key-value stores, document stores, wide-column stores, and graph databases. Provide an example of a NoSQL database management system for each model.

Accepted Answer

Key-value Stores - Redis
Docum

Question 10

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

Accepted Answer

A)  large number of slaves. 
B)  single master servers. 
C)  language libraries. 
D)  business intelligences. 
A)  large number of slaves. 
B)  single master servers. 
C)  language libraries. 
D)  business intelligences.

Question 11

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

Accepted Answer

A)  relational database management system 
B)  DBBMS 
C)  Java 
D)  data management 
A)  relational database management system 
B)  DBBMS 
C)  Java 
D)  data management

Question 12

NoSQL stands for 'Not only SQL.'

Accepted Answer

A) True 
 B)False

Question 13

The target market for Hadoop is small to medium companies using local area networks.

Accepted Answer

A) True 
 B)False

Question 14

An organization that requires a sole focus on performance with the ability for keys to include strings, hashes, lists, and sorted sets would select ________ database management system.

Accepted Answer

A)  Access 
B)  Excel Spreadsheet 
C)  Neo4j 
D)  Redis 
A)  Access 
B)  Excel Spreadsheet 
C)  Neo4j 
D)  Redis

Question 15

HDFS requires a single master server, but does not allow slave servers.

Accepted Answer

A) True 
 B)False

Question 16

When reporting and analysis organization of the data is determined when the data is used is called a:

Accepted Answer

A)  entity relationship diagram. 
B)  schema binding. 
C)  schema on read. 
D)  cognitive schema. 
A)  entity relationship diagram. 
B)  schema binding. 
C)  schema on read. 
D)  cognitive schema.

Question 17

________ is an important scripting language to help reduce the complexity of MapReduce.

Accepted Answer

A)  Pig 
B)  Horse 
C)  Dog 
D)  Cat 
A)  Pig 
B)  Horse 
C)  Dog 
D)  Cat

Question 18

NoSQL focuses on:

Accepted Answer

A)  avoidance of replication of data. 
B)  minimizing storage space. 
C)  normalized data. 
D)  flexibility. 
A)  avoidance of replication of data. 
B)  minimizing storage space. 
C)  normalized data. 
D)  flexibility.

Question 19

All of the following are applications for big data and analytics EXCEPT:

Accepted Answer

A)  business. 
B)  science and technology. 
C)  security and public health. 
D)  personal finances. 
A)  business. 
B)  science and technology. 
C)  security and public health. 
D)  personal finances.

Question 20

________ are not used for querying and analyzing data stored in data warehouses.

Accepted Answer

A)  Word processing programs 
B)  OLAP tools 
C)  MOLAP tools 
D)  Dashboard tools 
A)  Word processing programs 
B)  OLAP tools 
C)  MOLAP tools 
D)  Dashboard tools

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

HDFS is an acronym for Hadoop distributed file system.

JSON is commonly used in conjunction with the 'document store' NoSQL database model.

A business owner that needs carefully normalized tables would likely need a relational database instead of a NoSQL database.

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

NoSQL databases DO NOT support ACID (atomicity, consistency, isolation, and durability).

Application of statistical and computational methods to predict data events is:

MapReduce is an algorithm for massive parallel processing utilized by Hadoop.

There are four main types of NoSQL database data models that include key-value stores, document stores, wide-column stores, and graph databases. Provide an example of a NoSQL database management system for each model.

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

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

NoSQL stands for 'Not only SQL.'

The target market for Hadoop is small to medium companies using local area networks.

An organization that requires a sole focus on performance with the ability for keys to include strings, hashes, lists, and sorted sets would select ________ database management system.

HDFS requires a single master server, but does not allow slave servers.

When reporting and analysis organization of the data is determined when the data is used is called a:

________ is an important scripting language to help reduce the complexity of MapReduce.

NoSQL focuses on:

All of the following are applications for big data and analytics EXCEPT:

________ are not used for querying and analyzing data stored in data warehouses.

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

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

HDFS is an acronym for Hadoop distributed file system.

JSON is commonly used in conjunction with the 'document store' NoSQL database model.

A business owner that needs carefully normalized tables would likely need a relational database instead of a NoSQL database.

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

NoSQL databases DO NOT support ACID (atomicity, consistency, isolation, and durability).

Application of statistical and computational methods to predict data events is:

MapReduce is an algorithm for massive parallel processing utilized by Hadoop.

There are four main types of NoSQL database data models that include key-value stores, document stores, wide-column stores, and graph databases. Provide an example of a NoSQL database management system for each model.

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

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

NoSQL stands for 'Not only SQL.'

The target market for Hadoop is small to medium companies using local area networks.

An organization that requires a sole focus on performance with the ability for keys to include strings, hashes, lists, and sorted sets would select ________ database management system.

HDFS requires a single master server, but does not allow slave servers.

When reporting and analysis organization of the data is determined when the data is used is called a:

________ is an important scripting language to help reduce the complexity of MapReduce.

NoSQL focuses on:

All of the following are applications for big data and analytics EXCEPT:

________ are not used for querying and analyzing data stored in data warehouses.

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