DBS-C01 · Question #138
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…
The correct answer is B. Run SQL Server Standard Edition on Amazon RDS. 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…
Question
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?
Options
- ARun SQL Server Enterprise Edition on Amazon EC2.
- BRun SQL Server Standard Edition on Amazon RDS.
- CRun SQL Server Enterprise Edition on Amazon RDS.
- DRun Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.
How the community answered
(34 responses)- A6% (2)
- B71% (24)
- C18% (6)
- D6% (2)
Explanation
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 https://calculator.aws/#/createCalculator/RDSSQLServer
Topics
Community Discussion
No community discussion yet for this question.