Database Specialty (Page 27)

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 →

A software company is conducting a security audit of its three-node Amazon Aurora MySQL DB cluster.Which finding is a security concern that needs to be addressed?Read More →

A banking company recently launched an Amazon RDS for MySQL DB instance as part of a proof-of-concept project.A database specialist has configured automated database snapshots.As a part of routine testing, the database specialist noticed one day that the automated database snapshot was not created.Which of the following are possible reasons why the snapshot was not created? (Choose two.)Read More →