Mongo Prep

Question 1

ACID

Answer 1

Atomicity, Consistency, Isolation, and Durability

Question 2

Atomicity

Answer 2

Either the entire statement is executed, or none of it is executed

Question 3

Consistency (ACID)

Answer 3

transactions only make changes to tables in predefined, predictable ways.

Question 4

Isolation (ACID)

Answer 4

concurrent transactions don’t affect one another.

Question 5

Durability (ACID)

Answer 5

transactions will be saved, even in the event of system failure.

Question 6

Benefits of SQL

Answer 6

ACID transactions and support for complex queries

Question 7

Limitations of SQL

Answer 7

Migrations are tough, Difficult to scale horizontally, not well suited for hierarchical data

Question 8

Benefits of NoSQL

Answer 8

Fast, Flexible Schema, Scales horizontally, Handles large data well

Question 9

Limitations of NoSQL

Answer 9

Complex Query Capabilities? Weaker Consistency

Question 10

Mongo Data Modeling Strategies

Answer 10

Embedded Documents (1:1 and 1:few), Normalization (1:m | m:m), Hybrid

Question 11

BSON benefits

Answer 11

More data types than JSON and size encoding for efficient traversal

Question 12

Max document size

Answer 12

16MB

Question 13

Embedded Document Array benefits

Answer 13

Faster read/write, better consistency, easily model hierarchical data

Question 14

int size

Answer 14

32-bit

Question 15

long size

Answer 15

64-bit