DBS-C01 (Page 13)

An online bookstore uses Amazon Aurora MySQL as its backend database.After the online bookstore added a popular book to the online catalog, customers began reporting intermittent timeouts on the checkout page.A database specialist determined that increased load was causing locking contention on the database.The database specialist wants to automatically detect and diagnose database performance issues and to resolve bottlenecks faster.Which solution will meet these requirements?Read More →

A company is running critical applications on AWS.Most of the application deployments use Amazon Aurora MySQL for the database stack.The company uses AWS CloudFormation to deploy the DB instances.The company’s application team recently implemented a CI/CD pipeline.A database engineer needs to integrate the database deployment CloudFormation stack with the newly built CI/CD platform.Updates to the CloudFormation stack must not update existing production database resources.Which CloudFormation stack policy action should the database engineer implement to meet these requirements?Read More →

A company runs online transaction processing (OLTP) workloads on an Amazon RDS for PostgreSQL Multi-AZ DB instance.The company recently conducted tests on the database after business hours, and the tests generated additional database logs.As a result, free storage of the DB instance is low and is expected to be exhausted in 2 days.The company wants to recover the free storage that the additional logs consumed.The solution must not result in downtime for the database.Which solution will meet these requirements?Read More →

A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis.The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas.The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle.Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?Read More →

A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database.The database runs onAmazon RDS for MySQL and is hosted in the us-west-2 Region.The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us- east-2 Regions.This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics.There are complaints that the dashboard performs more slowly in the Singapore location than it does in Portland or New York.A solution is needed to provide consistent performance for all users in each location.Which set of actions will meet these requirements?Read More →

A company has a quarterly customer survey.The survey uses an Amazon EC2 instance that is hosted in a public subnet to host a customer survey website.The company uses an Amazon RDS DB instance that is hosted in a private subnet in the same VPC to store the survey results.The company takes a snapshot of the DB instance after a survey is complete, deletes the DB instance, and then restores the DB instance from the snapshot when the survey needs to be conducted again.A database specialist discovers that the customer survey website times out when it attempts to establish a connection to the restored DB instance.What is the root cause of this problem?Read More →

A retail company is about to migrate its online and mobile store to AWS.The company’s CEO has strategic plans to grow the brand globally.A DatabaseSpecialist has been challenged to provide predictable read and write database performance with minimal operational overhead.What should the Database Specialist do to meet these requirements?Read More →

A global company is developing an application across multiple AWS Regions.The company needs a database solution with low latency in each Region and automatic disaster recovery.The database must be deployed in an active-active configuration with automatic data synchronization between Regions.Which solution will meet these requirements with the LOWEST latency?Read More →

A company wants to improve its ecommerce website on AWS.A database specialist decides to add Amazon ElastiCache for Redis in the implementation stack to ease the workload off the database and shorten the website response times.The database specialist must also ensure the ecommerce website is highly available within the company’s AWS Region.How should the database specialist deploy ElastiCache to meet this requirement?Read More →

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.)Read More →