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

By:
In: DBS-C01
Tagged:
With: 1 Comment
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?

Run SQL Server on Amazon EC2 and grant elevated privileges for both the database instance and the host operating system.

Amazon RDS for SQL Server and grant elevated privileges for both the database instance and the host operating system.

Run SQL Server on Amazon EC2 and grant elevated privileges for the database instance.

An Amazon RDS Custom for SQL Server and grant elevated privileges for both the database instance and the host operating system.

Explanations:

Running SQL Server on Amazon EC2 requires managing the operating system and database instance, which increases operational overhead. Elevated privileges for both the database and OS are not necessary for most workloads, making this choice more complex.

Amazon RDS for SQL Server does not allow granting elevated privileges on the host operating system, making it unsuitable for workloads requiring OS-level access.

Running SQL Server on Amazon EC2 with elevated privileges for the database instance only does not meet the requirement for OS-level access, which is essential for the application.

Amazon RDS Custom for SQL Server allows for more control over the database instance and operating system, making it the best choice for workloads requiring elevated privileges and OS access, while still managing operational complexity.

2025-10-09

1 Comment

  1. Betty
    Author

    I deduce that the answer is:
    An Amazon RDS Custom for SQL Server and grant elevated privileges for both the database instance and the host operating system.

Leave a Reply

Your email address will not be published. Required fields are marked *

17 − one =