EC2 Exam Questions Flashcards
If I wanted to run a database on an EC2 instance, which storage option would Amazon recommend?
EBS - Elastic Block Store
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.
How many copies of my data does RDS - Aurora store by default?
6
RDS Reserved instances are available for multi-AZ deployments.
True/False
True
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?
Add 2 additional EBS SSD volumes and create a RAID 0 volume to host the database.
*RAID 0 provides performance improvements compared with a single volume as data can be read and written to multiple disks simultaneously. 2 disks, each with a bandwidth of 4,000 IOPS will provide a combined bandwidth of 8,000 IOPS.
Which AWS DB platform is most suitable for OLTP?
RDS
Which of the following AWS services is a non-relational database?
DynamoDB
RDS
Redshift
ElastiCache
DynamoDB
Which AWS service is ideal for Business Intelligence Tools/Data Warehousing?
Redshift
Which of the following DynamoDB features are chargeable, when using a single region?
Read and Write Capacity
Incoming Data Transfer
Storage of Data
The number of tables created
Read and Write Capacity
Storage of Data
Why is this correct?
There will always be a charge for provisioning read and write capacity and the storage of data within DynamoDB, therefore these two answers are correct. There is no charge for the transfer of data into DynamoDB, providing you stay within a single region (if you cross regions, you will be charged at both ends of the transfer.) There is no charge for the actual number of tables you can create in DynamoDB, providing the RCU and WCU are set to 0, however in practice you cannot set this to anything less than 1 so there always be a nominal fee associated with each table.
Why is this correct?
There will always be a charge for provisioning read and write capacity and the storage of data within DynamoDB, therefore these two answers are correct. There is no charge for the transfer of data into DynamoDB, providing you stay within a single region (if you cross regions, you will be charged at both ends of the transfer.) There is no charge for the actual number of tables you can create in DynamoDB, providing the RCU and WCU are set to 0, however in practice you cannot set this to anything less than 1 so there always be a nominal fee associated with each table.
You can RDP or SSH into an RDS instance to see what is going on with the operating system. T/F
F
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.
Error
Under what circumstance would I choose provisioned IOPS over standard storage when creating an RDS instance?
If you use online transaction processing in your production environment.
Provisioned IOPS becomes important when you are running production environments requiring rapid responses, such as those which run e-commerce websites. Without high performant responses from an RDS instance page loads of the website could suffer resulting in loss of business. If your workloads are not latency sensitive or you are running a test environment the additional cost of provisioned IOPS will not be cost beneficial to your project.
Which AWS service is most suitable for OLAP?
Redshift would be the most suitable for online analytics processing.
When you add a rule to an RDS DB security group, you must specify a port number or protocol.
T/F
F
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.
When creating an RDS instance, you can select the Availability Zone into which you deploy it.
T