AWS Certified Database – Specialty — Question 199

An ecommerce company is planning to launch a custom customer relationship management (CRM) application on AWS. The development team selected Microsoft SQL Server as the database engine for this deployment. The CRM application will require operating system access because the application will manipulate files and packages on the server hosting the database. A senior database engineer must help the application team select a suitable deployment model for SQL Server. The deployment model should be optimized for the workload requirements.

Which deployment option should the database engineer choose that involves the LEAST operational overhead?

Answer options

• A. Run SQL Server on Amazon EC2 and grant elevated privileges for both the database instance and the host operating system.
• B. Amazon RDS for SQL Server and grant elevated privileges for both the database instance and the host operating system.
• C. Run SQL Server on Amazon EC2 and grant elevated privileges for the database instance.
• D. An Amazon RDS Custom for SQL Server and grant elevated privileges for both the database instance and the host operating system.

Correct answer: D

Explanation

The correct answer is D because Amazon RDS Custom for SQL Server allows for customization while still managing the operational overhead, making it suitable for workloads needing OS access. Option A and C involve more operational management since they require running SQL Server on EC2, which increases complexity. Option B is incorrect as Amazon RDS for SQL Server does not allow elevated privileges for the host operating system.