Review the basics Flashcards

1
Q

A collection of values or information is known as?

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

An organized collection of data is known as?

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the three data types?

A

Structured, Semi-Structured, Unstructured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does OLTP stand for?

A

Online transactional processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does OLAP stand for?

A

Online analytical processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

True or False

Semi-Structured data is constrained by a fixed schema.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Semi-structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Semi-Structured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Unstructured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Unstructured

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which type of database supports joins?

A

Relational Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Relational Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

RDS and Aurora

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Redshift

17
Q

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

A

Relational Databases

18
Q

Relational databases are written to and queried using what language?

A

SQL (Structured query language)

19
Q

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

A

Primary Key

20
Q

What does the acronym ACID stand for?

A

Atomicity, consistency, isolation, durability

21
Q

Atomicity in ACID means what?

A

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

22
Q

Consistency in ACID means what?

A

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

23
Q

What does Isolation mean in ACID?

A

Requires that concurrent transactions execute separately from one another

24
Q

Durability stands for what in ACID

A

Ability to recover from unexpected system failure or outage.

25
Q

True or False: Dynamo DB inherently supports ACID compliance.

A

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

26
Q

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

A

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.

27
Q

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

A

Non-Relational Database

28
Q

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

A

Non-Relational Database

29
Q

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

A

Non-Relational Database

30
Q

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?

A

Non-relational Database

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

31
Q

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

A

Non-Relational Database

32
Q

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

A

Basically Available Soft-state Eventually-consistent

33
Q

Basically available in BASE compliance means what?

A

Basic read/write operations are available

34
Q

Soft state in BASE compliance means what?

A

No consistency guarantees, data state may change

35
Q

Eventually consistent in BASE compliance means what?

A

data is expected to be consistent over time