Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 80 discussion

C and E are the correct answers. Option C: Leveraging Amazon Kinesis Data Streams and AWS Lambda to ingest and process the raw data would help to resolve the issues with the API servers being consistently overloaded. By using Kinesis, the data can be ingested and processed in real-time, allowing the API servers to handle the increased load. Using Lambda to process the data can also help to improve the overall performance and scalability of the platform. Option E: Re-architecting the database tier to use Amazon DynamoDB instead of an RDS MySQL DB instance would help to resolve the issues with high write latency. DynamoDB is a NoSQL database that is designed for high performance and scalability, making it a good fit for this use case. Additionally, DynamoDB supports auto-scaling, which can help to ensure that the database can handle the expected growth in the number of sensors.

By combining options B and C, the company can address the current performance and scalability issues while enabling future growth as more sensors are deployed. Amazon Aurora provides a scalable and high-performance relational database, while Kinesis Data Streams and Lambda offer a serverless and cost-effective solution for ingesting and processing the raw data streams. Option A may provide temporary relief by increasing IOPS, but it doesn't address the scalability and performance limitations of RDS MySQL. Option D can help identify application issues but doesn't solve the underlying database problems. Option E is not ideal as DynamoDB is a NoSQL database, and the existing application is likely designed for a relational database like MySQL or Aurora, requiring significant changes to the application code and data modeling.

C. Leverage Amazon Kinesis Data Streams and AWS Lambda to ingest and process the raw data. E. Re-architect the database tier to use Amazon DynamoDB instead of an RDS MySQL DB instance.

What discards B is "Add read replicas", the problem is writing the new data in the DB, adding Read replicas will increase the cost and this is not what question requests "maintain cost"

Write performance will be improved by switch RDS to Aurora. RDS to Aurora is smooth transition without too much on the application side. Answer E will application side not just backend DB.

Option CE and BC. The only reason I choose E over B because said SO. Per AWS, DynamoDB is suitable for IoT ( Sensor data and log ingestion) https://docs.aws.amazon.com/whitepapers/latest/best-practices-for-migrating-from-rdbms-to-dynamodb/suitable-workloads.html

CE, kinesis + lambda & Dynamodb

Switching from RDS mysql to aurora will improve performance, by up to 10 times, which could solve the write issue. Switching from relationship database to nosql is not practical, need re-engineering whole application. plus, the performance improvement of nosql are around data read, not data write ( creating/updating indexes is a huge effort)

* B. Re-architect the database tier to use Amazon Aurora instead of an RDS MySQL DB instance and add read replicas. Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Aurora provides several benefits over standard RDS MySQL, including better performance, scalability, and availability. It automatically grows storage as needed, up to 128 TB, potentially providing better write performance. Aurora also supports up to 15 read replicas with very low replication latency, improving read performance significantly and reducing the load on the primary database instance.

A = does not fix permanently (who knows that 6TB is enough?) B = going from RDS to Aurora will not fix the issue C = correct D = this could work, but it is not cost efficient (more EC2 instance along the line) E = correct

The requirement is to resolve high write latency while Aurora is a good fit for structured datasets but option B has indicated read replica as a direction for resolution against a question seeking resolution in write latency. So Option B is definitely out.

Amazon RDS FeaturesAmazon RDS supports multiple database engines, including Amazon Aurora, MySQL, MariaDB, Oracle, Microsoft SQL Server, and PostgreSQL.Amazon RDS allows you to scale your database instances’ storage size and performance.Amazon RDS makes it easy to set up, operate, and scale a relational database in the cloud.Amazon RDS provides a cost-effective way to manage relational databases in the cloud.DynamoDB FeaturesPrimarily, DynamoDB features flexibility, scalability, and performance. It offers high availability out of the box with no need for setup or configuration. DynamoDB automatically replicates your data across multiple Availability Zones within a Region to give you fault tolerance and high availability.

c and E ans 100 %

CE https://aws.amazon.com/dynamodb/iot/

b-c-b-c-b-c-b-c

CE for sure. classic IoT use case

Rds MySQL to Aurora to scale automatically and stay relational