A company wants to migrate a Microsoft SQL Server database server from an on-premises data center to AWS. The company needs access to the operating system of the SQL Server database.
Which solution will meet these requirements?
A.
Migrate the database to Amazon Aurora Serverless.
B.
Migrate the database to Amazon RDS for SQL Server.
C.
Migrate the database to Amazon EC2 instances that run SQL Server.
Amazon EC2 allows you to install and manage SQL Server directly on a Windows or Linux VM, giving you full access to the underlying operating system. This is required when you need to install custom agents, configure OS-level features, or have complete control over the environment.
Amazon RDS and Aurora are managed services and do not provide access to the underlying OS, nor does Redshift (which is a data warehouse, not SQL Server).
AWS Documentation Extract:
"If you require access to the underlying operating system or need to install custom software, use SQL Server on Amazon EC2. Amazon RDS is a managed service and does not provide OS-level access."
(Source: AWS Database Migration documentation, SQL Server Deployment Options)
[Reference: AWS Certified Solutions Architect – Official Study Guide, Database Migration Section., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit