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

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 335 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 335
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries and stored procedures.

The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort.

Which solution will meet these requirements?

  • A. Migrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.
  • B. Migrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.
  • C. Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.
  • D. Migrate the database to an Amazon EMR cluster that includes multiple primary nodes.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by narvaez at Nov. 24, 2023, 11:19 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

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
Doox
1 year, 1 month ago
A. https://aws.amazon.com/rds/aurora/babelfish/
upvoted 1 times
...
MultiAZ
1 year, 4 months ago
Selected Answer: C
C Gives minimal rewrite of the complex T-SQL code
upvoted 3 times
...
KikiNoviandi
1 year, 5 months ago
Selected Answer: C
C is Correct, The company also wants to minimize the need to rewrite code as part of the migration effort
upvoted 3 times
...
KikiNoviandi
1 year, 5 months ago
C is Correct, The company also wants to minimize the need to rewrite code as part of the migration effort
upvoted 2 times
...
dbkorn
1 year, 5 months ago
I think C *** Migrate SQL Server to AWS and minimize database maintenance operating costs = RDS SQL Server T-SQL queries and stored procedures = Support RDS SQL Server Minimize the need to rewrite code as part of the migration effort = RDS SQL Server
upvoted 3 times
...
marll88
1 year, 5 months ago
I think C. Amazon RDS for SQL Server with T-SQL compatibility is better.
upvoted 3 times
...
narvaez
1 year, 5 months ago
i think C!
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago