Skip to content

AWS Databases

Q&A

  • Which of the following is not a feature of DynamoDB? The ability to store relational-based data.
  • What happens to the I/O operations of a single-AZ RDS instance during a database snapshot or backup? I/O may be briefly suspended while the backup process initializes (typically under a few seconds), and you may experience a brief period of latency.
  • Can you RDP or SSH into an RDS instance to see what is going on within the OS? No.
  • AWS's NoSQL product offering is known as DynamoDB.
  • Which set of RDS database engines is currently available? Oracle, SQL Server, MySQL, PostgreSQL
  • When creating an RDS instance, you can select the AZ into which you deploy it. TRUE
  • RDS Reserved Instances are available for multi-AZ deployments. TRUE
  • In RDS, what is the maximum value I can set for my backup retention period? 35 days
  • If I wanted to run a database on an EC2 instance, which of the following storage options would Amazon recommend? EBS
  • How many copies of my data does RDS - Aurora store by default? 6
  • MySQL installations default to port number 3306
  • If you want your application to check RDS for an error, have it look for an ____ node in the response from Amazon RDS API. Error
  • Which AWS RDS platform is most suitable for OLTP? RDS
  • Which AWS service is most suitable for OLAP? Redshift
  • Which AWS service is ideal for Business Intelligence Tools/Data Warehousing? Redshift
  • What data transfer charge is incurred when replicating data from your primary RDS instance to your secondary RDS instance? There is no charge associated with this action.
  • Under what circumstances would I choose provisioned IOPS over standard storage when creating an RDS instance? If you use OLTP in your production environment.
  • If you are using Amazon RDS Provisioned IOPS storage with a Microsoft SQL Server database engine, what is the maximum size RDS volume you can have by default? 16TB
  • Which of the following is a non-relational database? DynamoDB
  • In RDS, changes to the backup window take effect immediately.
  • Amazon's ElastiCache uses which two engines? Redis & Memcached
  • When you add a rule to RDS DB security group, you must specify a port number or protocol? FALSE