Amazon Database Interview Questions and Answers 2022

Amazon Database or Amazon Web Services provide a wide range of database solutions to its clients. Depending upon the nature of the data and the cost constraints of the client these various database types serve all users accordingly.

Amazon Database interview questions

Advantages of AWS

  • Highly Scalable: You can scale your database as your application grows without any downtime!
  • Fully Managed: Everything, from maintenance to hardware upgrades, is managed by AWS.
  • Enterprise Class: You get the same world-class infrastructure used by Amazon’s giant ecommerce platform.
  • Distributed: Now that your application and database exist on separate machines, your application becomes highly fault-tolerant.
  • Workforce Reduction: Since everything is managed by AWS, you don’t need a Database Maintenance team in your organization.

Various Amazon databases that are provided by the Amazon Web Services(AWS) are :

Amazon Database
  1. Amazon DynamoDB
  2. Amazon Aurora
  3. Amazon Relational Database Service
  4. Amazon Timestream
  5. Amazon Neptune
  6. Amazon Quantum Ledger Database (QLDB)
  7. Amazon RDS on VMware

Q.1 Which of the following is the Non-Relational DB service offered by AWS?
Choose correct option from below list

  1. MariaDB
  2. DynamoDB
  3. SQL Server
  4. Aurora

Correct Answer is – DynamoDB

Q.2 Which scaling methodology is opted when the load is increased with nearly equal number of reads and writes?
Choose correct option from below list

  1. Vertical Scaling
  2. Horizontal Scaling
  3. Any of the options

Correct Answer is – Vertical Scaling

Q.3 The default duration of the backup window in RDS is __
Choose correct option from below list

  1. 90 minutes
  2. 45 minutes
  3. 30 minutes
  4. 1 hour

Correct Answer is – 30 minutes

Q.4 Which of the following services can have up to 15 read-replicas?
Choose correct option from below list

  1. SQL Server
  2. Redshift
  3. Aurora
  4. DynamoDB

Correct Answer is – Aurora

Q.5 For heavy gaming, read-intensive apps, IoT, and video hosting sites, __ is preferred.
Choose correct option from below list

  1. DynamoDB
  2. Neptune
  3. Redshift
  4. MariaDB

Correct Answer is – DynamoDB

Q.6 Database backup in S3 is free until 100% of database size.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.7 DAX is an in-memory cache for DynamoDB.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.8 The local secondary index can be created only while creating the table.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.9 DynamoDB is backed by _ type of disks, by default.
Choose correct option from below list

  1. HDD
  2. SDD
  3. Magnetic tapes

Correct Answer is – SDD

Q.10 __ is/are used to trigger lambda functions for changes in DynamoDB.
Choose correct option from below list

  1. Index
  2. Query
  3. Streams
  4. Scan

Correct Answer is – Streams

What is Amazon RDS?

Amazon Relational Database Service (RDS) is a managed SQL database service provided by Amazon Web Services (AWS). Amazon RDS supports an array of database engines to store and organize data. It also helps with relational database management tasks, such as data migration, backup, recovery and patching.

Q.11 The availability SLA of Aurora DB is __
Choose correct option from below list

  1. 0.99
  2. 0.9999
  3. 0.9996
  4. 0.9995

Correct Answer is – 0.9999

Q.12 By default, Aurora has __ configured.
Choose correct option from below list

  1. Backup
  2. Multi-AZ
  3. Read-replica
  4. All the options

Correct Answer is – Multi-AZ

Q.13 Aurora can have upto low-latency replicas in AZs.
Choose correct option from below list

  1. 10, 3
  2. 10, 4
  3. 15, 4
  4. 15, 3

Correct Answer is – 15, 3

Q.14 The service used for migration of database to AWS is __?
Choose correct option from below list
Correct Answer is – DMS

Q.15 Aurora is both MySQL and Postgre SQL compatible?
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.16 ElastiCache for memcached supports snapshots.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – False

Q.17 Only DNS is provided for the SQL server, and not IPV4.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.18 A multi-AZ DB will have a little downtime, and a single AZ will be unavailable during the scaling operation.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.19 Read replicas can be promoted to become databases on their own.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

Q.20 Can Multi AZ deployment be used for improving performance of DB ?
Choose correct option from below list

  1. True
  2. False

Correct Answer is – False

Q.21 The maximum number of compute nodes a cluster can have is __.
Choose correct option from below list

  1. 128
  2. 64
  3. 80
  4. 160

Correct Answer is – 128

Q.22 Which of the following search queries uses indexes?
Choose correct option from below list

  1. Scan
  2. Query
  3. Both the options

Correct Answer is – Query

Q.23 The service used for migration of the database to AWS is __
Choose correct option from below list

  1. Snowball
  2. DMS
  3. Snowmobile
  4. All the options

Correct Answer is – DMS

Q.24 Reserved DB instances can be purchased for __ months, similar to EC2.
Choose correct option from below list

  1. 10 or 30
  2. 12 or 36
  3. 15 or 30
  4. All the options

Correct Answer is – 12 or 36

Q.25 Aurora can scale up to _.
Choose correct option from below list

  1. 128GB
  2. 64TB
  3. 128TB
  4. 64GB

Correct Answer is – 128TB

Q.26 Aurora is __ times faster than the regular PostgreSQL database.
Choose correct option from below list

  1. 3
  2. 5
  3. 2
  4. 4

Correct Answer is – 3

Q.27 Aurora is __ times faster than the regular MySQL database.
Choose correct option from below list

  1. 3
  2. 5
  3. 2
  4. 4

Correct Answer is – 5

Q.28 In columnar database, compression of data is easy.
Choose correct option from below list

  1. True
  2. False

Correct Answer is – True

About Author


After years of Technical Work, I feel like an expert when it comes to Develop wordpress website. Check out How to Create a Wordpress Website in 5 Mins, and Earn Money Online Follow me on Facebook for all the latest updates.