A Developer is migrating an on-premises application to the AWS Cloud.
The application currently uses Microsoft SQL, encrypting some of the data using Transparent Data Encryption.
Which service should the Developer use to minimize code changes?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer - A.
This is also mentioned in the AWS Documentation.
Amazon RDS supports using Transparent Data Encryption (TDE) to encrypt stored data on your DB instances running Microsoft SQL Server.
TDE automatically encrypts data before it is written to storage and automatically decrypts data when the data is read from storage.
Amazon RDS supports TDE for the following SQL Server versions and editions:
SQL Server 2017 Enterprise Edition.
SQL Server 2016 Enterprise Edition.
SQL Server 2014 Enterprise Edition.
SQL Server 2012 Enterprise Edition.
SQL Server 2008 R2 Enterprise Edition.
To enable transparent data encryption for a DB instance running SQL Server, specify the TDE option in an Amazon RDS option group associated with that DB instance.
Option B is incorrect because Microsoft SQL is not compatible with Aurora.
Option C is incorrect because RedShift is used as a Data warehouse.
Microsoft SQL does not support it.
Option D is incorrect because DynamoDB is a no-SQL database, primarily used with serverless architectures.
For more information on Encryption on Microsoft SQL Server AWS, please refer to the below Link-
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.TDE.htmlThe service that should be used to minimize code changes while migrating an on-premises application that currently uses Microsoft SQL with transparent data encryption to the AWS Cloud is Amazon RDS (Relational Database Service).
Amazon RDS is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It is designed to simplify the process of deploying, managing, and scaling a relational database in the cloud. Amazon RDS supports several database engines, including Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and Amazon Aurora.
When migrating an on-premises application to the AWS Cloud, minimizing code changes is important to ensure that the migration process is as seamless as possible. Amazon RDS allows the developer to use the same database engine and encryption technology that is currently being used on-premises, which helps to minimize code changes.
Additionally, Amazon RDS supports transparent data encryption for Microsoft SQL Server, which means that the data remains encrypted both at rest and in transit without requiring any code changes. This helps to ensure that data remains secure during the migration process.
Amazon Aurora, Amazon Redshift, and Amazon DynamoDB are all powerful AWS database services, but they are not designed to support transparent data encryption for Microsoft SQL Server. Therefore, they would require code changes to support the migration of an on-premises application that currently uses Microsoft SQL with transparent data encryption.