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?

Answer options:

A.Amazon RDS
B.Amazon Aurora
C.Amazon Redshift
D.Amazon DynamoDB

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.html