Technology - Databases

Question 1

Database

Answer 1

Allow to collect, store, retrieve, sort, graph, manipulate data and access data by querying it.

It’s an organised collection of various forms of data, used by many apps: web, mobile, services etc.

Typically controlled by a database management system.

Question 2

Relational Database

Answer 2

RDS & Aurora

Data is stored in a structured format (tables and rows), and relationships between tables are established using keys.

Question 3

NoSQL Database

Answer 3

Dynamo DB

Handle unstructured or semi-structured datalike documents or graphs.

Question 4

Graph Database

Answer 4

Neptune

For analytical queries and data warehousing, where large volumes of data is organised by columns rather than rows.

Question 5

In-memory Database

Answer 5

ElastiCache

Data stored in memory for fast access, suitable for real-time apps requiring rapid data processing.

Question 6

Document Database

Answer 6

DocumentDB

Type of NoSQL database that stores and manages semi-structured data as documents. Typically using JSON or BSON.

Question 7

RDS

Answer 7

Relational Database Service. Allows for an easy launch and management of a relational database.

RDS supports popular database engines like MySQL, Amazon Aurora or Oracle.

Offers high availability and fault tolerance using Multi-AZ (read replicas across Regions for fast querying). Automatic software patching, automated backups and system maintenance.

Question 8

Aurora

Answer 8

A relational database compatible with MySQL (5x faster) and PostgreSQL (3x faster).

Scales automatically, high durability and high availability, while being managed by RDS.

Question 9

DynamoDB

Answer 9

Fully managed NoSQL key-value and document database.

Fully managed and serverless, non-relational and scales automatically with fast performance.

Question 10

DocumentDB

Answer 10

A fully managed, serverless, non-relational document database that is compatible with MongoDB.

Question 11

ElastiCache

Answer 11

A fully managed in-memory datastore, compatible with Redis and Memcached engines.

Data is stored in memory, meaning it can be lost. It offers high performance and low latency.

Question 12

Neptune

Answer 12

A fully managed graph database that supports highly connected datasets, like social media networks.

Fully managed, serverless, fast and reliable.

Question 13

Database Use Case - migrate on-prem Oracle database to cloud

Answer 13

RDS

Question 14

Database Use Case - migrate on-prem PostgreSQL database to cloud

Answer 14

Aurora or RDS

Question 15

Database Use Case - alleviate database load that is accessed often

Answer 15

ElastiCache

Question 16

Database Use Case - process large sets of user profiles

Answer 16

Neptune

Question 17

Database Use Case - NoSQL database to handle millions requests per second

Answer 17

DynamoDB

Question 18

Database Use Case - Operate MongoDB workloads

Answer 18

DocumentDB