Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 120 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 120
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A large company has a variety of Amazon DB clusters. Each of these clusters has various configurations that adhere to various requirements. Depending on the team and use case, these configurations can be organized into broader categories.
A database administrator wants to make the process of storing and modifying these parameters more systematic. The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.
Which AWS service or feature will help automate and achieve this objective?

A. AWS Systems Manager Parameter Store
B. DB parameter group
C. AWS Config
D. AWS Secrets Manager

Show Suggested Answer

Suggested Answer: B 🗳️

by novak18 at April 4, 2021, 7:05 a.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

Huy

Highly Voted 3 years, 8 months ago

In AWS, DB Configurations are stored in DB Parameter Group. So B

upvoted 16 times

...

novak18

Highly Voted 3 years, 9 months ago

The answer should be C?

upvoted 6 times

...

tcl08

Most Recent 1 year, 4 months ago

There's Aurora Global Database allows a single Amazon Aurora database to span multiple AWS regions, enabling high performance of globally distributed applications.

upvoted 1 times

...

SamDDD

1 year, 12 months ago

Should be C - AWS Config: https://aws.amazon.com/blogs/database/enforce-configuration-policies-for-your-amazon-rds-databases-using-aws-config/

upvoted 2 times

...

sk1974

2 years, 4 months ago

https://aws.amazon.com/blogs/database/enforce-configuration-policies-for-your-amazon-rds-databases-using-aws-config/ - I will go with C .Company has multiple DB instances.

upvoted 1 times

...

elf78

3 years ago

Selected Answer: B

DB Parameter Group

upvoted 2 times

...

sachin

3 years ago

My take is on A. Certain paramters are only applied to certain instances ,, so different Parameter Group for different dbs. On top DBA want to make sure certain configuration are applied commanly to all instance . This can only be done though parameter store which can be implemented using Cloud Formation template. Parameter Store, a capability of AWS Systems Manager, provides secure, hierarchical storage for configuration data management and secrets management. You can store data such as passwords, database strings, Amazon Machine Image (AMI) IDs, and license codes as parameter values. You can store values as plain text or encrypted data. You can reference Systems Manager parameters in your scripts, commands, SSM documents, and configuration and automation workflows by using the unique name that you specified when you created the parameter.

upvoted 1 times

db2luwdba

2 years, 11 months ago

Parameter hierarchies will ensure that configuration is properly categorized into wider groups and users. The following example uses three hierarchy levels in the name to identify the following: /Environment/Type of computer/Application/Data /Dev/DBServer/MySQL/db-string13

upvoted 1 times

db2luwdba

2 years, 11 months ago

So i believe Parameter store is correct.

upvoted 2 times

...

Dantas

3 years, 1 month ago

Selected Answer: B

B, https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithParamGroups.html

upvoted 2 times

Mintwater

2 years, 2 months ago

A DB parameter group is a collection of database engine parameter values that can be applied to one or more Amazon RDS, Amazon Aurora, or Amazon DocumentDB instances. By creating a DB parameter group, a database administrator can define and manage a set of database engine parameter values that apply to instances in a consistent manner. With a DB parameter group, a database administrator can modify parameter values for multiple instances at once and have the changes automatically applied to all instances associated with the parameter group. This allows for centralized management and ensures that changes are applied consistently across all instances. AWS Systems Manager Parameter Store, AWS Config, and AWS Secrets Manager are all AWS services that can be used to store and manage configuration parameters. However, these services are not specifically designed for managing database cluster configurations in a systematic manner and may not provide the same level of automation and consistency as a DB parameter group.

upvoted 2 times

...

novice_expert

3 years, 2 months ago

Selected Answer: B

Organizations create Standard Parameter Groups (for RDS) and Cluster/DB level Parameter Groups (for Aurora). These settings are applied uniformly across all instances implementing them.

upvoted 2 times

...

RotterDam

3 years, 3 months ago

Got this question in my exam. (i cleared it). B is correct

upvoted 2 times

...

RotterDam

3 years, 4 months ago

Selected Answer: B

Organizations create Standard Parameter Groups (for RDS) and Cluster/DB level Parameter Groups (for Aurora). These settings are applied uniformly across all instances implementing them. Also For people choosing System Manager Parameter Store - the SSM does not integrate with RDS. You can use Parameter Store parameters with other Systems Manager capabilities and AWS services to retrieve secrets and configuration data from a central store. Parameters work with Systems Manager capabilities such as Run Command, Automation, and State Manager, capabilities of AWS Systems Manager. You can also reference parameters in a number of other AWS services, including the following: Amazon Elastic Compute Cloud (Amazon EC2) Amazon Elastic Container Service (Amazon ECS) AWS Secrets Manager AWS Lambda AWS CloudFormation AWS CodeBuild AWS CodePipeline AWS CodeDeploy

upvoted 4 times

...

user0001

3 years, 4 months ago

I vote for C since the requirement is to auto implement and validation. B is good but it work at instance level and admin will need to manage them seperatly

upvoted 2 times

...

thelad

3 years, 5 months ago

Selected Answer: A

https://docs.aws.amazon.com/systems-manager/latest/userguide/systems-manager-parameter-store.html Who should use Parameter Store? - Any AWS customer who wants to have a centralized way to manage configuration data.

upvoted 2 times

...

jove

3 years, 6 months ago

"... changes to are automatically implemented to all instances as necessary".. Can you use AWS Systems Manager Parameter Store for that? I don't think so. So, the correct answer should be B (DB parameter group)

upvoted 2 times

RotterDam

3 years, 4 months ago

I agree- unless they are talking about CLOUDFORMATION and building Clusters and storing parameters centrally - this might make sense...I feel its PG.

upvoted 2 times

...

2025flakyt

3 years, 6 months ago

B is the correct answer Database parameters specify how the database is configured. For example, database parameters can specify the amount of resources, such as memory, to allocate to a database.

upvoted 1 times

...

GMartinelli

3 years, 6 months ago

Selected Answer: A

Option A

upvoted 1 times

...

Sp230

3 years, 7 months ago

A is the answer

upvoted 1 times

...

Load full discussion...