Download Latest DBS-C01 Questions

AWS Certified Database - Specialty Questions and Answers

Question 29

A company has a web application that uses Amazon API Gateway to route HTTPS requests to AWS Lambda functions. The application uses an Amazon Aurora MySQL database for its data storage. The application has experienced unpredictable surges in traffic that overwhelm the database with too many connection requests. The company needs to implement a scalable solution that is more resilient to database failures as quickly as possible.

Which solution will meet these requirements MOST cost-effectively?

Options:

Migrate the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot. Change the endpoint in the Lambda functions to use the new database.

Migrate the Aurora MySQL database to Amazon DynamoDB tables by using AWS Database Migration Service (AWS DMS). Change the endpoint in the Lambda functions to use the new database.

Create an Amazon EventBridge rule that invokes a Lambda function. Code the function to iterate over all existing connections and to call MySQL queries to end any connections in the sleep state.

Increase the instance class for the Aurora database with more memory. Set a larger value for the max_connections parameter.

Answer:

Explanation:

Correct Answer: A

Explanation from Amazon documents:

Amazon Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora MySQL that automatically starts up, shuts down, and scales capacity up or down based on your application’s needs. Aurora Serverless is ideal for applications with unpredictable or intermittent traffic patterns that experience sudden spikes or drops in demand. Aurora Serverless also provides high availability and durability by replicating your data across multiple Availability Zones and continuously backing up your data to Amazon S3.

Migrating the Aurora MySQL database to Amazon Aurora Serverless by restoring a snapshot will meet the requirements of implementing a scalable solution that is more resilient to database failures as quickly as possible. This solution will allow the company to benefit from the auto-scaling and high availability features of Aurora Serverless, which will handle the unpredictable surges in traffic and prevent connection issues. This solution will also be cost-effective, as the company will only pay for the database capacity that they use. The migration process will be simple and fast, as the company can use the AWS Management Console, the AWS CLI, or the RDS API to restore a snapshot of their existing Aurora MySQL database to an Aurora Serverless DB cluster, and then change the endpoint in the Lambda functions to use the new database.

Therefore, option A is the correct solution to meet the requirements. Option B is not cost-effective because migrating the Aurora MySQL database to Amazon DynamoDB tables by using AWS DMS will incur additional time and cost, and may require significant code changes to adapt to a different data model and query language. Option C is not scalable because creating an EventBridge rule that invokes a Lambda function to end any connections in the sleep state will not address the root cause of the connection issues, which is the lack of database capacity to handle the traffic spikes. Option D is not scalable because increasing the instance class for the Aurora database with more memory and setting a larger value for the max_connections parameter will not provide auto-scaling or high availability, and may still result in connection issues if the traffic exceeds the provisioned capacity.

Question 30

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.

What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

Options:

Increase the size of the DB instance storage

Change the underlying EBS storage type to General Purpose SSD (gp2)

Disable EBS optimization on the DB instance

Change the DB instance to an instance class with a higher maximum bandwidth

Question 31

A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database.

Which solution meets these requirements?

Options:

Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.

Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.

Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.

Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.

Question 32

A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB instance in the future.

Which combination of actions should the database specialist take to meet this requirement? (Choose three.)

Options:

Set the DeletionProtection property to True.

Set the MultiAZ property to True.

Set the TerminationProtection property to True.

Set the DeleteAutomatedBackups property to False.

Set the DeletionPolicy attribute to No.

Set the DeletionPolicy attribute to Retain.

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

AWS Certified Database - Specialty Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer: