databases

Question 1

where data is organized within a relational database

Answer 1

Tables

Question 2

the specific data within a relational database

Answer 2

Rows

Question 3

the fields within a relational database

Answer 3

Columns

Question 4

SQL Server, Oracle, PostgreSQL, MySQL, MariaDB, Aurora, MySQL are all which type of database?

Answer 4

Relational Database

Question 5

EC2 instance where you do not have access to the operating system, and only have access to the DB

Answer 5

RDS System

Question 6

Generally used for online transaction processing (OLTP) workloads

Answer 6

RDS Database

Question 7

Processes data from transactions in real-time (banking, customer orders, payments)

Answer 7

Online transaction processing (OLTP)

Question 8

Processes complex queries to analyze historical data (profit figures, sales forecasting)

Answer 8

Online analytical processing (OLAP)

Question 9

Creates an exact copy of your production database in another Availability Zone

Answer 9

Multi-AZ

Question 10

SQL Server, Oracle, MySQL, PostgreSQL, MariaDB, Amazon Aurora are what kind of DB types

Answer 10

RDS Database types

Question 11

Used for data warehousing and OLAP tasks like analyzing large amounts of data, reporting, and sales forecasting

Answer 11

Redshift

Question 12

Used to improve performance in RDS databases

Answer 12

Read Replicas

Question 13

Read-only copy of your primary database used for read-heavy workloads

Answer 13

Read Replica

Question 14

Does each read replica have it’s own endpoint

Answer 14

Yes

Question 15

Does read replica work without automatic backups?

Answer 15

No

Question 16

Primarily used for scaling not for disaster recovery

Answer 16

Read Replicas

Question 17

Document database that allows for scalability and flexibility with your data as well as robust querying and indexing features

Answer 17

MongoDB

Question 18

Allows you to run MongoDB on the AWS Cloud.

Answer 18

Amazon DocumentDB

Question 19

Managed database service that scales with your workloads and safely and durably stores your DB information

Answer 19

Amazon DocumentDB

Question 20

Moving MongoDB database to AWS uses

Answer 20

AWS Database migration service > Amazon DocumentDB

Question 21

A distributed database across many servers that uses NoSQL primarily used for big data solutions

Answer 21

Cassandra

Question 22

Allows customers to run Cassandra workloads on AWS and is a fully managed database service

Answer 22

Amazon’s Keyspaces

Question 23

Database that stores nodes and relationships instead of tables or documents

Answer 23

Graph Database

Question 24

Fast, reliable, fully managed graph database service that makes it easy to build and run applications

Answer 24

Neptune

Question 25

Database that is immutable, transparent, and has a cryptographically verifiable transaction log that is owned by one authority

Answer 25

Ledger database

Question 26

Fully managed immutable ledger database that provides transparent transaction log

Answer 26

Amazon Quantum Ledger Database (QLDB)

Question 27

Data points that are logged over a series of time, allowing you to track your data

Answer 27

Time-Series Data

Question 28

Examples are temperature readings around the world, on the hour, every hour for years

Answer 28

Time-Series Data

Question 29

Fully managed database service for time-series data, with the ability to analyze trillions of events per day.

Answer 29

Amazon Timestream