Databases - AWS Certified Solutions Architect - Associate (SAA-C02) Questions And Answers 2022

Databases - AWS Certified Solutions Architect - Associate (SAA-C02) Questions And Answers 2022 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 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....