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

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 90 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 90
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A public-facing web application queries a database hosted on an Amazon EC2 instance in a private subnet. A large number of queries involve multiple table joins, and the application performance has been degrading due to an increase in complex queries. The application team will be performing updates to improve performance.
What should a solutions architect recommend to the application team? (Choose two.)

A. Cache query data in Amazon SQS
B. Create a read replica to offload queries
C. Migrate the database to Amazon Athena
D. Implement Amazon DynamoDB Accelerator to cache data.
E. Migrate the database to Amazon RDS

Show Suggested Answer

Suggested Answer: BE 🗳️

by Paitan at Aug. 10, 2020, 6:58 a.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

Submit Cancel

Paitan

Highly Voted 3 years, 9 months ago

RDS with read replica should do the the job. So B and E.

upvoted 54 times

aguy9

3 years, 8 months ago

I agree, answer is B and E

upvoted 4 times

...

UpsetUser

3 years, 8 months ago

yup. Questions must have asked combination of steps. Answer is E followed by B. (i)E->(ii) B

upvoted 4 times

...

Dewutopia

3 years, 8 months ago

How can it be B (create a read replica) when you don’t even know what type of DB current hosted in the private instance? Answer is C & E

upvoted 3 times

Dewutopia

3 years, 8 months ago

Sorry misread Athena for Aurora.

upvoted 2 times

...

simran_kaur_simmi

3 years, 7 months ago

its already mention that the tables aree joint thats only the case when you use the structured db with unique key incase of dynamo db you dont need structure of table and its not necessary that all the records have the same attributes .. so undoubtedly its for RDS

upvoted 1 times

...

UpsetUser

3 years, 8 months ago

Dude, thats y we are migrating to RDS.(option E). Once MIgrated , you can create Read Replicas(option B)

upvoted 5 times

...

Load full discussion...

...

syu31svc

Highly Voted 3 years, 7 months ago

A is obviously wrong since SQS doesn't cache data C is wrong as Athena is used to query data in S3 D is wrong as the question mentions table joins implying relational database; Dynamo is non-relational B and E are the answers

upvoted 20 times

elrmel

3 years, 7 months ago

i'm curious about why athena is wrong, but you explain that so i'm very thank

upvoted 1 times

allanm

2 years, 10 months ago

Athena is a query service only for S3. There is no mention of data into S3 for this question so Athena can be ruled out.

upvoted 2 times

...

Uzbekistan

Most Recent 1 year, 3 months ago

Selected Answer: BE

B and E 100%

upvoted 1 times

...

BECAUSE

2 years ago

Selected Answer: BE

B and E is the answer

upvoted 1 times

...

qax2022

2 years, 9 months ago

Selected Answer: BE

Since DynamoDB is a NoSQL database, it does not allow you to perform "join" queries on multiple tables. A join requires the DMBS to scan several tables and perform complex processing to aggregate the data to return a result set.

upvoted 2 times

...

TheBengiDog

2 years, 10 months ago

How do you guys acknowledge we need a relational database over DynamoDB?

upvoted 1 times

allanm

2 years, 10 months ago

The answer is in the question itself - "Numerous queries have numerous database joins" Any queries that involve joining data needs to be using a relational database.

upvoted 1 times

...

Arshadul

3 years ago

Key: -->2 tier architecture with web-server in public & ec2-instance + DB in private --> Slowness due to complicated queries Expectation: New solution to solve the slowness Distractors: A/C/D A is a distractor as SQS is queuing service and RDS cache service C is a distractor as Athena is entirely different service useful for analytics in S3 bucket D is a distractor as DynamoDB Accelerator (DAX) is a fully managed, highly available, in-memory cache for Amazon DynamoDB and it will work fine when we had DynamoDB implemented but NoSQL is not a good solution when you have several DB as the queries will get too complex B & E combined would solve the problem as read replica will take off the load of read data from the main DB and RDS can auto scale and is a fully managed service

upvoted 1 times

...

padre913

3 years, 7 months ago

always think complex queries use relational database(here RDS) and naturally to offload queries use read replica

upvoted 1 times

...

KK_uniq

3 years, 7 months ago

B, E for sure. Hint is table joins and no write mention

upvoted 3 times

...

eyebeem

3 years, 8 months ago

A will not work because this won't solve the issue in hand. C will not work since Athena analyzes data is S3. D doesn't work because we need a SQL DB. Hence, B and E looks good.

upvoted 2 times

...