Free DBS-C01 Exam Braindumps
AWS Certified Database - Specialty Questions 151–155 (page: 32)

Updated On: 10-Feb-2026

An online advertising company uses an Amazon DynamoDb table as its data store. The table has Amazon DynamoDB Streams enabled and has a global secondary index on one of the keys. The table is encrypted using an AWS Key Management Service (AWS KMS) customer managed key.

The company has decided to expand its operations globally and wants to replicate the database in a different AWS Region by using DynamoDB global tables. Upon review, an administrator notices the following:

-No role with the dynamodb: CreateGlobalTable permission exists in the account.
-An empty table with the same name exists in the new Region where replication is desired.
-A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.

Which configurations will block the creation of a global table or the creation of a replica in the new Region? (Choose two.)

  1. A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.
  2. An empty table with the same name exists in the Region where replication is desired.
  3. No role with the dynamodb:CreateGlobalTable permission exists in the account.
  4. DynamoDB Streams is enabled for the table.
  5. The table is encrypted using a KMS customer managed key.

Answer(s): A,D



A large automobile company is migrating the database of a critical financial application to Amazon DynamoDB.

The company’s risk and compliance policy requires that every change in the database be recorded as a log entry for audits. The system is anticipating more than 500,000 log entries each minute. Log entries should be stored in batches of at least 100,000 records in each file in Apache Parquet format.
How should a database specialist implement these requirements with DynamoDB?

  1. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon S3 object.
  2. Create a backup plan in AWS Backup to back up the DynamoDB table once a day. Create an AWS Lambda function that restores the backup in another table and compares both tables for changes. Generate the log entries and write them to an Amazon S3 object.
  3. Enable AWS CloudTrail logs on the table. Create an AWS Lambda function that reads the log files once an hour and filters DynamoDB API actions. Write the filtered log files to Amazon S3.
  4. Enable Amazon DynamoDB Streams on the table. Create an AWS Lambda function triggered by the stream. Write the log entries to an Amazon Kinesis Data Firehose delivery stream with buffering and Amazon S3 as the destination.

Answer(s): D



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



Viewing page 32 of 67
Viewing questions 156 - 160 out of 359 questions


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

AI Tutor AI Tutor 👋 I’m here to help!