Relation Database Services

Question 1

Amazon RDS components

Answer 1

DB instances; Region and AZs; Security groups; DB parameter groups; DB option groups;

Question 2

DB Instances

Answer 2

5GB – 6TB; Microsoft SQL-Server up to 4TB.

Question 3

Amazon Aurora DB

Answer 3

Primary instance: performs read, writes, and modifies data to the cluster volume.
Aurora Replica: Performs only read operations.
Each Aurora DB cluster supports up to 15 Aurora Replica plus one primary instance.

Question 4

Can not connect to RDS DB instance

Answer 4

the ingress rules in your security group;
The port you specified when you created the DB instance cannot be used to send or receive communications due to your local firewall restrictions.
Your DB instance is still being created and is not yet available. Depending on the size of your DB instance, it can take up to 20 minutes before an instance is available.

Question 5

Multi AZ with RDS

Answer 5

user can not provision the availability Zone. RDS is launched automatically instead.

Question 6

EC2 instance access to RDS in different region

Answer 6

user can not authorize an EC2 security group if it is in a different region. instead, the user can authorize an IP range or specify an EC2 security group in the same region that refers to an IP address in another region. so

Question 7

describe-db-instances command

Answer 7

retrieve endpoint via DB instance description

Question 8

How many DB instances can I run with Amazon RDS?

Answer 8

40;
Of those 40, up to 10 can be Oracle or SQL Server DB instances under the “License Included” model.
RDS for SQL Server has a limit of 30 databases on a single DB instance.

Question 9

How many databases or schemas can I run within a DB instance?

Answer 9

RDS for Amazon Aurora: No limit imposed by software
RDS for MySQL: No limit imposed by software
RDS for MariaDB: No limit imposed by software
RDS for Oracle: 1 database per instance; no limit on number of schemas per database imposed by software
RDS for SQL Server: 30 databases per instance
RDS for PostgreSQL: No limit imposed by software

Question 10

How many reserved instances can I purchase?

Answer 10

40

Question 11

advantage of PIOPS

Answer 11

use optimized EBS volumes and an optimized configuration stack. it provides additional, dedicated capacity for the EBS IO,