A company has an ordering application that stores customer information in Amazon RDS for MySQL. During regular business hours, employees run one-time queries for reporting purposes. Timeouts are occurring during order processing because the reporting queries are taking a long time to run. The company needs to eliminate the timeouts without preventing employees from performing queries.What should a solutions architect do to meet these requirements?
Answer(s): A
The correct answer is A. Creating a read replica and directing reporting queries to it offloads long-running read operations from the primary DB instance, reducing timeouts for the ordering application while still allowing staff to run reports.B is incorrect because distributing the application to both primary and read replica is unnecessary and could complicate write consistency and routing. C is incorrect because DynamoDB migration is not addressing relational queries and introduces data model and application changes; it’s not required for this scenario. D is incorrect because scheduling during non-peak hours mitigates impact but fails to meet requirement of allowing reporting during regular business hours.
A hospital wants to create digital copies for its large collection of historical written records. The hospital will continue to add hundreds of new documents each day. The hospital’s data team will scan the documents and will upload the documents to the AWS Cloud.A solutions architect must implement a solution to analyze the documents, extract the medical information, and store the documents so that an application can run SQL queries on the data. The solution must maximize scalability and operational efficiency.Which combination of steps should the solutions architect take to meet these requirements? (Choose two.)
Answer(s): B,E
B) Using S3 for storage with Athena to query the data leverages scalable, serverless analytics directly on object storage, satisfying scalability and operational efficiency.E) Lambda triggered on upload uses Textract to extract text and Comprehend Medical to identify medical information, providing scalable, serverless OCR and NLP for medical data extraction.A) EC2 MySQL adds management overhead and is not scalable for continuous, high-volume ingestion.C) Auto Scaling EC2 for a custom app increases operational complexity and maintenance.D) Rekognition is not optimal for OCR/text extraction of documents; Transcribe Medical is suited for audio, not text documents.
A company is running a batch application on Amazon EC2 instances. The application consists of a backend with multiple Amazon RDS databases. The application is causing a high number of reads on the databases. A solutions architect must reduce the number of database reads while ensuring high availability.What should the solutions architect do to meet this requirement?
Answer(s): B
A) Use Amazon ElastiCache for RedisElastiCache Redis provides in-memory caching to reduce read traffic to RDS by serving frequently accessed data from the cache, improving latency and availability through a managed, clustered cache layer. B) ElastiCache for Redis is correct; it supports data structures, persistence options, and high availability with Redis replication and automatic failover. C) Route 53 DNS caching does not reduce database reads or provide a caching layer for database queries. D) ElastiCache Memcached offers caching but Redis generally provides richer data structures and persistence; however, Redis is the recommended option in this scenario for higher availability and features. A) and C) do not meet the requirement.
A company needs to run a critical application on AWS. The company needs to use Amazon EC2 for the application’s database. The database must be highly available and must fail over automatically if a disruptive event occurs.Which solution will meet these requirements?
A) Using two EC2s in different Availability Zones with a clustered database and replication provides high availability and automatic failover within a single region, satisfying HA and automatic recovery requirements.B) Single AZ with manual AMI backups and CloudFormation does not provide automatic failover or multi-AZ resilience for database availability.C) Cross-region deployment adds complexity and latency; automatic failover across regions is not native for typical EC2-hosted databases and is not standard HA.D) EC2 automatic recovery applies to the instance, not to application-level failover or database HA; single AZ limits resilience.
A company’s order system sends requests from clients to Amazon EC2 instances. The EC2 instances process the orders and then store the orders in a database on Amazon RDS. Users report that they must reprocess orders when the system fails. The company wants a resilient solution that can process orders automatically if a system outage occurs.What should a solutions architect do to meet these requirements?
Answer(s): C
Moving EC2s into an Auto Scaling group and decoupling processing with SQS enables durable, fault-tolerant reprocessing. Messages persist in SQS until processed, and EC2 instances can scale and continuously poll the queue, ensuring orders are not lost during outages. This supports automatic retries and at-least-once processing.A) EventBridge triggering ECS task is not addressing persistent retry or queueing; adds complexity without guaranteed ordering/reprocessing semantics.B) ALB with direct client routing does not provide durable queueing or automatic reprocessing if instances fail.D) SNS plus Lambda and Run Command introduces tight coupling and operational overhead; not a reliable, scalable reprocessing mechanism for batch order processing.
Post your Comments and Discuss Amazon AWS-SOLUTION-ARCHITECT-ASSOCIATE exam prep with other Community members: