Database Services

Question 1

_____________ makes it easy to set up, operate, and scale a relational database in the cloud.

Answer 1

“Amazon Relational Database Service (Amazon RDS)”
• Fully managed service DB service
• Easy to launch and scale DB service in cloud
• Can launch Db services such as:
• My SQL DB engine: Maria DB, Amazon Aurora, Standard post gre SQL, Aurora Post GRE SQL, Microsoft Sql server, Oracle

Question 2

Is a key-value and document database that delivers single-digit millisecond performance at any scale.

Answer 2

“Amazon Dynamo DB”
• Amazon’s No SQL DB as a service. It is a server-less service, like amazon S3
• Do not need to worry of underlying infra behind it
• High speed, low latency performance

Question 3

Is a fast, scalable data warehouse that makes it simple and cost-effective to analyze all your data across your data warehouse and data lake

Answer 3

“Amazon Redshift”
• Fully managed based on Post GRE SQL
• Petabite scale data warehouse
• Amazon’s Big data service

Question 4

_____________ is a web service that makes it easy to deploy, secure, operate, and scale Elasticsearch to search, analyze, and visualize data in real-time.

Answer 4

“Amazon ElastiCache”
• IN memory data store or cache in cloud
• Fully managed in memory caches

Question 5

AWS DB migration service (DMS)

Answer 5

• Orchestrates the migration of databases over o AWS easily and securely
• It migrates from One DB type to another example. e.g. Oracle –> Amazon Aurora

Question 6

____________ is a fast, reliable, fully-managed graph database service that makes it easy to build and run applications that work with highly connected datasets.

Answer 6

“Amazon Neptune”
• Fast, reliable and fully managed graph DB service
• It has graph db engine
You can house billions relationships and querying graph with millisecond latency

Question 7

How each database service configurations could be used:

Scenario - Have an Oracle DB and migrate it to Amazon Aurora

Answer 7

• Launch a RDS instance in VPC

* Use DB Migrations workflow/job

Question 8

How each database service configurations could be used:

Scenario - Getting high volume of requests for frequently accessed data

Answer 8

• Elastic cache node can be put in front of the RDS node
• Since it is delivered from memory and not hard drive - it will be quick
Any request which is not on Cache will then go to the DB

Question 9

______ helps you migrate databases to AWS easily and securely.

Answer 9

“AWS Database Migration Service”

• The source database remains fully operational during the migration
• Supports homogeneous (Oracle to Oracle) & heterogeneous migrations (Oracle to Amazon Aurora)

Question 10

With Amazon RDS, Amazon is committed to manage

Answer 10

• OS Install and patching
• DB software Install and patching
• DB Backups
• Ensures high availability - with multi AZ deployment
• Scaling
• Server Maintenance
• Provisioning - Power, Racking and stacking servers