Free DBS-C01 Exam Braindumps (page: 37)

Page 36 of 82

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development. The DB instance is experiencing slow performance when queries are executed. Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.

Which actions can a database specialist perform to resolve this issue? (Choose two.)

  1. Restart the application tool used to execute queries.
  2. Change to a database instance class with higher throughput.
  3. Convert from Single-AZ to Multi-AZ.
  4. Increase the I/O parameter in Amazon RDS Enhanced Monitoring.
  5. Convert from General Purpose to Provisioned IOPS (PIOPS).

Answer(s): B,E



A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.

What is the MOST operationally efficient solution to meet these requirements?

  1. Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.
  2. Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.
  3. Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.
  4. Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the masterdatabase user password.

Answer(s): B



A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify:

-The networks and routes affected if a particular component fails.
-The networks that have redundant routes between them.
-The networks that do not have redundant routes between them.
-The fastest path between two networks.

Which database engine meets these requirements?

  1. Amazon Aurora MySQL
  2. Amazon Neptune
  3. Amazon ElastiCache for Redis
  4. Amazon DynamoDB

Answer(s): B



An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost-effective solution that will automatically scale and is highly available.

Which solution meets these requirements?

  1. Amazon DynamoDB with on-demand capacity mode
  2. Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
  3. Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and 10,000 read capacity units (RCUs)
  4. Amazon Aurora with one writer node and two cross-Region Aurora Replicas

Answer(s): A






Post your Comments and Discuss Amazon DBS-C01 exam with other Community members:

Exam Discussions & Posts