Deck 11: Big Data and Analytics

Question 1

Big data requires effectively processing:

A) a single data type (numeric).
B) two data types (text and numeric).
C) many data types.
D) a single data type (text).

Answer 1

C

Question 2

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

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

Answer 2

B

Question 3

________ is the most popular key-value store NoSQL database management system.

A) Access
B) Apache Cassandra
C) Neo4j
D) Redis

Answer 3

D

Question 4

The NoSQL model that incorporates 'column families' is called a:

A) key-value score.
B) document store.
C) wide-column store.
D) column-SQL database.

Question 5

Big Data includes:

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 (ERD) with many different data types that are processed at very high speeds.
D) large volumes of entity relationship diagrams (ERD) with a single data type processed at very high speeds.

Question 6

An organization that decides to adopt the most popular NoSQL database management system would select:

A) Access.
B) MongoDB.
C) Neo4j.
D) Redis.

Question 7

At a basic level, analytics refers to:

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

Question 8

The NoSQL model that is specifically designed to maintain information regarding the relationships (often real-world instances of entities) between data items is called a:

A) key-value score.
B) document store.
C) wide-column store.
D) graph-oriented database.

Question 9

NoSQL systems allow ________ by incorporating commodity servers that can be easily added to the architectural solution.

A) scaling down
B) scaling out
C) scaling up
D) scaling over

Question 10

Big data:

A) requires a normalized dataset to 3ʳᵈ Normal Form.
B) does not require a strictly defined data model.
C) requires a strictly defined schema.
D) requires a normalized dataset to BCNF.

Question 11

________ generally processes the largest quantities of data.

A) Operational databases
B) Transaction processing
C) Big data
D) Data marts

Question 12

The NoSQL model that includes a simple pair of a key and an associated collection of values is called a:

A) key-value score.
B) document store.
C) wide-column store.
D) graph database.

Question 13

NoSQL focuses on:

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

Question 14

NoSQL includes data storage and retrieval:

A) based on the relational model.
B) based on normalized tables.
C) not based on the relational model.
D) not based on data.

Question 15

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.

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

Question 16

Apache Cassandra is a leading producer of ________ NoSQL database management systems.

A) key-value store
B) wide-column
C) relational
D) graph

Question 17

According to your text, NoSQL stands for:

A) Numbered Structured Query Language.
B) No Structured Query Language.
C) Not Only Structured Query Language.
D) Numeric Only Structured Query Language.

Question 18

An organization that requires a graph database that is highly scalable would select the ________ database management system.

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

Question 19

________ includes the value of speed in a NoSQL database.

A) Velocity
B) Vigilant
C) Verified
D) Variety

Question 20

________ includes NoSQL accommodation of various data types.

A) Velocity
B) Vigilant
C) Verified
D) Variety

Question 21

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

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

Question 22

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

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

Question 23

Hive is a(n) ________ data warehouse software.

A) Oracle
B) Microsoft
C) Macintosh
D) Apache

Question 24

With HDFS it is less expensive to move the execution of computation to data than to move the:

A) data to hardware.
B) data to systems analysis.
C) data to computation.
D) data to processes.

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

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

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

Question 29

When an organization must decide on optimization and simulation tools to make things happen it is using:

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

Question 30

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

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

Question 31

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

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

Question 32

Regarding big data value, the primary focus is on:

A) usefulness.
B) speed.
C) quantity.
D) variety.

Question 33

Although volume, variety, and velocity are considered the initial three v dimensions, two additional Vs of big data were added and include:

A) veracity and verified.
B) volume and verified.
C) verified and valuable.
D) veracity and value.

Question 34

NoSQL systems enable automated ________ to allow distribution of the data among multiple nodes to allow servers to operate independently on the data located on it.

A) sharing
B) sharding
C) SQL
D) mongo

Question 35

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

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

Question 36

________ are examples of Business Intelligences and Analytics 3.0 because they have millions of observations per second.

A) Administrative systems
B) Web-based interaction logs
C) Web-based customer platforms
D) Smartphones

Question 37

________ includes concern about data quality issues.

A) Velocity
B) Vigilant
C) Veracity
D) Variety

Question 38

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

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

Question 39

The oldest form of analytics is:

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

Question 40

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

A) MapSystem
B) MapReduce
C) MapCluster
D) MapComponent

Question 41

________ tools commonly load data into intermediate hypercube structures.

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

Question 42

First degree or complete price discrimination relates to:

A) the minimum price customers are willing to pay.
B) the maximum price customers are willing to pay.
C) the preferred product based on personal preference.
D) the number of products customers are willing to purchase.

Question 43

NoSQL focuses on avoidance of replication and minimizing storage space.

Question 44

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

Question 45

The 'schema on read' approach often incorporates JSON or XML.

Question 46

NoSQL stands for 'Not only SQL.'

Question 47

Economies of storage indicate data storage costs increase every year.

Question 48

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

Question 49

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

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

Question 50

A researcher trying to explain why sales of garden supplies in Hawaii have decreased would be an example of ________ data mining.

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

Question 51

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

Question 52

Decision Support Systems (DSS) was a precursor to analytics and business intelligence.

Question 53

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

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

Question 54

Value (related to the five 'v's of big data) addresses the pursuit of a meaningful goal.

Question 55

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

Question 56

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

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

Question 57

Big data allows for two different data types (text and numeric).

Question 58

The original three 'v's attributed to big data include volume, variety, and velocity.

Question 59

________ is arguably the most common concern by individuals regarding big data analytics.

A) Saving money
B) Taking up large amounts of computer storage
C) Personal privacy
D) Processing time

Question 60

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

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

Question 61

Hive creates MapReduce jobs and executes them on a Hadoop Cluster.

Question 62

The dive in anywhere characteristic of a data lake is overrides constraints related to confidentiality.

Question 63

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

Question 64

Server logs are considered a big data variety data type.

Question 65

The philosophical underpinnings of big data are based on schema on write.

Question 66

HDFS is an acronym for Hadoop distributed file system.

Question 67

Big data databases tend to sacrifice consistency for availability.

Question 68

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

Question 69

HP HAVEn integrates HP technologies with open source big data technologies.

Question 70

Collect everything is a characteristic of a data lake.

Question 71

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

Question 72

Data in HDFS files cannot be updated.

Question 73

Graph-oriented databases are designed to maintain information regarding the relationships between data items.

Question 74

Hadoop is considered a relational database management system.

Question 75

HBASE is a wide-column store database that runs on top of HDFS (modeled after Google).

Question 76

MongoDB is a proprietary NoSQL database management system created by Oracle.

Question 77

Word processing documents are commonly stored in a 'document store' NoSQL database model.

Question 78

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

Question 79

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

Question 80

Apache Cassandra is a wide-column NoSQL database management system.