Question 1

A company is running production workloads that use a Multi-AZ deployment of an Amazon RDS for MySQL db.m6g.xlarge (general purpose) standard DB instance. Users report that they are frequently encountering a “too many connections” error. A SysOps administrator observes that the number of connections on the database is high.

The SysOps administrator needs to resolve this issue while keeping code changes to a minimum.

Which solution will meet these requirements MOST cost-effectively?

Options :

A : Modify the RDS for MySQL DB instance to a larger instance size.

B : Modify the RDS for MySQL DB instance to Amazon DynamoDB.

C : Configure RDS Proxy. Modify the application configuration file to use the RDS Proxy endpoint.

D : Modify the RDS for MySQL DB instance to a memory optimized DB instance.

Answer: C

Question 2

An Amazon CloudFront distribution has a single Amazon S3 bucket as its origin. A SysOps administrator must ensure that users can access the S3 bucket only through requests from the CloudFront endpoint.

Which solution will meet these requirements?

Options :

A : Configure S3 Block Public Access on the S3 bucket. Update the S3 bucket policy to allow the GetObject action from only the CloudFront distribution.

B : Configure Origin Shield in the CloudFront distribution. Update the CloudFront origin to include a custom Origin_Shield header.

C : Create an origin access identity (OAI). Assign the OAI to the CloudFront distribution. Update the S3 bucket policy to restrict access to the OAI.

D : Create an origin access identity (OAI). Assign the OAI to the S3 bucket. Update the CloudFront origin to include a custom Origin header with the OAI value.

Answer: C

Question 3

A company uses AWS Cloud Formation templates to deploy cloud infrastructure. An analysis of all the company's templates shows that the company has declared the same components in multiple templates. A SysOps administrator needs to create dedicated templates that have their own parameters and conditions for these common components.
Which solution will meet this requirement?

Options :

A : Develop a CloudFormaiion change set.

B : Develop CloudFormation macros.

C : Develop CloudFormation nested stacks.

D : Develop CloudFormation stack sets.

Answer: C

Question 4

A company is running distributed computing software to manage a fleet of 20 Amazon EC2 instances for calculations. The fleet includes 2 control nodes and 18 task nodes to run the calculations. Control nodes can automatically start the task nodes.

Currently, all the nodes run on demand. The control nodes must be available 24 hours a day, 7 days a week. The task nodes run for 4 hours each day. A SysOps administrator needs to optimize the cost of this solution.

Which combination of actions will meet these requirements? (Choose two.)

Options :

A : Purchase EC2 Instance Savings Plans for the control nodes.

B : Use Dedicated Hosts for the control nodes.

C : Use Reserved Instances for the task nodes.

D : Use Spot Instances for the control nodes. Use On-Demand Instances if there is no Spot availability.

E : Use Spot Instances for the task nodes. Use On-Demand Instances if there is no Spot availability.

Answer: A,E

Question 5

A SysOps administrator is designing a solution for an Amazon RDS for PostgreSQL DB instance. Database credentials must be stored and rotated monthly. The applications that connect to the DB instance send write-intensive traffic with variable client connections that sometimes increase significantly in a short period of time.

Which solution should a SysOps administrator choose to meet these requirements?

Options :

A : Configure AWS Key Management Service (AWS KMS) to automatically rotate the keys for the DB instance. Use RDS Proxy to handle the increases in database connections.

B : Configure AWS Key Management Service (AWS KMS) to automatically rotate the keys for the DB instance. Use RDS read replicas to handle the increases in database connections.

C : Configure AWS Secrets Manager to automatically rotate the credentials for the DB instance. Use RDS Proxy to handle the increases in database connections.

D : Configure AWS Secrets Manager to automatically rotate the credentials for the DB instance. Use RDS read replicas to handle the increases in database connections

Answer: C

Smartly Prepare Exam with Free Online SOA-C02 Practice Test

Buying Options: