Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Wayne23Fang
Highly Voted 1 year, 1 month ago
Selected Answer: B
Amazon prefers people to move from Oracle to its own services like DynamoDB and S3.
upvoted 13 times
...
Karlos99
Highly Voted 1 year, 7 months ago
Selected Answer: D
The company wants a solution that is highly available and scalable
upvoted 8 times
[Removed]
1 year, 6 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 4 times
pbpally
1 year, 5 months ago
Yes but has a size limit at 400kb so theoretically it could store images but it's not a plausible solution.
upvoted 1 times
ruqui
1 year, 4 months ago
It doesn't matter the size limit of DynamoDB!!!! The images are saved in S3 buckets. Right answer is B
upvoted 7 times
jaydesai8
1 year, 3 months ago
but would it be easy and cost-effective to migrate Oracle (relational db) to (Dynamodb)NoSQL?
upvoted 5 times
pentium75
9 months, 2 weeks 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 4 times
...
...
...
...
...
...
upliftinghut
Most Recent 8 months, 3 weeks 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 2 times
upliftinghut
8 months, 3 weeks 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 2 times
...
...
awsgeek75
9 months, 2 weeks 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 2 times
...
pentium75
9 months, 2 weeks 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 5 times
...
wsdasdasdqwdaw
11 months, 3 weeks 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 2 times
...
jubolano
11 months, 3 weeks ago
Selected Answer: D
Cost effective, D
upvoted 2 times
awsgeek75
9 months ago
How is Oracle more cost effective than other options?
upvoted 1 times
...
...
wsdasdasdqwdaw
12 months ago
B or D, but the question is MOST cost-effectively DynamoDB is more expensive than RDS, I am going for D
upvoted 2 times
...
gouranga45
1 year ago
Selected Answer: B
Answer is B, DynamoDB is Highly available and scalable
upvoted 1 times
...
baba365
1 year 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 1 times
...
Eminenza22
1 year, 1 month 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 1 times
...
cd93
1 year, 2 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 2 times
...
vini15
1 year, 2 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
9 months, 2 weeks ago
But relational DB does not make sense for the use case. It's a single table.
upvoted 1 times
...
...
iBanan
1 year, 2 months ago
I hate these questions:) I can’t choose between B and D
upvoted 6 times
...
ces_9999
1 year, 3 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 5 times
Kp88
1 year, 2 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 1 times
Kp88
1 year, 2 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 1 times
...
...
...
joehong
1 year, 4 months ago
Selected Answer: D
"A company wants to migrate an Oracle database to AWS"
upvoted 2 times
pentium75
9 months, 2 weeks ago
Yeah, per my understanding that doesn't implicate that the destination must be an Oracle database.
upvoted 1 times
...
...
secdgs
1 year, 4 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...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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