Database Specialty (Page 6)

A company plans to migrate a MySQL-based application from an on-premises environment to AWS.The application performs database joins across several tables and uses indexes for faster query response times.The company needs the database to be highly available with automatic failover.Which solution on AWS will meet these requirements with the LEAST operational overhead?Read More →

An information management services company is storing JSON documents on premises.The company is using a MongoDB 3.6 database but wants to migrate toAWS.The solution must be compatible, scalable, and fully managed.The solution also must result in as little downtime as possible during the migration.Which solution meets these requirements?Read More →

A company is using Amazon DocumentDB (with MongoDB compatibility) to manage its complex documents.Users report that an Amazon DocumentDB cluster takes a long time to return query results.A database specialist must investigate and resolve this issue.Which of the following can the database specialist use to investigate the query plan and analyze the query performance?Read More →

A company provisioned a three-tier application by using AWS CloudFormation and an Amazon RDS DB instance.During a test, a database administrator accidentally deleted the CloudFormation stack.The results were a deletion of all the resources, including the DB instance, and a loss of critical data.The company wants to prevent accidental deletion of a DB instance from happening in the future.Which solutions will meet this requirement? (Choose two.)Read More →

A company has a variety of Amazon Aurora DB clusters.Each of these DB clusters has various configurations that meet specific sets of requirements.Depending on the team and the use case, these configurations can be organized into broader categories.A database specialist wants to implement a solution to make the storage and modification of the configuration parameters more systematic.Which AWS service or feature should the database specialist use to meet these requirements?Read More →

A startup company is developing electric vehicles.These vehicles are expected to send real-time data to the AWS Cloud for data analysis.This data will include trip metrics, trip duration, and engine temperature.The database team decides to store the data for 15 days using Amazon DynamoDB.How can the database team achieve this with the LEAST operational overhead?Read More →

A company uses AWS Lambda functions in a private subnet in a VPC to run application logic.The Lambda functions must not have access to the public internet.Additionally, all data communication must remain within the private network.As part of a new requirement, the application logic needs access to an Amazon DynamoDB table.What is the MOST secure way to meet this new requirement?Read More →

A company uses Microsoft SQL Server on Amazon RDS in a Multi-AZ deployment as the database engine for its application.The company was recently acquired by another company.A database specialist must rename the database to follow a new naming standard.Which combination of steps should the database specialist take to rename the database? (Choose two.)Read More →

A company is running a mobile app that has a backend database in Amazon DynamoDB.The app experiences sudden increases and decreases in activity throughout the day.The company’s operations team notices that DynamoDB read and write requests are being throttled at different times, resulting in a negative customer experience.Which solution will solve the throttling issue without requiring changes to the app?Read More →

A company has branch offices in the United States and Singapore.The company has a three-tier web application that uses a shared database.The database runs on an Amazon RDS for MySQL DB instance that is hosted in the us-west-2 Region.The application has a distributed front end that is deployed in us-west-2 and in the ap-southeast-1 Region.The company uses this front end as a dashboard that provides statistics to sales managers in each branch office.The dashboard loads more slowly in the Singapore branch office than in the United States branch office.The company needs a solution so that the dashboard loads consistently for users in each location.Which solution will meet these requirements in the MOST operationally efficient way?Read More →