DBS-C01 (Page 30)

An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores.After an intensive advertisement campaign in SouthAmerica, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM.The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM.Customer service has also reported that several users are complaining about their scores not being registered.How should the database administrator remediate this issue at the lowest cost?Read More →

A company’s application development team wants to share an automated snapshot of its Amazon RDS database with another team.The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the “WeShare” AWS account.The application development team needs to share the DB snapshot under the “WeReceive” AWS account.Which combination of actions must the application development team take to meet these requirements? (Choose two.)Read More →

A company is working on migrating a large Oracle database schema with 3,500 stored procedures to Amazon Aurora PostgreSQL.An application developer is using the AWS Schema Conversion Tool (AWS SCT) to convert code from Oracle to Aurora PostgreSQL.However, the code conversion is taking a longer time with performance issues.The application team has reached out to a database specialist to improve the performance of the AWS SCT conversion.What should the database specialist do to resolve the performance issues?Read More →

An ecommerce company is migrating its core application database to Amazon Aurora MySQL.The company is currently performing online transaction processing(OLTP) stress testing with concurrent database sessions.During the first round of tests, a database specialist noticed slow performance for some specific write operations.Reviewing Amazon CloudWatch metrics for the Aurora DB cluster showed 90% CPU utilization.Which steps should the database specialist take to MOST effectively identify the root cause of high CPU utilization and slow performance? (Choose two.)Read More →

A city’s weather forecast team is using Amazon DynamoDB in the data tier for an application.The application has several components.The analysis component of the application requires repeated reads against a large dataset.The application has started to temporarily consume all the read capacity in the DynamoDB table and is negatively affecting other applications that need to access the same data.Which solution will resolve this issue with the LEAST development effort?Read More →

A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Aurora.The cost for the database migration must be kept to a minimum, and both the on-premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora.Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)Read More →

A company has a 20 TB production Amazon Aurora DB cluster.The company runs a large batch job overnight to load data into the Aurora DB cluster.To ensure the company’s development team has the most up-to-date data for testing, a copy of the DB cluster must be available in the shortest possible time after the batch job completes.How should this be accomplished?Read More →

A company is using Amazon RDS for PostgreSQL.The Security team wants all database connection requests to be logged and retained for 180 days.The RDS for PostgreSQL DB instance is currently using the default parameter group.A Database Specialist has identified that setting the log_connections parameter to 1 will enable connections logging.Which combination of steps should the Database Specialist take to meet the logging and retention requirements? (Choose two.)Read More →

An ecommerce company migrates an on-premises MongoDB database to Amazon DocumentDB (with MongoDB compatibility).After the migration, a database specialist realizes that encryption at rest has not been turned on for the Amazon DocumentDB cluster.What should the database specialist do to enable encryption at rest for the Amazon DocumentDB cluster?Read More →

A large financial services company requires that all data be encrypted in transit.A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist.Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure.The Developer asked the Database Specialist to reset the password a number of times, but the error persists.Which step should be taken to troubleshoot this issue?Read More →