Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Amazon
  5. DBS-C01

Amazon DBS-C01 Exam Questions
AWS Certified Database - Specialty (Page 9 )

Updated On: 10-Mar-2026
Page 9 of 67
PDF with 359 Questions

A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica. The Database Specialist wants to implement load balancing and high availability for the read-only applications.
Which solution meets these requirements?

  1. Use a specific instance endpoint for each replica and add the instance endpoint to each read-only application connection string.
  2. Use reader endpoints for both the read-only workload applications.
  3. Use a reader endpoint for one read-only application and use an instance endpoint for the other read-only application.
  4. Use custom endpoints for the two read-only applications.

Answer(s): D


Reference:

https://rimzy.net/category/amazon-rds/page/4/



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 eachgame has a unique game_id.

Which choice of keys is recommended for the DynamoDB table?

  1. Create a global secondary index with game_id as the partition key
  2. Create a global secondary index with user_id as the partition key
  3. Create a composite primary key with game_id as the partition key and user_id as the sort key
  4. Create a composite primary key with user_id as the partition key and game_id as the sort key

Answer(s): D


Reference:

https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design- patterns/



A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option.
How should the Database Specialist satisfy this new requirement?

  1. Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.
  2. Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
  3. Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
  4. Create an encrypted read replica of the RDS DB instance. Promote it the master.

Answer(s): A



A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance.
When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?

  1. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
  2. Enhanced Monitoring is not enabled on the source DB instance.
  3. The minor MySQL version in the source DB instance does not support read replicas.
  4. Automated backups are not enabled on the source DB instance.

Answer(s): D

Explanation:


Reference:

https://aws.amazon.com/rds/features/read-replicas/



A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.
How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

  1. Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
  2. Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.
  3. Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
  4. Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Answer(s): C


Reference:

https://docs.aws.amazon.com/systems-manager/latest/userguide/mw-cli-task-options.html



Viewing page 9 of 67
Viewing questions 41 - 45 out of 359 questions



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

DBS-C01 Exam Discussions & Posts

AI Tutor