Brainscape's Knowledge GenomeTM

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


See full index

SAA-C02 - AWS Architect Associate > AWS RDS > Flashcards

AWS RDS Flashcards

1
Q

What are the RDS database types?

A 
There are six:
SQL Server
Oracle
MySQL
PostgreSQL
MariaDB
Amazon Aurora
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Can a DynamoDB can be the basis of an RDS instance?

A

No. It isn’t a valid type.

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

What kind of workloads is RDS used for?

A

OLTP - Online Transaction Processing

RDS is great for processing lots of small transactions, like customer orders, banking transaction, payments and booking systems.

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

Is RDS suitable for OLAP workloads?

A

No. You should use Redshift for data warehousing and OLAP tasks, like analyzing large amounts of data, reporting and sales forecasting.

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

What are some advantages of using RDS?

A
  1. You can have an RDS instance up and running in minutes.
  2. Allows multi-AZ.
  3. Built-in failover capacity.
  4. Automated backups.

You avoid a manual install in your own data center which could take 8 days or longer using older, traditional methods.

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

Does AWS RDS handle replication for you?

A

Yes. AWS handles the RDS replication for you. When you write to your production database, this write will automatically synchronize to the standby database.

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

In RDS, can you read from the standby database?

A

No. The standby database is only used for replication and failover if the primary database becomes not available.

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

What RDS types can be configured as Multi-AZ?

A 
SQL Server
Oracle
MySQL
PostgreSQL
MariaDB

NOTE: Amazon Aurora is automatically configured as multi-AZ and cannot be configured as a single AZ.

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

What RDS types cannot be configured as single AZ?

A

Amazon Aurora is automatically configured as multi-AZ and cannot be configured as a single AZ.

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

RDS will _____ _____ to the standby during a failure so database operations can resume quickly without administrative intervention.

A

RDS will AUTOMATICALLY FAILOVER to the standby during a failure so database operations can resume quickly without administrative intervention.

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

While the primary database is active, can you connect to the standby instance?

A

No. Multi-AZ is for discover recovery, not for improving performance, so you cannot connect to the standby when the primary database is active.

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

What is a Read Replica?

A

A read replica is a read-only copy of your primary RDS database.

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

What can you use to improve read performance in RDS?

A

Read Replicas

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

This service is great for read-heavy workloads and takes the load off your primary RDS database.

A

Read Replicas

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

True or False: You can use a multi-AZ setup in RDS to improve read performance of your database.

A

False. Multi-AZ setup in RDS is only for disaster recover. You would use read replicas to improve read performance.

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

Can a read replica be promoted to be their own database?

A

Yes.

17
Q

Can replication proceed between an RDS instance and a read replica when the read replica has been promoted?

A

No, when a read replica is promoted, replication is broken.

18
Q

When would you consider promoting a read replica?

A

If you wanted to do a massive analytic process against your database and didn’t want to impact the performance of the RDS instance.

19
Q

True or False: You can use read replicas for disaster recovery.

A

False. Read replicas are used primarily for scaling, NOT disaster recovery.

20
Q

True or False: You can deploy a read replica on an RDS instance that doesn’t have automated backups.

A

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

21
Q

What is an exact copy of your production database in Another Availability zone that cannot be read?

A

Multi-AZ

22
Q

What is a read-only copy of your primary database in the same AZ, cross-AZ or cross-region?

A

Read Replica

23
Q

This optional setup in RDS is used for disaster recovery.

A

Multi-AZ

24
Q

This optional setup in RDS is used for increasing or scaling read performance.

A

Read Replica

25
Q

In the event of a failure, this will cause RDS to automatically fail over to the standby instance.

A

Multi-AZ Setup

26
Q

This is great for read-heavy workloads and takes the load off your primary database for read-only workloads (e.g. Business Intelligence reporting jobs)

A

Read Replica

27
Q

What can you use to improve read performance in RDS?

A

Read Replicas

28
Q

True or False: You can use Read Replicas across multiple AZs.

A

FALSE
Remember that in the exam, they’ll try to confuse you with Availability Zones and Read Replicas. Multi-AZ is for disaster recovery only. Read replicas allow you to increase read performance of your RDS instance.

29
Q

A __________ is a read-only copy of your primary database in RDS.

A

Read Replica

30
Q

Does a Read Replica allow you to take load off your primary database?

A

YES

A Read Replica allow you to take load off your primary database. It’s great for ready-heavy workloads.

31
Q

What’s the difference between use cases for Multi-AZ and Read Replicas in RDS?

A

Multi-AZ is:

  • an exact copy of your production database in another Availability Zone.
  • used for disaster recovery.
  • in the event of a failure, RDS will automatically fail over to the standby instance.

Read Replica is:

  • a read-only copy of your primary database in the same AZ, cross-AZ or cross-region.
  • used to increase or scale read performance.
  • great for ready-heavy workloads and takes the load off your primary database for read-only workloads. (e.g. business intelligence reporting jobs).

SAA-C02 - AWS Architect Associate (10 decks)

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