ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 372 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 372
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A company wants to migrate an Oracle database to AWS. The database consists of a single table that contains millions of geographic information systems (GIS) 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?

  • A. Store the images and geographic codes in a database table. Use Oracle running on an Amazon RDS Multi-AZ DB instance.
  • 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.
  • C. Store the images and geographic codes in an Amazon DynamoDB table. Configure DynamoDB Accelerator (DAX) during times of high load.
  • D. Store the images in Amazon S3 buckets. Store geographic codes and image S3 URLs in a database table. Use Oracle running on an Amazon RDS Multi-AZ DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by [deleted] at March 10, 2023, 2:39 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Wayne23Fang
Highly Voted 1 year, 6 months ago
Selected Answer: B
Amazon prefers people to move from Oracle to its own services like DynamoDB and S3.
upvoted 15 times
...
Karlos99
Highly Voted 2 years ago
Selected Answer: D
The company wants a solution that is highly available and scalable
upvoted 9 times
EllenLiu
3 months, 1 week ago
another thing is the design of dynamoDB, "Use Amazon DynamoDB with the geographic code as the key and the image S3 URL as the value." geographic code can not be the only key for any image
upvoted 1 times
...
[Removed]
1 year, 12 months ago
But DynamoDB is also highly available and scalable https://aws.amazon.com/dynamodb/faqs/#:~:text=DynamoDB%20automatically%20scales%20throughput%20capacity,high%20availability%20and%20data%20durability.
upvoted 5 times
pbpally
1 year, 10 months ago
Yes but has a size limit at 400kb so theoretically it could store images but it's not a plausible solution.
upvoted 2 times
ruqui
1 year, 10 months ago
It doesn't matter the size limit of DynamoDB!!!! The images are saved in S3 buckets. Right answer is B
upvoted 8 times
jaydesai8
1 year, 8 months ago
but would it be easy and cost-effective to migrate Oracle (relational db) to (Dynamodb)NoSQL?
upvoted 5 times
pentium75
1 year, 3 months ago
Yes because it's a single table with two records, for which Oracle or any relation database has been a bad choice in the first place.
upvoted 5 times
...
...
...
...
...
...
upliftinghut
Most Recent 1 year, 2 months ago
Selected Answer: B
DynamoDB with its HA and built-in scalability. The nature of the table also resonates with NoSQL than SQL DB such as Oracle. Only 1 table so migration is just a script from Oracle to DynamoDB D is workable but more expensive with Oracle licenses and other setups for HA and scalability
upvoted 3 times
upliftinghut
1 year, 2 months ago
HA & built-in scalability of Amazon DynamoDB : https://aws.amazon.com/dynamodb/features/#:~:text=Amazon%20DynamoDB%20is%20a%20fully,for%20the%20most%20demanding%20applications.
upvoted 3 times
...
...
awsgeek75
1 year, 2 months ago
Selected Answer: B
A puts images in Oracle, not a good idea C DAX is not going to help with images D It is doable but RDS on multi AZ does not give you more performance or write scalability. It gives more availability and read scalability which is not required here. B works as Geographic code is the key in DynamoDB and S3 image URL is the data so DynamoDB can handle tens of thousands such record and S3 can scale for writing
upvoted 4 times
...
pentium75
1 year, 3 months ago
Selected Answer: B
They are currently using Oracle, but only for one simple table with a single key-value pair. This is a typical use case for a NoSQL database like DynamoDB (and whoever decided to use Oracle for this in the first place should be fired). Oracle is expensive as hell, so options A and D might work but are surely not cost-effective. C won't work because the images are too big for the database. Leaves B which would be the ideal solution and meet the availability and scalability requirements.
upvoted 6 times
...
wsdasdasdqwdaw
1 year, 5 months ago
For D - Oracle is not cheap as well. RDS with Oracle vs DynamoDB, I would go for pure AWS provided option. In each exam there is a lot of marketing => B
upvoted 3 times
...
jubolano
1 year, 5 months ago
Selected Answer: D
Cost effective, D
upvoted 2 times
awsgeek75
1 year, 2 months ago
How is Oracle more cost effective than other options?
upvoted 2 times
...
...
wsdasdasdqwdaw
1 year, 5 months ago
B or D, but the question is MOST cost-effectively DynamoDB is more expensive than RDS, I am going for D
upvoted 3 times
JA2018
4 months, 1 week ago
Key in sTEM states that the customer's current Oracle DB table is setup with a single key-value pair. A typical use case for a NoSQL database like DynamoDB.
upvoted 1 times
...
...
gouranga45
1 year, 6 months ago
Selected Answer: B
Answer is B, DynamoDB is Highly available and scalable
upvoted 2 times
...
baba365
1 year, 6 months ago
A single table in a relational db can have items that are related ? e.g. ‘select * from Faculty where department_id in (10, 20) and dept_name = AWS’. In the sql query example above, * means all and Faculty is name of the table.
upvoted 2 times
...
Eminenza22
1 year, 7 months ago
Selected Answer: B
B option offers a cost-effective solution for storing and accessing high-resolution GIS images during natural disasters. Storing the images in Amazon S3 buckets provides scalable and durable storage, while using Amazon DynamoDB allows for quick and efficient retrieval of images based on geographic codes. This solution leverages the strengths of both S3 and DynamoDB to meet the requirements of high availability, scalability, and cost-effectiveness.
upvoted 2 times
...
cd93
1 year, 7 months ago
Selected Answer: B
What were the company thinking using the most expensive DB on the planet FOR ONE SINGLE TABLE??? Migrate a single table from SQL to NoSQL should be easy enough I guess...
upvoted 3 times
...
vini15
1 year, 8 months ago
Should be D. the question says company wants to migrate oracle to AWS. Oracle is a relational db hence RDS makes more sense whereas Dynamodb is non relational db.
upvoted 3 times
pentium75
1 year, 3 months ago
But relational DB does not make sense for the use case. It's a single table.
upvoted 2 times
...
...
iBanan
1 year, 8 months ago
I hate these questions:) I can’t choose between B and D
upvoted 6 times
...
ces_9999
1 year, 8 months ago
Guys the answer is B the oracle database only has one table without any relationships so why we should use a relational database in the first place, second we are storing the images in S3 not in the database why not use this alongside dynamo
upvoted 6 times
Kp88
1 year, 8 months ago
You can't do migration of Oracle to Dynmodb without SCT. I am not the DB guy but since its saying oracle I would go with D otherwise B makes more sense if a company is starting out from scratch.
upvoted 2 times
Kp88
1 year, 8 months ago
Actually now that I think about it , B sounds ok as well. Company just need to use SCT and that would be more cost effective.
upvoted 2 times
...
...
...
joehong
1 year, 9 months ago
Selected Answer: D
"A company wants to migrate an Oracle database to AWS"
upvoted 2 times
pentium75
1 year, 3 months ago
Yeah, per my understanding that doesn't implicate that the destination must be an Oracle database.
upvoted 2 times
...
...
secdgs
1 year, 9 months ago
D: Wrorng if you caluate License Oracle Database, It is not cost-effectively. Multi-AZ is not scalable and if you set scalable, you need more license for Oracle database.
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago