A company is migrating its workloads to AWS. The company has sensitive and critical data in on-premises relational databases that run on SQL Server instances.
The company wants to use the AWS Cloud to increase security and reduce operational overhead for the databases.
Which solution will meet these requirements?
Migrating the databases to a Multi-AZ Amazon RDS for SQL Server DB instance while using an AWS Key Management Service (AWS KMS) AWS managed key for encryption will meet the company's requirements of increasing security and reducing operational overhead. Amazon RDS simplifies database management tasks such as backups, patching, and scaling, which reduces operational overhead. Additionally, the Multi-AZ deployment provides high availability and failover support. AWS KMS provides robust encryption and key management capabilities, enhancing the security of the data.
Migrate the databases to a Multi-AZ Amazon RDS for SQL Server DB instance. Use an AWS Key Management Service (AWS KMS) AWS managed key for encryption.
B. Migrate the databases to a Multi-AZ Amazon RDS for SQL Server DB instance. Use an AWS Key Management Service (AWS KMS) AWS managed key for encryption. This option provides the best balance between increased security, reduced operational overhead, and maintaining the relational database functionalities that the company needs.
B. Migrate the databases to a Multi-AZ Amazon RDS for SQL Server DB instance. Use an AWS Key Management Service (AWS KMS) AWS managed key for encryption.