Q57 — AWS SAA-C03 Ch.4

Question 57 of 105 | ← Chapter 4

Q252. A company wants to migrate an Oracle database to AWS. The database consists of a single table that contains millions of geographic information systems (GlS) images that are high resolution and are identified by a geographic code.When a natural disaster occurs, tens of thousands of images get updated every few minutes. Each geographic code has a single image or row that is associated with it. The company wants a solution that is highly available and scalable during such events.Which solution meets these requirements MOST cost-effectively?

Correct Answer: B. Store the images in Amazon S3 buckets. Use Amazon DynamoDB with the geographic code as the key and the image S3 URL as the value

Explanation

To migrate an Oracle database to AWS for a single table containing millions of GIS images that are updated frequently during natural disasters, and to have a cost-effective, highly available, and scalable solution, a solutions architect should store the images in Amazon S3 buckets, use Amazon DynamoDB with the geographic code as the key and the image S3 URL as the value. Therefore, option B is the correct answer. Option A suggests storing the images and geographic codes in a database table and using Oracle running on an Amazon RDS Multi-AZ DB instance. While this approach can work, it may not be optimal for scalability or cost-effectiveness, especially during high load events. Option C suggests storing the images and geographic codes in an Amazon DynamoDB table and configuring DynamoDB Accelerator (DAX) during times of high load. While this approach can work, it may not be necessary for the low latency and high throughput requirements of the use case described in the question. Option D suggests storing the images in Amazon S3 buckets and storing geographic codes and image S3 URLs in a database table and using Oracle running on an Amazon RDS Multi-AZ DB instance. While this approach can work, it may introduce additional complexity and costs compared to Option B. By storing the images in Amazon S3 buckets and using Amazon DynamoDB with the geographic code as the key and the image S3 URL as the value, the company can easily store and access the data while minimizing operational overhead and costs. Amazon S3 provides a scalable and durable storage service for large volumes of unstructured data, such as GIS images. DynamoDB provides a low-latency NoSQL database that scales automatically and supports high write and read throughput. By using DynamoDB's partitioning capabilities and global secondary indexes, the solution can handle tens of thousands of updates per minute without impacting performance. This solution meets the requirements stated in the question while being cost-effective, highly available, and scalable.