SAA-C03 · Question #396
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…
The correct answer is 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 Amazon…
Question
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?
Options
- AMigrate the database to Amazon Aurora Serverless.
- BMigrate the database to Amazon RDS for SQL Server.
- CMigrate the database to Amazon EC2 instances that run SQL Server.
- DMigrate the database to Amazon Redshift.
How the community answered
(54 responses)- A4% (2)
- B2% (1)
- C93% (50)
- D2% (1)
Explanation
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 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).
Community Discussion
No community discussion yet for this question.