NoSQL Chapter

Question 1

Name the four broad classification types of data?

Answer 1

structured data, unstructured data, dynamic data, static data

Question 2

Name the data classification type:
____________ data has a predefined model, which organizes data into a form that is relatively easy to store, process, retrieve and manage.
e.g. relational data.

Answer 2

Structured

Question 3

Name the data classification type:
__________ data is the ooposite of structured data.

Answer 3

unstructured

Question 4

Name the data classification type:
Flat binary files containing text, video or audio are examples of _________ data.

Answer 4

unstructured.

Question 5

T/F: data is not completely devoid of a structure.

Answer 5

True, (e.g., an
audio file may still have an encoding structure and some
metadata associated with it)

Question 6

Name the data classification type:
____________ Data is data that changes relatively frequently.

Answer 6

Dynamic

Question 7

__________ data is the opposite of dynamic data.
▪ E.g., Medical imaging data from MRI or CT scans.

Answer 7

Static

Question 8

Name the data classification type:
Office documents and transactional entries in a financial database are examples of __________ Data.

Answer 8

dynamic

Question 9

File systems or NoSQL databases can be used for _______, ___________ data

Answer 9

static, unstructured

Question 10

T/F: Relational databases are usually used for structured data.

Answer 10

True

Question 11

A ___________ provides a mechanism for storage and retrieval of data that is modeled by means other than the tabular relations used in relational databases.

Answer 11

NoSQL database

Question 12

NoSQL databases mainly follow the _______ properties (out of scope).

Answer 12

BASE

Question 13

Amazon’s Dynamo and Google’s Bigtable are examples of ____________.

Answer 13

NoSQL Databases

Question 14

T/F: No strict schema requirements are one of the main characteristics of NoSQL databases.

Answer 14

True

Question 15

T/F: No strict adherence to BASE properties (out of scope) is one of the characteristics of NoSQL databases.

Answer 15

False, ACID not BASE properties.

Question 16

T/F: Consistency is traded in favor of availability (out of scope) is one of the characteristics of NoSQL databases.

Answer 16

true.

Question 17

Name the four different types of NoSQL databases.

Answer 17

Document Stores, Graph Databases, Key-Value Stores, Columnar Databases.

Question 18

Semi-structured data happened as a result of __________ and ___________.

Answer 18

Big Data, Web 2.0 & 3.0

Question 19

Name the NoSQL database:
Documents are stored in some standard format or
encoding (e.g., XML, JSON, PDF or Office Documents).
E.g., MongoDB and CouchDB

Answer 19

Document Stores

Question 20

____________ are typically referred to as Binary Large Objects (BLOBs)

Answer 20

Document Stores

Question 21

Name the NoSQL database:
Data are represented as vertices and edges.
E.g., Neo4j and VertexDB

Answer 21

Graph Databases

Question 22

T/F: Graph databases are powerful for graph-like queries.

Answer 22

True.

Question 23

Name the NoSQL database:
Keys are mapped to (possibly) more complex value (e.g., lists)
E.g., Amazon DynamoDB and Apache Cassandra

Answer 23

Key-Value Stores

Question 24

Name the NoSQL database:
Has a simple put/get interface.
typically supports regular CRUD (create, read, update, and delete) operations but no joins and aggregate functions.

Answer 24

Key-Value Stores

Question 25

T/F: In a Key-Value Stores, Keys can be stored in a hash table and can be distributed easily.

Answer 25

True.

Question 26

Name the NoSQL database:
___________ databases are a hybrid of RDBMSs and Key-Value stores.
E.g., HBase and Vertica

Answer 26

Columnar

Question 27

T/F: column stores are suitable for write-mostly, write-intensive, large data repositories.

Answer 27

False, read-mostly, read-intensive, large data repositories.

Question 28

T/F: In Columnar Databases, Values are stored in groups of zero or more columns, but in Column-Order (as opposed to Row-Order).

Answer 28

True.

Question 29

T/F: In Columnar databases, Values are queried by matching keys.

Answer 29

True.