DBS-C01 (Page 6)

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 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 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 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 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 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 →

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 has an Amazon Redshift cluster with database audit logging enabled.A security audit shows that raw SQL statements that run against the Redshift cluster are being logged to an Amazon S3 bucket.The security team requires that authentication logs are generated for use in an intrusion detection system (IDS), but the security team does not require SQL queries.What should a database specialist do to remediate this issue?Read More →

A database specialist wants to ensure that an Amazon Aurora DB cluster is always automatically upgraded to the most recent minor version available.Noticing that there is a new minor version available, the database specialist has issues an AWS CLI command to enable automatic minor version updates.The command runs successfully, but checking the Aurora DB cluster indicates that no update to the Aurora version has been made.What might account for this? (Choose two.)Read More →

A database specialist is designing a disaster recovery (DR) strategy for a highly available application that is in development.The application uses an Amazon DynamoDB table as its data store.The application requires an RTO of 1 minute and an RPO of 2 minutes.Which DR strategy for the DynamoDB table will meet these requirements with the MOST operational efficiency?Read More →