Top AWS RDS Interview Questions
- What is Amazon RDS?
- Explain some features in AWS RDS?
- List the database engines supported by AWS RDS?
- What is an RDS instance?
- What are RDS Interfaces?
- What is Amazon Aurora?
- What is an AWS Cluster?
- What is the work of Amazon RDS?
- What is the purpose of standby RDS instance?
- What are Oracle features in AWS RDS?
- Explain Oracle Licensing?
- What are DB Instances in AWS RDS?
What is Amazon RDS?The Amazon RDS (Relational Database Service) is used to easily create a relational database in the cloud. This cross-platform database service was developed by Amazon and released in the year 2009. It also provides a way to manage the administrative processes like patching the database software, backing up databases and enabling point-in-time recovery. This proprietary tool by Amazon simplifies the process of creation, scaling and the use of the relational database in applications.
Explain some features in AWS RDS?Amazon RDS Features:
- Lower administrative burden. Easy to use.
- Performance. General Purpose (SSD) Storage.
- Scalability. Push-button compute scaling.
- Availability and durability. Automated backups.
- Security. Encryption at rest and in transit.
- Manageability. Monitoring and metrics.
- Cost-effectiveness. Pay only for what you use.
List the database engines supported by AWS RDS?Some of the database engines supported by the Amazon RDS are:
- Amazon Aurora
- Postgre SQL
- Microsoft SQL Server
What is an RDS instance?Amazon Relational Database Service (Amazon RDS) is a web service that that allows you to quickly create a relational database instance in the cloud. Amazon RDS manages the database instance on your behalf by performing backups, handling failover, and maintaining the database software. For read-heavy applications, you can launch Read Replicas which are RDS instances that serve as copies of the source master database for handling read-requests. You can attach up to five (5) Read Replicas to a source DB instance.The Instances page lists the existing RDS Instances in the selected AWS region. Clicking on an existing RDS Instance displays the details for that instance.
- Name - unique name/identifier for the RDS instance.
- Engine - The version of the MySQL or Oracle engine of the RDS Instance.
- RDS Subnet Group - The group of RDS Subnets for the VPC.
- Availability Zone - The availability zone into which the RDS Instance will be created and launched.
- Multi-AZ - Indicates that the RDS Instance will be used in a multiple availability zone configuration.
- Instance class - If you selected a different instance type, the existing instance will be terminated and new RDS instance will be launched.
- Storage - storage size in GBs for the instance that will be allocated for storing data.
- Source instance - If the instance is a Read Replica, it will list the name of the source DB instance.
- Status - The status of the RDS Instance (creating, modifying, available, rebooting, deleting). An RDS Instance will only be accessible when its status is 'available'.