DBS-C01 (Page 32)

An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store.The database should be designated to support the following use cases:✑ Update scores in real time whenever a player is playing the game.✑ Retrieve a player’s score details for a specific game session.A Database Specialist decides to implement a DynamoDB table.Each player has a unique user_id and each game has a unique game_id.Which choice of keys is recommended for the DynamoDB table?Read More →

A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours.To meet the company’s disaster recovery policies, the database backup needs to be copied into another Region.The company requires the solution to be cost-effective and operationally efficient.What should a Database Specialist do to copy the database backup into a different Region?Read More →

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load.The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.What should a Database Specialist do in this situation to increase performance and return latency to sub-second levels?Read More →

A company has an application that uses an Amazon DynamoDB table to store user data.Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management.A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time.A database specialist needs to improve the performance of the process.The database specialist notes that, when the process is running, 15% of the table’s provisioned read capacity units (RCUs) are being used.What should the database specialist do?Read More →

A company is building a software as a service application.As part of the new user sign-on workflow, a Python script invokes the CreateTable operation using theAmazon DynamoDB API.After the call returns, the script attempts to call PutItem.Occasionally, the PutItem request fails with a ResourceNotFoundException error, which causes the workflow to fail.The development team has confirmed that the same table name is used in the two API calls.How should a database specialist fix this issue?Read More →