Free DBS-C01 Exam Braindumps (page: 39)

Page 39 of 82

A company released a mobile game that quickly grew to 10 million daily active users in North America. The game’s backend is hosted on AWS and makes extensive use of an Amazon DynamoDB table that is configured with a TTL attribute.

When an item is added or updated, its TTL is set to the current epoch time plus 600 seconds. The game logic relies on old data being purged so that it can calculate rewards points accurately. Occasionally, items are read from the table that are several hours past their TTL expiry.
How should a database specialist fix this issue?

  1. Use a client library that supports the TTL functionality for DynamoDB.
  2. Include a query filter expression to ignore items with an expired TTL.
  3. Set the ConsistentRead parameter to true when querying the table.
  4. Create a local secondary index on the TTL attribute.

Answer(s): B



A development team at an international gaming company is experimenting with Amazon DynamoDB to store in-game events for three mobile games. The most popular game hosts a maximum of 500,000 concurrent users, and the least popular game hosts a maximum of 10,000 concurrent users. The average size of an event is 20 KB, and the average user session produces one event each second. Each event is tagged with a time in milliseconds and a globally unique identifier. The lead developer created a single DynamoDB table for the events with the following schema:
-Partition key: game name Sort key: event identifier
-Local secondary index: player identifier Event time

The tests were successful in a small-scale development environment. However, when deployed to production, new events stopped being added to the table and the logs show DynamoDB failures with the ItemCollectionSizeLimitExceededException error code.

Which design change should a database specialist recommend to the development team?

  1. Use the player identifier as the partition key. Use the event time as the sort key. Add a global secondary index with the game name as the partition key and the event time as the sort key.
  2. Create two tables. Use the game name as the partition key in both tables. Use the event time as the sort key for the first table. Use the player identifier as the sort key for the second table.
  3. Replace the sort key with a compound value consisting of the player identifier collated with the event time, separated by a dash. Add a local secondary index with the player identifier as the sort key.
  4. Create one table for each game. Use the player identifier as the partition key. Use the event time as the sort key.

Answer(s): D



An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance. The company expects a spike in read traffic due to an upcoming sale. A database specialist must create a read replica of the DB instance to serve the anticipated read traffic.
Which actions should the database specialist take before creating the read replica? (Choose two.)

  1. Identify a potential downtime window and stop the application calls to the source DB instance.
  2. Ensure that automatic backups are enabled for the source DB instance.
  3. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
  4. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
  5. Modify the read replica parameter group setting and set the value to 1.

Answer(s): B,C



A company is running a two-tier ecommerce application in one AWS account. The application is backed by an Amazon RDS for MySQL Multi-AZ DB instance. A developer mistakenly deleted the DB instance in the production environment. The company restores the database, but this event results in hours of downtime and lost revenue.

Which combination of changes would minimize the risk of this mistake occurring in the future? (Choose three.)

  1. Grant least privilege to groups, IAM users, and roles.
  2. Allow all users to restore a database from a backup.
  3. Enable deletion protection on existing production DB instances.
  4. Use an ACL policy to restrict users from DB instance deletion.
  5. Enable AWS CloudTrail logging and Enhanced Monitoring.

Answer(s): A,C,D



Page 39 of 82



Post your Comments and Discuss Amazon DBS-C01 exam with other Community members:

Pedro commented on April 27, 2024
Thanks for the dumps. It was an easy pass.
UNITED STATES
upvote

Keran commented on April 26, 2024
All of these questions are in the real exam. I just wrote my test yesterday. This is a valid exam dumps.
Anonymous
upvote

Mungara commented on March 14, 2023
thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES
upvote

Mungara commented on March 14, 2023
Thanks to this exam dumps, I felt confident and passed my exam with ease.
UNITED STATES
upvote

otaku commented on August 11, 2022
just passed my dbs-c01 exam this site is really helped a lot.
Anonymous
upvote

Erik commented on March 02, 2022
These braindumps questions make passing very easy.
UNITED KINGDOM
upvote

Sanjev commented on January 12, 2022
This is the easiest way to get a 90%. Perfect exam dumps.
UNITED STATES
upvote

Abigail commented on September 20, 2021
I know using prep course are not ethical but I had to do this as this exam is way too hard to pass on your own. Thid prep course got me out of trouble.
UNITED STATES
upvote