Random

Question 1

____ is a collection of values or information

Answer 1

data

Question 2

____ is an organized collection of data

Answer 2

database

Question 3

Three types f data:

Answer 3

structured

semi-structured

unstructured

Question 4

This type of data is typically stored in tables with predefined structures (ie: schema)

Answer 4

structured data

Question 5

structured data is suitable for OLTP (transactional) and OLAP (analytical) workloads

Answer 5

T

Question 6

This type of data is typical of relational databases (indexed tables linked with foreign key relationships)

Answer 6

structured data

Question 7

this type of data is suited for complex queries an analytics ie: complex table join operaitons

Answer 7

Structured data

Question 8

This type of data is organized data, but not constrained by a fixed schema

Answer 8

semi-structured data

Question 9

this type of data the schema accomodates variable data structures

Answer 9

semi-structured data

Question 10

this type of data is typical of non-relational databases

Answer 10

semi structured data

Question 11

this type of data is well suited for big data and low latency apps

Answer 11

semi structured data

Question 12

this type of data is stored as XML and JSON, which makes it easy to read and easy to process

Answer 12

semi structured data

Question 13

this type of data is unorganized

Answer 13

unstructured data

Question 14

thistype fo data has no defined schema ie: docs, photos, videos, music, text mesasges, etc.

Answer 14

unstructured data

Question 15

this type of data is typical ofnon relational databases, file systems, data stores, or data lakes like amazon S3

Answer 15

unstructured data

Question 16

these types of database have a pre defined schema

Answer 16

relational databases

Question 17

this type of database enforces a strict ACID compliance and supports “joins”

Answer 17

relational databases

Question 18

the typical use case for these databases is OLTP and OLAP

Answer 18

relaitonal databaess

Question 19

MySQL, PostgreSQL, MariaDB, Oracle, SQL Server are examples of this type of DB

Answer 19

relational databases

Question 20

aws RDS and Aurora for OLTP and redshift for OLAP are types of these databases

Answer 20

relational databases

Question 21

these types of adtabases are characterized by multiple tables interconencted through foreign key relationships

Answer 21

relational databses

Question 22

Table INdexes

• relational databases are written to and queried using SQL
• for efficient query performance, we add indexes to the table
• tables are indexed by their primary key by default
• secondary indexed can be added on non-key fields

Answer 22

t

Question 23

what i ACID?

Answer 23

Atomicity

Consistency

Isolation

Durability

Question 24

____ means all or nothing - a transaction executes compltely or not at all

Answer 24

Atomicity

Question 25

\_\_\_\_ means once a transaction has been committed, the data must conform to teh given schema

Answer 25

Consistency

Question 26

\_\_\_\_ requires that concurent transactions execute separately from one another

Answer 26

Isolation

Question 27

\_\_\_\_ is the ability to recover form an unexpected system failure or outage

Answer 27

Durability

Question 28

\_\_\_ compliance refers only to the compliance enforced by the DB

Answer 28

ACID

Question 29

ACID behavior an also be enforced by your app: ie: your app can maintain strict foreign key relationships between two DynamoDB tables. however, dynamoDB by itself will not enfore this relationship. another app can always override this behavior. if it were mysql tables with relationships defined on teh DB, no app would be able to override the behavior

Answer 29

T

Question 30

this type of database is sometimes called NoSQL

Answer 30

non relational databases

Question 31

this type of database is suitable for semi strutured and unstructured data

Answer 31

non relational database

Question 32

this type of database has data stored in denomalize form

Answer 32

non relational database

Question 33

this type of database is suited for big data apps big data = high volume, high velocity, high variety

Answer 33

non-relational database

Question 34

this type of database is also suited for low latency (high-speed) apps

Answer 34

non-relational databases

Question 35

this type of database is NOT suited for OLAP

Answer 35

non relational database

Question 36

this type of database has a flexible data model (trades some ACID properties)

Answer 36

non relational database

Question 37

BASE =

Answer 37

Basically Available Soft-state Eventually-consistent

Question 38

\_\_\_\_\_ ___ - basic R/W operations are available

Answer 38

Basically Available

Question 39

\_\_\_ ___ non consistency gurantees, data state may change

Answer 39

Soft-state

Question 40

\_\_\_\_ - data is expected to be consistent over time

Answer 40

Eventually CONsistent

Question 41

if you prefer high performance over stringly consistent databases, use this...

Answer 41

BASE compliance

Question 42

- data stored as tables linked trough foreign key relationships - strict ACID compliance fixed schema vertical scaling uses SQL suited for OLTP and OLAP

Answer 42

Relational (SQL)

Question 43

- data stored as collections or key value pairs - not so strict ACID compliance -flexible schema (semi structured and unstructured data) horizontal scaling - uses object based APIs - suited forOLTP (web/mobile apps)

Answer 43

Non-Relational (NoSQL)