Exam AWS Certified Database - Specialty topic 1 question 32 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 32
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?

A. Select the option to apply the change immediately
B. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
C. Apply the change manually by rebooting the DB instance during the approved maintenance window
D. Reboot the secondary Multi-AZ DB instance

Show Suggested Answer

Suggested Answer: C 🗳️

by toppic26 at Nov. 16, 2021, 4:18 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

RotterDam

Highly Voted 3 years, 5 months ago

Selected Answer: C

C - static parameters require a manual reboot. You can either do it immediately or during the maintenance window

upvoted 7 times

...

hgelli

Most Recent 1 year, 10 months ago

Selected Answer: C

Static parameters require a reboot. So the best option is rebooting it during the approved maintenance window.

upvoted 1 times

...

IhorK

2 years ago

Selected Answer: C

Static and dynamic DB parameters could be for instance or cluster. Static parameters change takes effect ONLY after you manually reboot the associated DB clusters or DB instances according to documentation. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/parameter-groups-overview.html

upvoted 1 times

...

navkumin

2 years, 1 month ago

Selected Answer: C

C - static parameters require a manual reboot. For minimal impact, wait until the maintenance window.

upvoted 1 times

...

Mintwater

2 years, 4 months ago

C - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/parameter-groups-overview.html#parameter-groups-overview.db-instance When you change a static parameter and save the DB parameter group, the parameter change takes effect after you manually reboot the associated DB instances. For static parameters, the console always uses pending-reboot for the ApplyMethod

upvoted 1 times

...