RDS

Question 1

RDS means

Answer 1

Relational Database Service

Question 2

Explain relational databases

Answer 2

Structured databases, that use a scheme and are queried with MySQL.

Question 3

True or false. Relational databases require a persistent network connection.

Answer 3

True.

Question 4

RDS instanced have automatic failover detection and recovery?

Answer 4

True

Question 5

Using RDS, individual server components are scaleable?

Answer 5

True

Question 6

What version of MySQL does RDS for MySQL support?

Answer 6

The community version

Question 7

RDS for MySQL allows for scaling of servers, without downtime?

Answer 7

True

Question 8

What’s the purpose of RDS multi AZ?

Answer 8

To provide a failover.

Question 9

Is RDS multi AZ synchronous. Or asynchronous?

Answer 9

Synchronous.

Question 10

What can trigger an RDS failover?

Answer 10

Patching Maintenance
Host failure
Availability zone failure
Instance reboot
Database instance class changes

Question 11

A failover triggers what event?

Answer 11

RDS-Event-2005

Question 12

RDS SQL server does not use failover. What does it use instead.

Answer 12

Mirroring

Question 13

What’s the purpose in a read replica?

Answer 13

Helps offload traffic from the main database instance

Question 14

In RDS should readers be used for resiliency?

Answer 14

No

Question 15

The best way to check an RDS failover is working, is to backup then delete the database instance. True or false?

Answer 15

False. All you need to do is reboot it.

Question 16

Is it a requirement, that your RDS instance must be in the same region as your elastic beanstalk resources?

Answer 16

Yes

Question 17

You need to protect your RDS instance from a complete regional outrage. How might you do this?

Answer 17

Create a snapshot, and copy it to another region.

Question 18

When using oracle and BYOL. You need a licence for the primary database and the standby. Do you need one for the read replica?

Answer 18

No

Question 19

Can SSD storage types in RDS handle short term spikes in traffic?

Answer 19

Yes

Question 20

Is sharding available in RDS

Answer 20

No

Question 21

It’s considered best practise to check failover of new multi-AZ RDS instances. What are you checking for?

Answer 21

How long recovery takes

To check of the new connection works.

Question 22

Read / Writes on an RDS instance are roughly the same. How best to scale?

Answer 22

Vertically

Question 23

Can you disable RDS backups?

Answer 23

Yes. But why would you?

Question 24

In RDS. During a fail. What would lead to the quickest restore.

Multi AZ failover
Promoting a read replica

Answer 24

Multi AZ failover

Question 25

What key characteristic separates database sharding, from other scale out approaches such as database clustering or replication.

Answer 25

The shards have no knowledge of each other. The concept is known as the “share nothing model”

Question 26

You can shard databases in AWS. But it’s not a managed service / feature and you must configure it yourself. True or false?

Answer 26

True

Question 27

When you hit the limits of vertical scaling. Consider ...

Answer 27

Sharding

Question 28

Sharding is also known as

Answer 28

Data partioning