Review the basics

Question 1

A collection of values or information is known as?

Answer 1

Data

Question 2

An organized collection of data is known as?

Answer 2

Database

Question 3

What are the three data types?

Answer 3

Structured, Semi-Structured, Unstructured

Question 4

What type of data structure is typically stored in tables and has predefined schemas?

Answer 4

Structured

Question 5

What does OLTP stand for?

Answer 5

Online transactional processing

Question 6

What does OLAP stand for?

Answer 6

Online analytical processing

Question 7

What is the best suitable data structure for OLTP & OLAP workloads?

Answer 7

Structured

Question 8

True or False

Semi-Structured data is constrained by a fixed schema.

Answer 8

False

Question 9

If you were designing a system where you would be working with big data and required low latency which data type would you use?

Answer 9

Semi-structured

Question 10

A record of this data type is generally made up of XML or JSON

Answer 10

Semi-Structured

Question 11

A folder on your computer which has all of your videos in it, is what type of data structure?

Answer 11

Unstructured

Question 12

A computer file system or AWS S3 is an example of what data type?

Answer 12

Unstructured

Question 13

Which type of database supports joins?

Answer 13

Relational Databases

Question 14

MySQL, PostgresSQL, MariaDB, Oracle, Microsoft SQL are all what type of database?

Answer 14

Relational Databases

Question 15

Which service(s) in AWS would be best used for OLTP workloads?

Answer 15

RDS and Aurora

Question 16

Which service(s) in AWS would be best suited for OLAP workloads?

Answer 16

Redshift

Question 17

This database can be characterized by multiple tables interconnected through key relationships

Answer 17

Relational Databases

Question 18

Relational databases are written to and queried using what language?

Answer 18

SQL (Structured query language)

Question 19

What is the default key used to index a table in a relational database?

Answer 19

Primary Key

Question 20

What does the acronym ACID stand for?

Answer 20

Atomicity, consistency, isolation, durability

Question 21

Atomicity in ACID means what?

Answer 21

A transaction executes completely or not at all. It is all or nothing.

Question 22

Consistency in ACID means what?

Answer 22

Once a transaction has been committed, the data must conform to the given schema.

Question 23

What does Isolation mean in ACID?

Answer 23

Requires that concurrent transactions execute separately from one another

Question 24

Durability stands for what in ACID

Answer 24

Ability to recover from unexpected system failure or outage.

Question 25

True or False: Dynamo DB inherently supports ACID compliance.

Answer 25

False. You can use build your application that uses ACID relationships, but Dynamo DB will not enforce ACID properties by default.

Question 26

True or False: Microsoft SQL has built-in ACID relationships, but they can be overridden by your application.

Answer 26

False: Kind of a trick question. MS SQL does have ACID relationships built-in, but there is no way for an application to override this behavior.

Question 27

If you are talking to someone and they use the term NoSQL, which type of database are they referring to?

Answer 27

Non-Relational Database

Question 28

If you have semi-structured data, which type of database would you use?

Answer 28

Non-Relational Database

Question 29

If you require a database that was going to be high volume and had to be low latency, which database type would you choose?

Answer 29

Non-Relational Database

Question 30

The company you work for requires a database that will hold customer data. The data collected will likely change over time since they are not sure which information they will need later on. They have said they need to change the data inserted into the database on the fly with zero downtime. Which database is the best choice?

Answer 30

Non-relational Database Relational Databases require schema changes and need to be planned whereas non-relational can have additional fields sent whenever necessary.

Question 31

DynamoDB, DocumentDB, ElastiCache and Neptune are all what type of database?

Answer 31

Non-Relational Database

Question 32

Non-relational databases are BASE compliant, what does this stand for?

Answer 32

Basically Available Soft-state Eventually-consistent

Question 33

Basically available in BASE compliance means what?

Answer 33

Basic read/write operations are available

Question 34

Soft state in BASE compliance means what?

Answer 34

No consistency guarantees, data state may change

Question 35

Eventually consistent in BASE compliance means what?

Answer 35

data is expected to be consistent over time