Databases Flashcards
What is the retention period for automated backups?
Between 1 - 35 days
What are the differences between automated backups and snapshots?
Automated backups are enabled by default
DB snapshots are done manually
DB snapshots remain after the RDS instance has been deleted
What happens when you restore an automated backup or snapshot?
The restored version of the DB will be the new RDS instance with a new endpoint.
Why would you use Multi-AZ?
For Disaster Recovery
How could you resolve connectivity issues between EC2 and RDS instances?
Add an inbound rule in the security group of the RDS for MySQL on port 3306 and whitelist EC2 security group
How do you encrypt an unencrypted RDS instance?
Create a snapshot
Make a copy of snapshot
Choose Encryption
What is Redshift?
Data Warehousing service
What is ElastiCache?
AWS in-memory cache
What 5 databases support Multi-AZ?
PostgreSQL Oracle MySQL MariaDB SQL Server
Why would you use Read Replica?
For high read databases
Can you encrypt EBS root volumes?
Yes but not default AMIs. First, copy the AMI and encrypt in process
What are the lowest cost EBS options?
ST1 - Throughput Optimized
SC1 - Cold
What is a RAID array?
Redundant Array of Independent Disks
What 4 types of EBS Volumes are there?
GP2 - General Purpose SSD
Io1 - Provisioned IOPS SSD
SC1 - Cold HDD
ST1 - Throughput Optimized HDD
What type of storage is EFS?
Block Based
