Exam AWS Certified Database - Specialty topic 1 question 260 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 260
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by Sab at Dec. 1, 2022, 11:17 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Pranava_GCP

1 year, 9 months ago

Selected Answer: D

D. An Amazon RDS Custom for SQL Server and grant elevated privileges for both the database instance and the host operating system. "Amazon RDS Custom is a managed database service for legacy, custom, and packaged applications that require access to the underlying operating system and database environment. Amazon RDS Custom automates setup, operation, and scaling of databases in the cloud while granting customers access to the database and underlying operating system to configure settings, install patches, and enable native features to meet the dependent application's requirements." https://aws.amazon.com/rds/custom/faqs/

upvoted 3 times

...

Zdujgfr567783ff

1 year, 10 months ago

Selected Answer: D

D. Amazon RDS Custom

upvoted 2 times

...

aviathor

2 years ago

Selected Answer: A

Assuming that the CRM application must run on the same host as the database server to "manipulate files and packages", the DB server will have to run on an EC2 instance. So the only question is what level of privileges the application will need to have on that EC2 instance

upvoted 4 times

...

khun

2 years, 5 months ago

Selected Answer: D

D. Amazon RDS Custom

upvoted 2 times

...

examineme

2 years, 6 months ago

Selected Answer: D

Amazon RDS Custom is supported for the Oracle and Microsoft SQL Server database engines

upvoted 1 times

...

Sab

2 years, 6 months ago

Selected Answer: D

Amazon RDS Custom automates database administration tasks and operations. RDS Custom makes it possible for you as a database administrator to access and customize your database environment and operating system. With RDS Custom, you can customize to meet the requirements of legacy, custom, and packaged applications.

upvoted 2 times

...