exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 593 discussion

A company currently has data hosted in an IBM Db2 database. A web application calls an API that runs stored procedures on the database to retrieve user information data that is read-only. This data is historical in nature and changes on a daily basis. When a user logs in to the application, this data needs to be retrieved within 3 seconds. Each time a user logs in, the stored procedures run. Users log in several times a day to check stock prices.
Running this database has become cost-prohibitive due to Db2 CPU licensing. Performance goals are not being met. Timeouts from Db2 are common due to long-running queries.
Which approach should a solutions architect take to migrate this solution to AWS?

  • A. Rehost the Db2 database in Amazon Fargate. Migrate all the data. Enable caching in Fargate. Refactor the API to use the Fargate Db2 database. Implement Amazon API Gateway and enable API caching.
  • B. Use AWS DMS to migrate data to Amazon DynamoDB using a continuous replication task. Refactor the API to use the DynamoDB data. Implement the refactored API in Amazon API Gateway and enable API caching.
  • C. Create a local cache on the mainframe to store query outputs. Use SFTP to sync to Amazon S3 on a daily basis. Refactor the API to use Amazon EFS. Implement Amazon API Gateway and enable API caching.
  • D. Extract data daily and copy the data to AWS Snowball for storage on Amazon S3. Sync daily. Refactor the API to use the S3 data. Implement Amazon API Gateway and enable API caching.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
Nemer
Highly Voted 3 years, 8 months ago
B. DMS supports DB2 as source and DynamoDB as target. Along with API caching, retrieval should be under 3 seconds.
upvoted 16 times
...
Ebi
Highly Voted 3 years, 8 months ago
Answer is B All other answer do not make any sense
upvoted 6 times
...
evargasbrz
Most Recent 2 years, 5 months ago
Selected Answer: B
I'll go with B
upvoted 1 times
...
AwsBRFan
2 years, 8 months ago
Selected Answer: B
B makes sense
upvoted 1 times
...
gnic
2 years, 9 months ago
It's B.
upvoted 1 times
...
CloudHandsOn
2 years, 10 months ago
B. is the correct answer
upvoted 1 times
...
cldy
3 years, 6 months ago
B. Use AWS DMS to migrate data to Amazon DynamoDB using a continuous replication task. Refactor the API to use the DynamoDB data. Implement the refactored API in Amazon API Gateway and enable API caching.
upvoted 1 times
...
AzureDP900
3 years, 6 months ago
It is B, This question is part of Neal Davis practice test
upvoted 1 times
...
WhyIronMan
3 years, 7 months ago
I'll go with B
upvoted 2 times
...
blackgamer
3 years, 7 months ago
B is the answer.
upvoted 1 times
...
Waiweng
3 years, 7 months ago
it's B
upvoted 2 times
...
Bemi
3 years, 7 months ago
https://aws.amazon.com/about-aws/whats-new/2018/04/aws-dms-supports-ibm-db2-as-a-source/
upvoted 2 times
...
Kian1
3 years, 8 months ago
going with B
upvoted 2 times
...
Bulti
3 years, 8 months ago
B is the answer. DMS supports migration from DB2 to Dynamo DB.
upvoted 2 times
...
T14102020
3 years, 8 months ago
Correct is B. DMS supports DB2 as source and DynamoDB as target.
upvoted 1 times
...
jackdryan
3 years, 8 months ago
I'll go with B
upvoted 3 times
...
cloudgc
3 years, 8 months ago
B - https://aws.amazon.com/about-aws/whats-new/2018/04/aws-dms-supports-ibm-db2-as-a-source/#:~:text=AWS%20Database%20Migration%20Service%20Supports%20IBM%20Db2%20as%20a%20Source,-Posted%20On%3A%20Apr&text=AWS%20Database%20Migration%20Service%20(DMS,to%20any%20DMS%20supported%20target.
upvoted 1 times
...
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
Loading ...