Database Read Replica - Correct Answer- * A read-only copy of your primary
database in the same AZ, cross-AZ, or cross-region.
* Used to increase or
... [Show More] scale read performance.
* Great for read-heavy workloads and takes the load off your primary database for
read-only workloads (e.g. Business Intelligence reporting jobs).
Database Multi-AZ - Correct Answer- * 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.
What is Aurora? - Correct Answer- It's a MySQL- and PostgreSQL-compatible
relational database engine that combines the speed and availability of high-end
commercial databases with the simplicity and cost-effectiveness of open-source
databases.
Things to know about Aurora - Correct Answer- * Start with 10 GB. Scales in 10 GB
increments up to 128 TB (storage Auto Scaling).
* Compute resources can scale up to 95 vCPUs and 768 GB of memory.
* 2 copies of your data are contained in each AZ, with a minimum of 3 AZs. 6 copies
of your data.
Scaling Aurora - Correct Answer- * Aurora is designed to transparently handle the
loss of up to 2 copies of data without affecting database write availability and up to 3
copies without affecting read availability.
* Aurora storage is also self-healing! Data blocks and disks are continuously
scanned for errors and repaired automatically.
5 Aurora Exam Tips - Correct Answer- 1. 2 copies of your data are contained in each
AZ, with a minimum of 3 AZs. 6 copies of your data.
2. You can share Aurora snapshots with other AWS accounts.
3. 3 types of replicas available: Aurora replicas, MySQL replicas, and PostgreSQL
replicas. Automated failover is only available with Aurora replicas.
4. Aurora has automated backups turned on by default. You can also take snapshots
with Aurora. You can share these snapshots with other AWS accounts.
5. Use Aurora Serverless if you want a simple, cost-effective option for infrequent,
intermittent, or unpredictable workloads.
RDS Database Types - Correct Answer- SQL Server
Oracle
MySQL
PostgreSQL
MariaDB
Amazon Aurora
RDS is for what type of workloads? - Correct Answer- OLTP Workloads
Great for processing lots of small transactions like customer orders, banking
transactions, payments, and booking systems.
RDS is not suitable for what type of workload? - Correct Answer- OLAP Workloads
Use Redshift for data warehousing and OLAP tasks, like analyzing large amounts of
data, reporting, and sales forecasting.
Read Replicas — Key Facts - Correct Answer- 1. Scaling Read Performance —
Primarily used for scaling, not for disaster recovery!
2. Requires Automatic Backup — Automatic backups must be enabled in order to
deploy a read replica.
3. Multiple Read Replicas Are Supported — MySQL, MariaDB, PostgreSQL, Oracle,
and SQL Server allow you to add up to 5 read replicas to each DB instance.
RDS Multi-AZ - Correct Answer- • An exact copy of your production database in
another Availability Zone.
• Used for disaster recover only!
• In the event of a failure, RDS will automatically failover to the standby instance.
RDS Read Replica - Correct Answer- • A read-only copy of your primary database in
the same Availability Zone, cross-AZ, or cross-region.
• Used to increase or scale read performance.
• Grat for read-heavy workloads and takes the load off your primary database for
read-only workloads (e.g. Business Intelligence reporting jobs)
4 Aurora Exam Tips - Correct Answer- 1. 2 copies of your data are contained in each
AZ, with a minimum of 3 AZs. 6 copies of your data.
2. You can share Aurora snapshots with other AWS accounts.
3. 3 types of replicas available: (a) Aurora replicas, (b) MySQL replicas, and (c)
PostgreSQL replicas. Automated failover is only available with Aurora replicas.
4. Aurora has automated backups turned on by default. You can also take snapshots
with Aurora. You can share these snapshots with other AWS accounts.
Aurora Serverless Use Cases - Correct Answer- It provides a relatively simple, costeffective option for infrequent, intermittent, or unpredictable workloads.
4 Facts about DynamoDB - Correct Answer- 1. Stored on SSD storage
2. Spread across 3 geographically distinct data centers
3. Eventually consistent reads (default)
4. Strongly consistent reads
Eventually Consistent Reads - Correct Answer- • 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
Continues... [Show Less]