EC2 Exam Questions Flashcards

1
Q

If I wanted to run a database on an EC2 instance, which storage option would Amazon recommend?

A

EBS - Elastic Block Store

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What data transfer charge is incurred when replicating data from your primary RDS instance to your secondary RDS instance?

A

There is no charge associated with this action.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How many copies of my data does RDS - Aurora store by default?

A

6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

RDS Reserved instances are available for multi-AZ deployments.

True/False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which AWS DB platform is most suitable for OLTP?

A

RDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which of the following AWS services is a non-relational database?

DynamoDB
RDS
Redshift
ElastiCache

A

DynamoDB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which AWS service is ideal for Business Intelligence Tools/Data Warehousing?

A

Redshift

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You can RDP or SSH into an RDS instance to see what is going on with the operating system. T/F

A

F

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

Error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Under what circumstance would I choose provisioned IOPS over standard storage when creating an RDS instance?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Which AWS service is most suitable for OLAP?

A

Redshift would be the most suitable for online analytics processing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

When you add a rule to an RDS DB security group, you must specify a port number or protocol.

T/F

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

When creating an RDS instance, you can select the Availability Zone into which you deploy it.

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

With new RDS DB instances, automated backups are enabled by default? T/F

A

T

17
Q

In RDS, changes to the backup window take effect ____.

A

Immediately

18
Q

MySQL installations default to port number ____.

A

3306

19
Q

In RDS, what is the maximum value I can set for my backup retention period?

A

35 Days

20
Q

AWS’s NoSQL product offering is known as ____.

A

DynamoDB

21
Q

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

16TB

22
Q

Which set of RDS dat
database engines is currently available?

Oracle, SQL Server, MySQL, PostgreSQL
MariaDB, SQL Server, MySQL, Cassandra
PostgreSQL, MariaDB, MongoDB, Aurora
Aurora, MySQL, SQL Server, Cassandra

A

Oracle, SQL Server, MySQL, PostgreSQL

23
Q

Which of the following is not a feature of DynamoDB?

The ability to perform operations by using a user-defined primary key
Single availability zone by default
The primary key can either be a single-attribute or a composite
Data reads that are either eventually consistent or strongly consistent

A

Single availability zone by default

DynamoDB is the AWS managed NoSQL database service. It has many features that are being added to constantly, making it a great service to use for many different requirements. The feature which was incorrect is DynamoDB only being single availability zone by default making this the correct answer. DynamoDB is distributed across three geographically distinct datacentres by default, all of the other options listed are valid features of DynamoDB.

24
Q

Which of the following data formats does Amazon Athena support?

Apache Parquet
Apache ORC
XML
JSON

A

Apache Parquet
Apache ORC
JSON

Why is this correct?
Amazon Athena is an interactive query service that makes it easy to analyse data in Amazon S3, using standard SQL commands. It will work with a number of data formats including “JSON”, “Apache Parquet”, “Apache ORC” amongst others, but “XML” is not a format that is supported.

Amazon Athena is an interactive query service that makes it easy to analyse data in Amazon S3, using standard SQL commands. It will work with a number of data formats including “JSON”, “Apache Parquet”, “Apache ORC” amongst others, but “XML” is not a format that is supported.

Amazon Athena is an interactive query service that makes it easy to analyse data in Amazon S3, using standard SQL commands. It will work with a number of data formats including “JSON”, “Apache Parquet”, “Apache ORC” amongst others, but “XML” is not a format that is supported.

25
Q

What happens to the I/O operations of a single-AZ RDS instance during a database snapshot or backup?

A

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.

26
Q

Amazon’s ElastiCache uses which two engines?

A

Redis & Memcached