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.
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 DynamoDB
- Amazon Aurora
- Amazon Relational Database Service
- Amazon Timestream
- Amazon Neptune
- Amazon Quantum Ledger Database (QLDB)
- 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
- MariaDB
- DynamoDB
- SQL Server
- 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
- Vertical Scaling
- Horizontal Scaling
- 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
- 90 minutes
- 45 minutes
- 30 minutes
- 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
- SQL Server
- Redshift
- Aurora
- 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
- DynamoDB
- Neptune
- Redshift
- MariaDB
Correct Answer is – DynamoDB
Q.6 Database backup in S3 is free until 100% of database size.
Choose correct option from below list
- True
- False
Correct Answer is – True
Q.7 DAX is an in-memory cache for DynamoDB.
Choose correct option from below list
- True
- 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
- True
- False
Correct Answer is – True
Q.9 DynamoDB is backed by _ type of disks, by default.
Choose correct option from below list
- HDD
- SDD
- 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
- Index
- Query
- Streams
- 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
- 0.99
- 0.9999
- 0.9996
- 0.9995
Correct Answer is – 0.9999
Q.12 By default, Aurora has __ configured.
Choose correct option from below list
- Backup
- Multi-AZ
- Read-replica
- 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
- 10, 3
- 10, 4
- 15, 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
- True
- False
Correct Answer is – True
Q.16 ElastiCache for memcached supports snapshots.
Choose correct option from below list
- True
- False
Correct Answer is – False
Q.17 Only DNS is provided for the SQL server, and not IPV4.
Choose correct option from below list
- True
- 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
- True
- False
Correct Answer is – True
Q.19 Read replicas can be promoted to become databases on their own.
Choose correct option from below list
- True
- False
Correct Answer is – True
Q.20 Can Multi AZ deployment be used for improving performance of DB ?
Choose correct option from below list
- True
- False
Correct Answer is – False
Q.21 The maximum number of compute nodes a cluster can have is __.
Choose correct option from below list
- 128
- 64
- 80
- 160
Correct Answer is – 128
Q.22 Which of the following search queries uses indexes?
Choose correct option from below list
- Scan
- Query
- 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
- Snowball
- DMS
- Snowmobile
- 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
- 10 or 30
- 12 or 36
- 15 or 30
- All the options
Correct Answer is – 12 or 36
Q.25 Aurora can scale up to _.
Choose correct option from below list
- 128GB
- 64TB
- 128TB
- 64GB
Correct Answer is – 128TB
Q.26 Aurora is __ times faster than the regular PostgreSQL database.
Choose correct option from below list
- 3
- 5
- 2
- 4
Correct Answer is – 3
Q.27 Aurora is __ times faster than the regular MySQL database.
Choose correct option from below list
- 3
- 5
- 2
- 4
Correct Answer is – 5
Q.28 In columnar database, compression of data is easy.
Choose correct option from below list
- True
- False
Correct Answer is – True
