Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 128 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 128
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS
Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server
Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.
What is the MOST cost-effective and operationally efficient solution?

A. Run SQL Server Enterprise Edition on Amazon EC2.
B. Run SQL Server Standard Edition on Amazon RDS.
C. Run SQL Server Enterprise Edition on Amazon RDS.
D. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

Show Suggested Answer

Suggested Answer: B 🗳️

by shantest1 at April 2, 2021, 4:54 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

Submit Cancel

Jaypdv

Highly Voted 3 years, 7 months ago

B. SCT assessment says that you can use MSSQL standard edition. Since they want to stay on SQL Server, that's the cheapest option and migrating is operationally easy

upvoted 14 times

shantest1

3 years, 7 months ago

re-read that part, Standard Edition looks suffice. B. Answer.

upvoted 2 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: B

B. Run SQL Server Standard Edition on Amazon RDS.

upvoted 1 times

...

Bota5ky

1 year, 10 months ago

Selected Answer: C

They don't want to change version. And rds provides the license.

upvoted 1 times

...

Zdujgfr567783ff

1 year, 11 months ago

Selected Answer: B

Standard edition on RDS

upvoted 1 times

...

novice_expert

3 years ago

Selected Answer: B

B. Run SQL Server Standard Edition on Amazon RDS.

upvoted 1 times

...

jove

3 years, 5 months ago

Selected Answer: B

OPERATIONALLY EFFECTIVE = SQL Server on RDS MOST COST-EFFECTIVE = Standard Edition

upvoted 3 times

...

grekh001

3 years, 6 months ago

This link seems to indicate that more information is required to determine if the Enterprise instance is a candidate for downgrading to Standard. https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/determine-whether-your-microsoft-sql-server-database-can-be-downgraded-from-enterprise-to-standard-edition.html

upvoted 1 times

...

sbhujbal

3 years, 6 months ago

When Enterprise license is included in RDS price at FREE why to go to standard edition and loose all great features so Option C is correct.

upvoted 1 times

ExtHo

3 years, 6 months ago

Try to calculate price Enterprise will cost you almost double for same specification https://calculator.aws/#/createCalculator/RDSSQLServer

upvoted 4 times

...

Aesthet

3 years, 7 months ago

B final answer

upvoted 3 times

...

Zhongkai

3 years, 7 months ago

I will go with C as Standard Edition is not operationally efficient as Enterprise Edition. Check https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-ver15

upvoted 2 times

...

shantest1

3 years, 7 months ago

C. Run SQL Server Enterprise Edition on AWS RDS License is included with the RDS price Need Enterprise to Enterprise edition matching. On EC2 you will use your own license.

upvoted 3 times

Suresh108

3 years, 7 months ago

if standard edition is sufficient for the DB why to go for Enterprise edition and pay more?? i think B is right

upvoted 2 times

...