Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

AWS Solutions Architect > Section 9 AWS Fundamentals: RDS + Aurora + Elasticache > Flashcards

Section 9 AWS Fundamentals: RDS + Aurora + Elasticache Flashcards

1
Q

AWS database engines supported

A

Postgres
MySQL
MariaDB
Oracle
MS SQL server
IBM DB2
Aurora

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

True or False. RDS has storage auto scaling

A

True

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

When does RDS storage auto scaling kick in?

A

Free storage is less than 10% of allocated storage
Low storage lasts for 5 minutes
6 hours have passed since last modification

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

Where can RDS read replicas be deployed

A

Within same AZ
Across az’s
Cross region

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

What is the limit on RDS read replicas

A

15

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

In RDS replicas, replication uses what type of SYNC?

A

ASYNC

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

What does ASYNC mean in RDS replicas?

A

Eventually cosistent

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

True or False. Read replicas can be promoted to their own DB

A

True

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

Read replicas are used for what type of statements

A

Select(read)

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

FOR RDS read replicas, this traffic is free

A

Within the same region

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

Can read replicas be setup as multi AZ for DR

A

Yes

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

Changing an RDS database from single AZ to Multi AZ

A

Don’t need to stop the DB
Clicking modify and enable multi AZ

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

Which database engines can RDS custom be used with

A

Managed oracle
MS SQL Server

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

What does RDS custom provide

A

access to underlying database
OS access
Access EC2 instance with SSH

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

What is recommended to do before any customization in RDS custom?

A

De-activate automation mode
DB snapshot

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

AWS Aurora DBs work with which DB engines?

A

Postgres
MySQL

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

AWS Aurora starts and ends at what storage amounts

A

Increments of 10gb up to 128tb

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

How many read replicas can Aurora have

A

15

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

In aurora how many masters are there

A

1

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

Does aurora have cross region replication

A

Yes

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

In Aurora db cluster what are the two endpoints?

A

Writer
Reader

22
Q

In Aurora db cluster what is the writer endpoint for?

A

Pointing to the master

23
Q

In Aurora db cluster what is the reader endpoint for?

A

Connects automatically to all the load balanced read replicas

24
Q

What endpoint is typically not used when creating custom endpoints?

A

reader endpoint

25
Under what scenario would you want to use Aurora Serverless
unpredictable workloads infrequent workloads
26
What type of Aurora is good for disaster recovery
Global
27
Typical cross region replication takes how much time in Aurora Global
less than 1 second
28
Which2 services are supported by Aurora ML
Sagemaker Comprehend
29
Use cases for Aurora ML
Fraud detection ads targeting sentiment analysis product recommendations
30
If you plan on stopping an RDS database for a long time how can you save money?
Create a snapshot of the database and delete the original database
31
RDS automated full backups occur how frequently?
daily
32
Manual RDS snapsots have how long of a retention?
No time limit
33
With Aurora backups how long back can you restore from
1 to 35 days
34
Can Aurora backups be disabled?
No
35
You can restore this DB from and S3 bucket
MySQL RDS MySQL Aurora
36
Which backup utility must you use to restore a MySQL Aurora DB from S3
Percona XtraBackup
37
With this aws service you can create a new Aurora DB cluster from an existing one
Aurora Database cloning
38
Aurora Database Cloning uses what protocol to transfer data
copy-on-write
39
With RDS and Aurora what types of encryption are used
At-rest In-flight
40
What IAM auth can RDS and Aurora use to connect to your database
IAM roles
41
How can you control network access to your RDS or Aurora DB
security groups
42
Which database type has SSH
RDS custom
43
What RDS capability can be used to reduce stress on database resources
RDS proxy
44
What RDS capability can be used to reduce failover times?
RDS Proxy
45
How can you force IAM auth to RDS dbs
RDS proxy
46
Are RDS proxies public or private
Private
47
This DB solution can reduce load on a db for read intensive workloads
ElastiCache
48
Two versions of ElastiCache
Redis Memcached
49
3 kinds of patterns for loading data into ElastiCache
Lazy loading Write Through Session Store
50
What is a use case for ElastiCache with Redis?
Gaming leaderboards
51
What function within Redis guarantees both uniqueness and element ordering?
Redis Sorted Sets

AWS Solutions Architect (13 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions