DBS-C01 (Page 26)

A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues.A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created.The database specialist must effectively apply this new partition key to all existing and new data.How can this solution be implemented?Read More →

A company’s application team needs to select an AWS managed database service to store application and user data.The application team is familiar with MySQL but is open to new solutions.The application and user data is stored in 10 tables and is de-normalized.The application will access this data through an API layer using a unique ID in each table.The company expects the traffic to be light at first, but the traffic will increase to thousands of transactions each second within the first year.The database service must support active reads and writes in multiple AWS Regions at the same time.Query response times need to be less than 100 ms.Which AWS database solution will meet these requirements?Read More →

A company is running its critical production workload on a 500 GB Amazon Aurora MySQL DB cluster.A database engineer must move the workload to a newAmazon Aurora Serverless MySQL DB cluster without data loss.Which solution will accomplish the move with the LEAST downtime and the LEAST application impact?Read More →

A company stores critical data for a department in Amazon RDS for MySQL DB instances.The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time.To meet this requirement, the database specialist stopped all theDB instances used by the department but did not select the option to create a snapshot.Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.What could be the reason for this?Read More →

A company recently created a snapshot of an Amazon RDS for PostgreSQL DB instance that hosts a production database.The company created a new DB instance from the snapshot to test a new application feature while providing isolation from the production database.During testing of the new application feature, the company noticed that read latency on the new database was higher than normal.A database specialist needs to resolve the latency issue.Which solution will meet these requirements with the MOST operational efficiency?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 →

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