Relational Database Service (RDS)

Question 1

type of nonrelational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as a unique identifier

Answer 1

Key Value Database

Question 2

type of nonrelational database that is designed to store and query data as JSON-like documents.These DB make it easier for developers to store and query data in a database by using the same document-model format they use in their application code

Answer 2

Document Database

Question 3

database purpose-built to store and navigate relationships. Relationships are first-class citizens and most of the value is derived from these relationships

Answer 3

Graph Database

Question 4

purpose-built databases that rely primarily on memory for data storage, in contrast to databases that store data on disk or SSDs. Are designed to enable minimal response times by eliminating the need to access disks

Answer 4

In-Memory Database

Question 5

NoSQL database that organizes data storage into flexible columns that can be spread across multiple servers or database nodes

Answer 5

Wide Column Database

Question 6

Transaction model ensures that a performed transaction is always consistent. This makes it a good fit for businesses which deal with online transaction processing, or online analytical processing. Used for systems which can handle many small simultaneous transactions. used for relational DB

Answer 6

ACID

Question 7

The rise of NoSQL databases provided a flexible and fluid way to manipulate data used by MongoDB, Cassandra and Redis are among the most popular NoSQL solutions, together with Amazon DynamoDB and Couchbase

Answer 7

BASE

Question 8

ensure availability of data by spreading and replicating it across the nodes of the database cluster

Answer 8

Basically Available

Question 9

Use EC2 for databases if you need access to the DB instance operating system

Answer 9

True

Question 10

Use EC2 for databases if you need advanced database tuning which can only be done on the root

Answer 10

True

Question 11

Use EC2 for databases or database version which aws dont provide

Answer 11

True

Question 12

MySQL, MariaDB, PostgreSQL, Oracle, Microsoft SQL Server are all

Answer 12

Database engines for RDS

Question 13

Can RDS be access from the VPC or any connected private networks?

Answer 13

Yes

Question 14

Allows access to the database from the public internet

Answer 14

Public Addressing

Question 15

Does every RDS instance have its own EBS storage?

Answer 15

Yes

Question 16

Data is replicated from primary to standby immediately

Answer 16

Synchronous Replication

Question 17

Data is replicated from Standby to Read replicas, data is not replicated immediately

Answer 17

Asynchronous Replication

Question 18

cluster deployment in Amazon RDS provides a high availability deployment mode of Amazon RDS with two readable standby DB instances

Answer 18

Multi-AZ DB cluster

Question 19

has a writer DB instance and two usable reader DB instances in three separate Availability Zones in the same AWS Region

Answer 19

Multi-AZ DB cluster

Question 20

provides high availability and failover support for DB instances using a single standby DB instance. Amazon RDS automatically provisions and maintains a synchronous standby replica in a different Availability Zone

Answer 20

Multi-AZ DB instance deployment

Question 21

Points at the writer and is used for read, writes and administration

Answer 21

Cluster Endpoint

Question 22

Directs and reads at an available reader instance

Answer 22

Reader Endpoint

Question 23

Points at a specific instance generally used for testing/fault finding

Answer 23

Instance Endpoints

Question 24

contained in AWS managed s3 buckets that are unable to be viewed from S3

Answer 24

RDS Backups

Question 25

Do snapshots live on after the deletions of an RDS instance

Answer 25

Yes

Question 26

RDS can be configured to replicate backups to another region for extra charges for replication and storage

Answer 26

True

Question 27

When restoring RDS a new instance is created with a new address, applications must be configured to the new RDS instance address

Answer 27

True

Question 28

Provide enhanced performance and durability for Amazon RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads

Answer 28

Read Replicas

Question 29

Amazon RDS creates a second DB instance using a snapshot of the source DB instance. It then uses the engines' native asynchronous replication to update the read replica whenever there is a change to the source DB instance

Answer 29

Read Replicas

Question 30

Read Replicas offer near 0 RPO and very low RTO from failure, data corruption means the Read Replica likely has corrupted data

Answer 30

True

Question 31

Encryption in RDS

Answer 31

SSL/TLS in transit

Question 32

EBS volume encryption in RDS

Answer 32

Thru KMS

Question 33

SQL Server (SQL Server Enterprise Edition) and Oracle security in RDS, which is handled within the DB engine

Answer 33

TDE

Question 34

Does RDS oracle support integration with CloudHSM

Answer 34

Yes

Question 35

can you map database users to IAM roles for federated access.

Answer 35

Yes

Question 36

managed database service for applications that require customization of the underlying operating system and database environment, used/needed for legacy, packaged, and custom applications

Answer 36

RDS Custom

Question 37

instead of connecting to the database everytime, users connect to a proxy which has a pool of connections to the database

Answer 37

rds proxy