Section 5: Databases on AWS

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? A) 500 GB B) 1 TB C) 6 TB D) 16 GB E) 32 TB

16 GB

My SQL installations default to port number ______. A) 1433 B) 3306 C) 3389 D) 80

3306

In RDS, what is the maximum value I can set for my backup retention period? a) 15 days b) 30 days c) 35 days d) 45 days

35 Days

How many copies of my data does RDS - Aurora store by default? A)3 B) 6 C) 2 D) 1

6

You are hosting a MySQL database on the root volume of an EC2 instance. The database is using a large number of IOPS, and you need to increase the number of IOPS available to it. What should you do? A) migrate the database to an S3 bucket B) Migrate the database to Glacier C) Add 4 additional EBS SSD volumes and create a RAID 10 using these volumes D) Use CloudFront to cache the database

Add 4 additional EBS SSD volumes and create a RAID 10 using these volumes

Which set of RDS database engines is currently available? A) Aurora, MySQL, SQL Server, Cassandra B) PostgreSQL, MariaDB, MongoDB, Aurora C) MariaDB, SQL Server, MySQL, Cassandra D) Oracle, SQL Server, MySQL, PostgreSQL

D) Oracle, SQL Server, MySQL, PostgreSQL

Which of the following is not a feature of DynamoDB? A) The ability to perform operations by using a user-defined primary key B) Data reads that are either eventually consistent or strongly consistent C) The primary key can either be a single-attribute or a composite D) The ability to store relational-based data

D) The ability to store relational-based data DynamoDB is the AWS managed NoSQL database service. It has many features that are being added to constantly, but it is not an RDBMS service and therefore it will never have the ability to store relational data. All of the other options listed are valid features of DynamoDB.

Which of the following AWS service is a non-relational database? A) RDS B) Redshift C) DynamoDB D) ElastiCache

Dynamo

AWS's NoSQL product offering is known as ____ A) RDS B) DynamoDB C) MongoDB D) MySQL

DynamoDB

If I wanted to run a database on an EC2 instance, which of the following options would Amazon recommend? A) RDS B) S3 C) Glcier D) EBS

EBS

If you want your application to check RDS for an error, have it look for an ______ node in the response from the Amazon RDS API. A) Incorrect B) Error C) Abort D) Exit

Error

You can RDP or SSH into an RDS instance to see what is going on with the OS. True or False

False

When you add a rule to RDS DB Security group, you must specify a port number or protocol. True or False

False Technically a destination port number is needed, however with a DB security group the RDS instance port number is automatically applied to the RDS DB Security Group.

What happens to the I/O operations while you take a database snapshot/backup? a) Nothing b) I/O may be briefly suspended while the backup process initializes (typically under a few seconds), and you may experience a brief period of elevated latency. c) I/O operations to the database are sent to a Secondary instance of a Multi-AZ installation (for the duration of the snapshot) d) I/O operations will be functioning normally

I/O may be briefly suspended while the backup process initializes (typically under a few seconds), and you may experience a brief period of elevated latency. I/O may be briefly suspended while the backup process initializes (typically under a few seconds), and you may experience a brief period of elevated latency.

Under what circumstances would I choose provisioned IOPS storage when created an RDS storage? A) If you use online transaction processing in your production environment B) if you have workloads that are not sensitive to latency/lag C) if your business was trying to save money D) If this was a test DB

If you use online transaction processing in your production environment

In RDS, changes to the backup window take effect... a) After 30 minutes b) The next day c) Immediately d) You cannot back up in RDS

Immediately

Which AWS DB platform is most suitable for OLTP? A) ElastiCache B) RDS C) DynamoDB D) Redshift

RDS

Amazon's Elasticache uses which two engines?

Redis & Memcached

Which AWS service is ideal for Business Intelligence Tools/Data Warehousing? A) Elastic Beanstalk B) ElastiCache C) DynamoDB D) Redshift

Redshift

Which of the following is most suitable for OLAP? A) ElastiCache B) RDS C) DynamoDB D) Reshift

Redshift

What data transfer charge is incurred when replicating data from your primary RDS instance to your secondary RDS instance? A) The charge is double the standard data transfer charge B) The charge is the same as the standard data transfer charge C) There is no charge associated with this action D) The charge is half of the standard data transfer charge

There is no charge associated with this action

RDS Reserved Instances are available for Multi-AZ deployments. True or False?

True

When creating an RDS instance you can select which availability zone in which to deploy your instance. A. True B. False

True

With new RDS DB instances, automatic backups are enabled by default

True