AWS Solutions Architect Associate > AWS Database > Flashcards

AWS Database Flashcards

(49 cards)

Study These Flashcards
1
Q

Amazon RDS

A
  • Managed RDMS Service
  • Mysql, postgres, oracle, sqlserver, mariadb
  • Encrypted during creation only
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

AWS Dynamo DB

A
  • No SQL DB

- Sync replicated across 3 AZs in a Region

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

AWS Dynamo DB Read Models

A
  • Eventual - Default

- Strongly

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

AWS Dynamo DB Global Tables

A
  • read and write locally
  • Allows Cross Region Replication
  • Multi-Region and Multi-Master
  • Specify the Regions - AWS does it all for you
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Dynamo DB Accelerator (DAX)

A
  • Fully managed & Highly available Cache
  • In memory
  • In proves performance on both reads and writes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Dynamo DB Transactions

A
  • Used to achieve ACID compliance

-

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

AWS RDS Multi-AZ

A
  • Used for DR option
  • Highly Durable
  • Only Primary is active
  • Auto Failover - 1 to 2 mins
  • Sync Replication
  • Backup on Standby
  • maintenance on standby
  • Upgrade Engine on Primary/Standby together with downtime
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Dynamo DB Streams

A
  • Ordered Sequence of item level modifications

- Stored in a Log for 24 hours

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

Aurora Global Database

A
  • For global applications
  • Cross Region Cluster with Read scaling
  • Can remove secondary and promote
  • uses storage replication
  • 1 primary regions / 5 secondary regions
  • 16 Read Replicas per regions
  • RTO < 1 min
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Aurora Serverless

A
  • On-Demand Serverless DB
  • Does not support Read Replicas
  • Infrequent, intermittent, or unpredictable workloads
  • Can migrate between Standard and Serverless via console
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Aurora Serverless Use Cases

A
  • Infrequently used apps
  • new applications
  • variable workloads
  • unpredictable workloads
  • development and test
  • multi-tenant apps
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Aurora MySQL Replicas

A
  • Cross Regions cluster with read scalling
  • Failover target with mins of data loss
  • Up to 5
  • Performance impact is high
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Aurora Multi-Master

A
  • High Avail and ACID transactions in a single Region
  • Scales our writes within a region
  • All Nodes are reads and writes
  • Open a connection to another writer on failure
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

RDS Read Replicas

A
  • Used for Heavy Read workloads
  • same AZ, cross AZ, or cross region - up to 5
  • Async Replication
  • Each has a unique endpoint
  • Can promote to Standalone instance
  • Not for MS SQL Server
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

RDS Multi-AZ vs Read-Replicas

A
  • Sync vs Async
  • Only Primary is active vs all replicas are active
  • Backups from Standby vs no backups by default
  • Always spans 2 AZs vs Same, Different, or Diff region
  • Auto failover vs can be promoted to Standalone
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Aurora Machine Learnign

A
  • Add ML-Based predictions to your apps via sql

- Simple integration between DB and ML

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

Amazon Aurora

A
  • Mysql or prostres compatible RDBMS for Cloud
  • Distributed fault tolerant self-healing Storage sytems
  • 6 copies in 3 AZs
  • 4 Writes / 3 Reads
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

AWS Redshift

A
  • SQL Based Data warehouse for OLAP UseCases

- complex queries against PBs of structured data

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

How can RDS Read Replicas increase availablity

A
  • Multi-AZ
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Dynamo DB read replicas

Study These Flashcards
A
  • There are no read replicas
21
Q

RDS Database Failover

Study These Flashcards
A
  • Handled automatically by RDS
  • CNAME is changed to point to Standby
  • 1 to 2 mins
22
Q

Aurora Replicas

Study These Flashcards
A
  • In region read scaling and failover targets
  • Up to 15
  • Peformance impact is low
  • can act as auto failover with no data loss
  • auto failover
23
Q

Use as a web session Store

24
Q

Use for Database Caching of RDS

25
Used for Leaderboards for your mobile apps
Redis
26
MEMCACHED
- Simple Cache - No Encryption - No Compliance - Multi-Threads - Not highly available
27
Redis
- complex cache - can be encrypted - can support compliance - can support failover - Data partitioning - cluster mode only
28
Memcached High Availability
- no replication - Using multiple nodes in each shard - multiple nodes across AZs
29
Redis High Availablity
- Use multiple nodes in each shard across multiple AZs - Enable Multi-AZ on the replication group to permit auto failover - Schedule regular backups
30
What is the DB solution for Aurora MySQL DR strategy, cross region, with RTO of 10 minuets and RPO of 5 mins?
Aurora Global Database - Cross region | MySQL Replicas - will work cross region but the RPO/RTO is longer
31
Used for complex queries against an S3 Data Lake
Redshift spectrum
32
Allows a password to be used to access a Redis DB
Redis AUTH command
33
Steps to migrate a large DB using Snowball Edge
- Use the SCT to extract and load to snowball - Ship the edge device - Edge loads to S3 - DMS to migrate the data to a data store
34
Can efficiently query and retrieve structured and unstructured data from files in S3 without having to load the data into tables.
Redshift Spectrum
35
Type of replication used from primary to standby in RDS multi AZ?
Sync
36
Type of replication used from primary to read replica in RDS?
Async
37
Does RDS have multi-Master capability?
No. That’s an aurora feature
38
Dynamo DB Best practice
Store more freq and less freq accessed data in diff tablets Store Objects larger than 400kb in s3 with pointers in dynamo
39
Time it takes for an RDS restore
5 mins
40
Does the RDS restore overwrite the DB?
No
41
What security group does the restored RDS DB use
Default SG
42
Are RDS Read Replicas only in a single region
No... they can be in multiple regions
43
Dynamo DB Auto Scaling
Amazon DynamoDB auto scaling uses the AWS Application Auto Scaling service to dynamically adjust provisioned throughput capacity on your behalf, in response to actual traffic patterns.
44
what configurations are needed when an on-prem app needs AWS RDS DB access.
- Security group to allow access from the on prem-ip | - Make RDS public so the on-prem app can see it
45
Can you scale DynamoDB using EC2 Auto Scaling groups
No... uses application scaling
46
A Read Replica of an Amazon RDS encrypted instance is also encrypted using the same key as the master instance when both are in the same Region. When in different Regions, a different key can be used.
true
47
When using the provisioned capacity pricing model DynamoDB does not automatically scale.
true
48
DynamoDB can automatically scale when using the new on-demand capacity mode
true
49
Can you enable storage auto-scaling for RDS MySQL
Yes
AWS Solutions Architect Associate
flashcards
Decks in class (8)
# Cards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2026 Bold Learning Solutions. Terms and Conditions