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.

B. Re-architect the database tier to use Amazon Aurora and add read replicas Aurora automatically scales storage up to 128 TB without manual resizing. Faster writes and lower read latency than standard RDS MySQL. C. Use Amazon Kinesis Data Streams and AWS Lambda for ingestion and processing Decouples IoT data ingestion from database writes Kinesis Data Streams ingests large volumes of sensor data without overloading API servers. Scales automatically with the number of sensors. Not E becvause DynamoDB is NOSql and doesn't support MySQL.

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 managed database service compatible with MySQL, designed for high performance and scalability. Aurora provides better write performance and supports read replicas to handle increased read traffic as the platform grows. This will address the high write latency issue and enable horizontal scaling. C. Leverage Amazon Kinesis Data Streams and AWS Lambda to ingest and process the raw data. Using Amazon Kinesis Data Streams for data ingestion offloads traffic from the API servers, reducing their load and improving scalability. AWS Lambda can process the raw data in real time and pass it to the database or other systems, providing a cost-effective and scalable solution for data processing.

By combining C (Kinesis + Lambda) with E (DynamoDB), you're preparing the platform to handle exponential growth in sensor data while ensuring high availability, scalability, and low latency for both data processing and storage. This solution directly addresses the need for a robust, future-proof architecture capable of supporting massive data volumes without bottlenecks, making it well-suited for the IoT platform's growth.

E would require a shift from relational to a no-sql table - what if there are multiple tables?

C is straightforward. I go for E rather than B, because db shows heavy write latency, not limit. Replacing with Aurora will speed up thing up until a limit. Goal is to deal with it once and for all

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.