Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Amazon AWS Certified Solutions Architect Associate > Databases > Flashcards

Databases Flashcards

1
Q

What database services are available on AWS?

A 
RDS (OLTP)
DynamoDB (NoSQL)
RedShift (OLAP)
Elasticache (in memory caching)
DMS
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is Multi-AZ RDS?

A

Multi-AZ allows to have an exact copy of your production database in another AZ. In the event of planned DB maintenance, BD instance failure, or an Availability Zone failure, Amazon RDS will automatically failover to the standby.

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

What is the use case for Multi-AZ RDS

A

Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.

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

Can Multi-AZ be used to performance improvement?

A

No. Multi-AZ is for disaster recovery. It is not used for improving performance. For performance improvement, Read Replicas are needed.

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

For which RDS databases “Read Replicas” is supported?

A

MySQL
MariaDB
PostgreSQL
Amazon Aurora

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

What is the use case for Read Replicas?

A

Read Replicas are used for scaling, not for disaster recovering.

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

How many Read Replicas can be added to a RDS BD?

A

Amazon RDS allow you to add up to 5 read replicas to each DB Instance.

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

Can Multi-AZ databases have Read Replicas?

A

Yes. You can create Read Replicas of Multi-AZ source databases.

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

How can you scale up in RDS?

A

It’s a manual process.

  • Snapshot, Restore changing instance size.
  • Read replica with bigger size.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What NoSQL data models support DynamoDB?

A

Document and key-value data models.

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

What kind of storage does DynamoDB uses?

A

Stored on SSD storage.

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

How is DynamoDB spread?

A

Spread across 3 geographically distinct data centers.

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

What Read Consistency models does DynamoDB supports?

A

Eventual Consistent Reads (default)

Strongly Consistent Reads.

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

What is “Eventual Consistent Reads”?

A

Consistency across all copies of data is usually reached within a second.

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

What is “Strongly Consistent Reads”?

A

A Strongly Consistent Read returns a result that reflects all writes that received a successful response prior to the read.

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

What AWS platform is most suitable for OLTP?

A

RDS/DynamoDB

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

Aurora Scaling

A
  • 6 copies of data: 2 in each of a minimum of 3 AZs.
  • Designed to handled transparently the loss of up to 2 copies of data without affecting write availability and 3 without affecting read availability.
  • Self-healing (data blocks and disks continuously scanned)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What are the available RDS Database types?

A
  • SQL Server
  • Oracle
  • MySQL
  • PostgreSQL
  • MariaDB
  • Amazon Aurora
19
Q

For which type of workloads is RDS suitable?

A

For OLTP workloads (not OLAP)

20
Q

For which type of workloads is Redshift suitable?

A

For OLAP. Use Redshift for DWH and OLAP tasks.

21
Q

What’s the primary use case for RDS Read Replicas?

A

Read Replicas are used to scale read performance, not for disaster recovery. Great for read-heavy workloads, to take the load off your primary database for read-only workloads (e.g., Business Intelligence reporting job)

22
Q

What’s required in order to deploy a read replica?

A

Automatic backups must be enabled in order to deploy a read replica

23
Q

Are multiple Read Replicas supported?

A

Yes. MySQL, MariaDB, PostgreSQL, Oracle and SQL Server allow you to add up to 5 read replicas to each DB instance

24
Q

What is RDS Multi-AZ?

A
  • An exact copy of your production database in another AZ
  • Used for disaster recovery
  • In the event of failure, RDS will automatically failover to the standby instance
25
What's the primary use case for RDS Multi-AZ?
RDS Multi-AZ is used for disaster recovery (not to improve performance)
26
Where can the Read Replica live?
In the same AZ, cross-AZ, or cross-region
27
Characteristics of the Aurora copies
2 copies of your data are contained in each AZ, with a minimum of 3 AZ. 6 copies of your data
28
Can you share Aurora snapshots?
Yes. You can share Aurora snapshots with other AWS accounts
29
What types of replicas are available for Aurora?
3 types of replicas are available. Aurora replicas, MySQL replicas, and PostgreSQL replicas. Automated failover is only available with Aurora replicas.
30
When to use Aurora serverless? (vs Aurora RDS)
Aurora serverless provides a relatively simple, cost-effective option for infrequent, intermittent, or unpredictable workloads
31
What kind of storage type does DynamoDB use?
SSD storage
32
How is DynamoDB spread?
Across 3 geographically distinct data centres
33
What's the read model for DynamoDB?
Eventually consistent reads by default. Strongly consistent reads are available
34
What's the difference between eventually consistent reads and strongly consistent reads?
Eventual consistency across all copies of data is usually reached within a second. Repeating a read after a short time should return the updated data. Best read performance. A strongly consistent read returns a result that reflects all writes that received a successful response prior to the read.
35
Does DynamoDB support transactions?
Yes
36
DynamoDB transactions characteristics
- 3 options for reads: eventual consistency, strong consistency and transactional - 2 options for writes: standard and transactional - Up to 25 items or 4MB of data
37
How can DynamoDB provide ACID capabilities?
Through transactions
38
How does DynamoDB On-Demand Backup and Restore work?
- Full backups at any time - Zero impact on table performance or availability - Consistent within seconds and retained until deleted - Operates within the same region as the source table
39
Is DynamoDB Point-in-Time Recovery (PITR) enabled by default?
No
40
DynamoDB Point-in-Time Recovery (PITR) characteristics
- Protects against accidental writes or deletes - Restore to any point in the last 35 days - Incremental backups - Not enabled by default - Latest restorable: 5 minutes in the past
41
DynamoDB Streams characteristics
- Time-ordered sequence of item-level changes in a table - Stored for 24 hours - Inserts, updates, and deletes - Combine with Lambda functions for functionality like stored procedures
42
DynamoDB Global Tables characteristics
Managed Multi-Master, Multi-Region Replication - Globally distributed applications - Based on DynamoDB Streams - Multi-Region redundancy for disaster recovery or high availability - No application rewrites - Replication latency under one second
43
Can RDS storage scale back down?
No. RDS storage only scales up. It won't scale back down.

Amazon AWS Certified Solutions Architect Associate (16 decks)

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