Most frequently asked AWS RDS Interview Questions

1. What is Amazon RDS?
2. Name the database engines supported by Amazon RDS?
3. What are the features of Amazon RDS?
4. What is DynamoDB?
5. What are the tools and techniques that you can use in AWS to identify if you are paying more than you should be?
6. What are the types of DB Storages?
7. What is the difference between Database Cluster and Database Instances?
8. What are some Amazon rds alternative?
9. What are the data types supported by DynamoDB?
10. Is Amazon RDS IaaS or PaaS?
11. How can we MS SQL to DB?
12. Which of the AWS DB service is a NoSQL database and server-less, and delivers consistent single-digit millisecond latency at any scale?
13. Which AWS services will you use to collect and process e-commerce data for near real-time analysis?

What is Amazon RDS?

Amazon Relational Database Service(RDS) is easier to operate a database in Cloud.It also helps us in providing cost efficient and resizable capacity and can manage common database tasks.
It is a distributed database service by Amazon Web Services.AWS RDS is usrd to setup relational database for using it in an application.

Name the database engines supported by Amazon RDS?

Amazon Aurora
Postgre SQL
MySQL
MariaDB
Oracle
Microsoft SQL Server

What are the features of Amazon RDS?

Easy to administer
Highly scalable
Highly secured
On-Demanding pricing
Supports Multi-availability zone deployment

What is DynamoDB?

DynamoDB supports key value document data structures.It exposes a similar data model to and derives its name from Dynamo.It helps in high level of scalability.
It helps the users the benefit of auto-scaling, in-memory caching, backup and restore options for all their internet-scale applications using DynamoDB.DynamoDB is a proprietary NoSQL database service.It also has a different underlying implementation.
DynamoDB is used by companies like JPMorgan Chase, Intuit, Republic Services, Walt Disney Company, etc.

What are the tools and techniques that you can use in AWS to identify if you are paying more than you should be?

1. By checking the Top Services Table
2. By taking care of Cost Explorer
3. AWS Budgets

What are the types of DB Storages?

IOPS helps in creating report of IOPS value for every minute.
Latency helps in indicating a slower performance.
Throughput is the number of bytes transferred to and from the disk every second.
Queue Depth helps in indicating a slow performance.

What is the difference between Database Cluster and Database Instances?

Database Cluster
Its the name of the cluster that holds instances.
Database Instances
Its the name of each instance in the cluster.

What are some Amazon rds alternative?

Amazon Aurora
Azure SQL Database
Microsoft SQL Server
Snowflake
Oracle Database
Google Cloud SQL
MongoDB Atlas

What are the data types supported by DynamoDB?

Scalar Data Types:
Binary
Number
Boolean
String
Collection Data Types:
Binary Set
Number Set
String Set
Heterogeneous Map
Heterogeneous List

Is Amazon RDS IaaS or PaaS?

PaaS
RDS provided bt amazon is PaaS as it helps in providing set of tools to our database instances.

How can we MS SQL to DB?

From the DB instance details get the end point.


Use the end point and the master user credentials as the connection details.


Once connected, we get the following window.


We can also query the MSSQL DB as shown below.

Which of the AWS DB service is a NoSQL database and server-less, and delivers consistent single-digit millisecond latency at any scale?

Amazon DynamoDB
As Amazon DynamoDB is a progenitor of NoSQL which helps us in bringing the power of the cloud to the NoSQL database.

Which AWS services will you use to collect and process e-commerce data for near real-time analysis?

Amazon DynamoDB - It is a NoSQL database service that supports document data structures.
Amazon Redshift - It is a data warehouse which helps in forming bigger part of cloud computing platform.