Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Sec. 8: AWS Fundamentals: RDS + Aurora + ElastiCache

Total questions: 24

Worksheet time: 12mins

Name
Class
Date
1.

Amazon RDS supports the following databases, EXCEPT:

a)

MongoDB

b)

MySQL

c)

MariaDB

d)

Microsoft SQL Server

2.

You're planning for a new solution that requires a MySQL database that must be available even in case of a disaster in one of the Availability Zones. What should you use?

a)

Create Read Replicas

b)

Enable Encryption

c)

Enable Multi-AZ

3.

We have an RDS database that struggles to keep up with the demand of requests from our website. Our million users mostly read news, and we don't post news very often. Which solution is NOT adapted to this problem?

a)

An ElastiCache Cluster

b)

RDS Multi-AZ

c)

RDS Read Replicas

4.

You have set up read replicas on your RDS database, but users are complaining that upon updating their social media posts, they do not see their updated posts right away. What is a possible cause for this?

a)

There must be a bug in your application

b)

Read Replicas have Asynchronous Replication, therefore it's likely your users will only read Eventual Consistency

c)

You should have setup Multi-AZ instead

5.

Which RDS (NOT Aurora) feature when used does not require you to change the SQL connection string?

a)

Read Replicas

b)

Multi-AZ

6.

Your application running on a fleet of EC2 instances managed by an Auto Scaling Group behind an Application Load Balancer. Users have to constantly log back in and you don't want to enable Sticky Sessions on your ALB as you fear it will overload some EC2 instances. What should you do?

a)

Use your own custom Load Balancer on EC2 instances instead of using ALB

b)

Store session data in RDS

c)

Store session data in ElastiCache

d)

Store session data in a shared EBS volume

7.

An analytics application is currently performing its queries against your main production RDS database. These queries run at any time of the day and slow down the RDS database which impacts your users' experience. What should you do to improve the users' experience?

a)

Setup a Read Replica

b)

Setup Multi-AZ

c)

Run the analytics queries at night

8.

You are running an ElastiCache Redis cluster which you want to ensure it is high available. What should you do?

a)

Add Read Replicas

b)

Enable Multi-AZ

9.

How can you enhance the security of your ElastiCache Redis Cluster by forcing users to enter a password when they connect?

a)

Use Redis Auth

b)

Use IAM Auth

c)

Use Security Groups

10.

Your company has a production Node.js application that is using RDS MySQL 5.6 as its database. A new application programmed in Java will perform some heavy analytics workload to create a dashboard on a regular hourly basis. What is the most cost-effective solution you can implement to minimize disruption for the main application?

a)

Enable Multi-AZ for the RDS database and run the analytics workload on the standby database

b)

Create a Read Replica in a different AZ and run the analytics workload on the replica database

c)

Create a Read Replica in a different AZ and run the analytics workload on the source database

11.

You would like to create a disaster recovery strategy for your RDS PostgreSQL database so that in case of a regional outage the database can be quickly made available for both read and write workloads in another AWS Region. The DR database must be highly available. What do you recommend?

a)

Create a Read Replica in the same region and enable Multi-AZ on the main database

b)

Create a Read Replica in the same region and enable Multi-AZ on the Read Replica

c)

Create a Read Replica in a different region and enable Multi-AZ on the Read Replica

d)

Enable Multi-Region option on the main database

12.

You have migrated the MySQL database from on-premises to RDS. You have a lot of applications and developers interacting with your database. Each developer has an IAM user in the company's AWS account. What is a suitable approach to give access to developers to the MySQL RDS DB instance instead of creating a DB user for each one?

a)

Enable IAM Database Authentication

b)

Use Amazon Cognito

c)

By default IAM users have access to your RDS database

13.

Which of the following statement is true regarding replication in both RDS Read Replicas and Multi-AZ?

a)

Read Replica uses Asynchronous Replication and Multi-AZ uses Asynchronous Replication

b)

Read Replica uses Synchronous Replication and Multi-AZ uses Asynchronous Replication

c)

Read Replica uses Synchronous Replication and Multi-AZ uses Synchronous Replication

d)

Read Replica uses Asynchronous Replication and Multi-AZ uses Synchronous Replication

14.

How do you encrypt an unencrypted RDS DB instance?

a)

Do it straight from AWS Console, select your RDS DB instance, choose Actions then Encrypt using KMS

b)

Create a snapshot of the unencrypted RDS DB instance, copy the snapshot and tick "Enable encryption", then restore the RDS DB instance from the encrypted snapshot

c)

Do it straight from AWS Console, after stopping the RDS DB instance

15.

For your RDS database, you can have up to ............ Read Replicas.

a)

3

b)

5

c)

7

16.

Which RDS database technology does NOT support IAM Database Authentication?

a)

Oracle

b)

PostgreSQL

c)

MySQL

17.

You have an un-encrypted RDS DB instance and you want to create Read Replicas. Can you configure the RDS Read Replicas to be encrypted?

a)

Yes

b)

No

18.

You can not create encrypted Read Replicas from an unencrypted RDS DB instance.

a)

5

b)

10

c)

15

19.

Amazon Aurora supports both .......................... databases.

a)

MySQL and MariaDB

b)

Oracle and MariaDB

c)

MySQL and PostgreSQL

d)

Oracle and MS SQL Server

20.

What is the maximum number of Read Replicas you can add in an ElastiCache Redis Cluster with Cluster-Mode Disabled?

a)

3

b)

4

c)

5

21.

You have an ElastiCache Redis Cluster that serves a popular application. You have noticed that there are a large number of requests that go to the database because a large number of items are removed from the cache before they expire. What is this called and how to solve it?

a)

Cache Evictions, Scale up or out your ElastiCache Redis Cluster

b)

Cache Invalidations, Scale up or out your ElastiCache Redis Cluster

c)

Cache Evictions, Scale down or in your ElastiCache Cluster

d)

Cache Invalidations, Scale down or in your ElastiCache Cluster

22.

You have a MySQL RDS database instance on which you want to enforce SSL connections. What should you do?

a)

Modify your DB Security Group to only allow SSL traffic

b)

Download SSL certificates from your DB, then use these certificates in your application to connect over SSL

c)

Enable MySQL RDS Database Encryption

d)

Execute a REQUIRE SSL SQL statement to all your DB users

23.

You have an ElastiCache cluster with small cache size, so you want to ensure that only the data that's requested will be loaded into the cluster. Which caching strategy should you use?

a)

Write Through

b)

Lazy Loading

c)

Time-To-Live (TTL)

24.

You're hosting a dynamic website fronted by an ElastiCache Cluster. You have been instructed to keep latency to a minimum for all read requests for every user. Also, writes can take longer to happen. Which caching strategy do you recommend?

a)

Cache Aside

b)

Time-To-Live (TTL)

c)

Write Through