Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AWS Solutions Architect Associate > AWS Database > Flashcards

AWS Database 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

A
  • There are no read replicas
21
Q

RDS Database Failover

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

Aurora Replicas

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

A

memcached

24
Q

Use for Database Caching of RDS

A

Memcached

25
Q

Used for Leaderboards for your mobile apps

A

Redis

26
Q

MEMCACHED

A
  • Simple Cache
  • No Encryption
  • No Compliance
  • Multi-Threads
  • Not highly available
27
Q

Redis

A
  • complex cache
  • can be encrypted
  • can support compliance
  • can support failover
  • Data partitioning - cluster mode only
28
Q

Memcached High Availability

A
  • no replication
  • Using multiple nodes in each shard
  • multiple nodes across AZs
29
Q

Redis High Availablity

A
  • Use multiple nodes in each shard across multiple AZs
  • Enable Multi-AZ on the replication group to permit auto failover
  • Schedule regular backups
30
Q

What is the DB solution for Aurora MySQL DR strategy, cross region, with RTO of 10 minuets and RPO of 5 mins?

A

Aurora Global Database - Cross region

MySQL Replicas - will work cross region but the RPO/RTO is longer

31
Q

Used for complex queries against an S3 Data Lake

A

Redshift spectrum

32
Q

Allows a password to be used to access a Redis DB

A

Redis AUTH command

33
Q

Steps to migrate a large DB using Snowball Edge

A
  • 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
Q

Can efficiently query and retrieve structured and unstructured data from files in S3 without having to load the data into tables.

A

Redshift Spectrum

35
Q

Type of replication used from primary to standby in RDS multi AZ?

A

Sync

36
Q

Type of replication used from primary to read replica in RDS?

A

Async

37
Q

Does RDS have multi-Master capability?

A

No. That’s an aurora feature

38
Q

Dynamo DB Best practice

A

Store more freq and less freq accessed data in diff tablets

Store Objects larger than 400kb in s3 with pointers in dynamo

39
Q

Time it takes for an RDS restore

A

5 mins

40
Q

Does the RDS restore overwrite the DB?

A

No

41
Q

What security group does the restored RDS DB use

A

Default SG

42
Q

Are RDS Read Replicas only in a single region

A

No… they can be in multiple regions

43
Q

Dynamo DB Auto Scaling

A

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
Q

what configurations are needed when an on-prem app needs AWS RDS DB access.

A
  • Security group to allow access from the on prem-ip

- Make RDS public so the on-prem app can see it

45
Q

Can you scale DynamoDB using EC2 Auto Scaling groups

A

No… uses application scaling

46
Q

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.

A

true

47
Q

When using the provisioned capacity pricing model DynamoDB does not automatically scale.

A

true

48
Q

DynamoDB can automatically scale when using the new on-demand capacity mode

A

true

49
Q

Can you enable storage auto-scaling for RDS MySQL

A

Yes

AWS Solutions Architect Associate (8 decks)

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