Free AWS Certified Database - Specialty Exam Questions and Answers

Last updated: September 11, 2026

Provider

Amazon

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed. What is the MOST operationally efficient and cost-effective solution?

   • A. Configure RDS Storage Auto Scaling.
   • B. Configure RDS instance Auto Scaling.
   • C. Modify the DB instance allocated storage to meet the forecasted requirements.
   • D. Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.
   Reveal Answer

2. Question #2

   A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one medium- sized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas. In the event of a primary failure, what will occur?

   • A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
   • B. Aurora will promote an arbitrary Aurora Replica
   • C. Aurora will promote the largest-sized Aurora Replica
   • D. Aurora will not promote an Aurora Replica
   Reveal Answer

3. Question #3

   A gaming company has implemented a leaderboard in AWS using a Sorted Set data structure within Amazon ElastiCache for Redis. The ElastiCache cluster has been deployed with cluster mode disabled and has a replication group deployed with two additional replicas. The company is planning for a worldwide gaming event and is anticipating a higher write load than what the current cluster can handle. Which method should a Database Specialist use to scale the ElastiCache cluster ahead of the upcoming event?

   • A. Enable cluster mode on the existing ElastiCache cluster and configure separate shards for the Sorted Set across all nodes in the cluster.
   • B. Increase the size of the ElastiCache cluster nodes to a larger instance size.
   • C. Create an additional ElastiCache cluster and load-balance traffic between the two clusters.
   • D. Use the EXPIRE command and set a higher time to live (TTL) after each call to increment a given key.
   Reveal Answer

4. Question #4

   A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests. Which should the database specialist do to allow the database team to create the test tables?

   • A. Contact AWS Support to disable read-only mode on the read replic
   • B. Reboot the read replic
   • C. Connect to the read replica and create the tables.
   • D. Change the read_only parameter to false (read_only=0) in the default parameter group of the read replic
   Reveal Answer

5. Question #5

   A marketing company is using Amazon DocumentDB and requires that database audit logs be enabled. A Database Specialist needs to configure monitoring so that all data definition language (DDL) statements performed are visible to the Administrator. The Database Specialist has set the audit_logs parameter to enabled in the cluster parameter group. What should the Database Specialist do to automatically collect the database logs for the Administrator?

   • A. Enable DocumentDB to export the logs to Amazon CloudWatch Logs
   • B. Enable DocumentDB to export the logs to AWS CloudTrail
   • C. Enable DocumentDB Events to export the logs to Amazon CloudWatch Logs
   • D. Configure an AWS Lambda function to download the logs using the download-db-log-file-portion operation and store the logs in Amazon S3
   Reveal Answer

6. Question #6

   The Amazon CloudWatch metric for FreeLocalStorage on an Amazon Aurora MySQL DB instance shows that the amount of local storage is below 10 MB. A database engineer must increase the local storage available in the Aurora DB instance. How should the database engineer meet this requirement?

   • A. Modify the DB instance to use an instance class that provides more local SSD storage.
   • B. Modify the Aurora DB cluster to enable automatic volume resizing.
   • C. Increase the local storage by upgrading the database engine version.
   • D. Modify the DB instance and configure the required storage volume in the configuration section.
   Reveal Answer

7. Question #7

   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?

   • A. Create a snapshot of the unencrypted RDS DB instanc
   • B. Create an encrypted copy of the unencrypted snapsho
   • C. Restore the encrypted snapshot copy.
   • D. Modify the RDS DB instanc
   Reveal Answer

8. Question #8

   A database expert is responsible for building a highly available online transaction processing (OLTP) solution that makes use of Amazon RDS for MySQL production databases. Disaster recovery criteria include a cross-regional deployment and an RPO and RTO of 5 and 30 minutes, respectively. What should the database professional do to ensure that the database meets the criteria for high availability and disaster recovery?

   • A. Use a Multi-AZ deployment in each Region.
   • B. Use read replica deployments in all Availability Zones of the secondary Region.
   • C. Use Multi-AZ and read replica deployments within a Region.
   • D. Use Multi-AZ and deploy a read replica in a secondary Region.
   Reveal Answer

9. Question #9

   In North America, a business launched a mobile game that swiftly expanded to 10 million daily active players. The game's backend is hosted on AWS and makes considerable use of a TTL-configured Amazon DynamoDB table. When an item is added or changed, its TTL is set to 600 seconds plus the current epoch time. The game logic is reliant on the purging of outdated data in order to compute rewards points properly. At times, items from the table are read that are many hours beyond their TTL expiration. How should a database administrator resolve this issue?

   • A. Use a client library that supports the TTL functionality for DynamoDB.
   • B. Include a query filter expression to ignore items with an expired TTL.
   • C. Set the ConsistentRead parameter to true when querying the table.
   • D. Create a local secondary index on the TTL attribute.
   Reveal Answer

10. Question #10

    A major organization maintains a number of Amazon DB clusters. Each of these clusters is configured differently to meet certain needs. These configurations may be classified into wider groups based on the team and use case. A database administrator wishes to streamline the process of storing and updating these settings. Additionally, the database administrator want to guarantee that changes to certain configuration categories are automatically implemented to all instances as necessary. Which AWS service or functionality will assist in automating and achieving this goal?

    • A. AWS Systems Manager Parameter Store
    • B. DB parameter group
    • C. AWS Config
    • D. AWS Secrets Manager
    Reveal Answer