Database Specialty (Page 12)

An online bookstore recently migrated its database from on-premises Oracle to Amazon Aurora PostgreSQL 13.The bookstore uses scheduled jobs to run customized SQL scripts to administer the Oracle database, running hours-long maintenance tasks, such as partition maintenance and statistics gathering.The bookstore’s application team has reached out to a database specialist seeking an ideal replacement for scheduling jobs with Aurora PostgreSQL.What should the database specialist implement to meet these requirements with MINIMAL operational overhead?Read More →

A company is planning to close for several days.A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time.All databases are running on Amazon RDS for MySQL.The Database Specialist wrote and ran a script to stop all the DB instances.When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.How should the Database Specialist edit the script to fix this issue?Read More →

The Security team for a finance company was notified of an internal security breach that happened 3 weeks ago.A Database Specialist must start producing audit logs out of the production Amazon Aurora PostgreSQL cluster for the Security team to use for monitoring and alerting.The Security team is required to perform real-time alerting and monitoring outside the Aurora DB cluster and wants to have the cluster push encrypted files to the chosen solution.Which approach will meet these requirements?Read More →

A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months.The connection failure lasted for 5 minutes and corrected itself after that.The Database Specialist reviewed the AmazonRDS events and determined a failover event occurred at that time.The failover process took around 15 seconds to complete.What is the MOST likely cause of the 5-minute connection outage?Read More →

A manufacturing company stores its inventory details in an Amazon DynamoDB table in the us-east-2 Region.According to new compliance and regulatory policies, the company is required to back up all of its tables nightly and store these backups in the us-west-2 Region for disaster recovery for 1 year.Read More →

A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer.The EC2 instances use the security group named sg-application-servers.The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance.The DB instance is deployed in a private DB subnet.What is the MOST restrictive configuration for the DB instance security group?Read More →

A company is writing a new survey application to be used with a weekly televised game show.The application will be available for 2 hours each week.The company expects to receive over 500,000 entries every week, with each survey asking 2-3 multiple choice questions of each user.A Database Specialist needs to select a platform that is highly scalable for a large number of concurrent writes to handle the anticipated volume.Which AWS services should the Database Specialist consider? (Choose two.)Read More →

A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster.Initial tests with less than 10 users on the new platform yielded successful execution and fast response times.However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.Which of the following will resolve this issue?Read More →

A company has a web-based survey application that uses Amazon DynamoDB.During peak usage, when survey responses are being collected, a DatabaseSpecialist sees the ProvisionedThroughputExceededException error.What can the Database Specialist do to resolve this error? (Choose two.)Read More →

A company is going to use an Amazon Aurora PostgreSQL DB cluster for an application backend.The DB cluster contains some tables with sensitive data.ADatabase Specialist needs to control the access privileges at the table level.How can the Database Specialist meet these requirements?Read More →