1. Home
  2. Amazon
  3. DBS-C01

Amazon DBS-C01 Online Practice Questions and Exam Preparation

DBS-C01 Exam Details

  • Exam Code
    :DBS-C01
  • Exam Name
    :AWS Certified Database - Specialty (DBS-C01)
  • Certification
    :Amazon Certifications
  • Vendor
    :Amazon
  • Total Questions
    :321 Q&As
  • Last Updated
    :May 30, 2026

Amazon DBS-C01 Online Questions & Answers

  • Question 211:

    A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table. TTL is enabled on one of the attributes. The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.

    What is the MOST likely reason that the items are not being deleted?

    A. The TTL attribute's value is set as a Number data type.
    B. The TTL attribute's value is set as a Binary data type.
    C. The TTL attribute's value is a timestamp in the Unix epoch time format in seconds.
    D. The TTL attribute's value is set with an expiration of 1 year.

  • Question 212:

    Amazon RDS for Oracle with Transparent Data Encryption is used by a financial services organization (TDE). At all times, the organization is obligated to encrypt its data at rest. The decryption key must be widely distributed, and access to the key must be restricted. The organization must be able to rotate the encryption key on demand to comply with regulatory requirements. If any possible security vulnerabilities are discovered, the organization must be able to disable the key. Additionally, the company's overhead must be kept to a minimal.

    What method should the database administrator use to configure the encryption to fulfill these specifications?

    A. AWS CloudHSM
    B. AWS Key Management Service (AWS KMS) with an AWS managed key
    C. AWS Key Management Service (AWS KMS) with server-side encryption
    D. AWS Key Management Service (AWS KMS) CMK with customer-provided material

  • Question 213:

    A ride-hailing application stores bookings in a persistent Amazon RDS for MySQL DB instance. This program is very popular, and the corporation anticipates a tenfold rise in the application's user base over the next several months. The application receives a higher volume of traffic in the morning and evening.

    This application is divided into two sections:

    An internal booking component that takes online reservations in response to concurrent user queries.

    A component of a third-party customer relationship management (CRM) system that customer service professionals utilize. Booking data is accessed using queries in the CRM.

    To manage this workload effectively, a database professional must create a cost-effective database system.

    Which solution satisfies these criteria?

    A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
    B. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
    C. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
    D. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

  • Question 214:

    A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards. Millions of players around the world will complete in annual tournaments. The company wants to implement an architecture that is highly available. The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.

    Which combination of steps should the company take to meet these requirements? (Choose two.)

    A. Deploy an ElastiCache for Redis cluster with read replicas and Multi-AZ enabled.
    B. Deploy an ElastiCache for Memcached global datastore.
    C. Deploy a single-node ElastiCache for Redis cluster with automatic backups enabled. In the event of a failure, create a new cluster and restore data from the most recent backup.
    D. Use the default maintenance window to apply any required system changes and mandatory updates as soon as they are available.
    E. Choose a preferred maintenance window at the time of lowest usage to apply any required changes and mandatory updates.

  • Question 215:

    A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.

    Which backup methodology should the database specialist use to MINIMIZE management overhead?

    A. Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.
    B. Create an AWS Lambda function that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.
    C. Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.
    D. Configure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.

  • Question 216:

    A company plans to migrate a MySQL-based application from an on-premises environment to AWS. The application performs database joins across several tables and uses indexes for faster query response times. The company needs the database to be highly available with automatic failover.

    Which solution on AWS will meet these requirements with the LEAST operational overhead?

    A. Deploy an Amazon RDS DB instance with a read replica.
    B. Deploy an Amazon RDS Multi-AZ DB instance.
    C. Deploy Amazon DynamoDB global tables.
    D. Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health checks configured.

  • Question 217:

    A business's production databases are housed on a 3 TB Amazon Aurora MySQL DB cluster. The database cluster is installed in the region us-east-1. For disaster recovery (DR) requirements, the company's database expert needs to fast deploy the DB cluster in another AWS Region to handle the production load with an RTO of less than two hours.

    Which approach is the MOST OPERATIONALLY EFFECTIVE in meeting these requirements?

    A. Implement an AWS Lambda function to take a snapshot of the production DB cluster every 2 hours, and copy that snapshot to an Amazon S3 bucket in the DR Region. Restore the snapshot to an appropriately sized DB cluster in the DR Region.
    B. Add a cross-Region read replica in the DR Region with the same instance type as the current primary instance. If the read replica in the DR Region needs to be used for production, promote the read replica to become a standalone DB cluster.
    C. Create a smaller DB cluster in the DR Region. Configure an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) enabled to replicate data from the current production DB cluster to the DB cluster in the DR Region.
    D. Create an Aurora global database that spans two Regions. Use AWS Database Migration Service (AWS DMS) to migrate the existing database to the new global database.

  • Question 218:

    A ride-hailing application uses an Amazon RDS for MySQL DB instance as persistent storage for bookings. This application is very popular and the company expects a tenfold increase in the user base in next few months. The application

    experiences more traffic during the morning and evening hours.

    This application has two parts:

    An in-house booking component that accepts online bookings that directly correspond to simultaneous requests from users.

    A third-party customer relationship management (CRM) component used by customer care representatives. The CRM uses queries to access booking data.

    A database specialist needs to design a cost-effective database solution to handle this workload. Which solution meets these requirements?

    A. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to the RDS for MySQL DB instance used by the CRM.
    B. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to an Amazon SQS queue. This triggers another Lambda function that pulls data from Amazon SQS and writes it to the RDS for MySQL DB instance used by the CRM.
    C. Use Amazon ElastiCache for Redis to accept the bookings. Associate an AWS Lambda function to capture changes and push the booking data to an Amazon Redshift database used by the CRM.
    D. Use Amazon DynamoDB to accept the bookings. Enable DynamoDB Streams and associate an AWS Lambda function to capture changes and push the booking data to Amazon Athena, which is used by the CRM.

  • Question 219:

    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?

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

  • Question 220:

    A retail company uses Amazon Redshift Spectrum to run complex analytical queries on objects that are stored in an Amazon S3 bucket. The objects are joined with multiple dimension tables that are stored in an Amazon Redshift database. The company uses the database to create monthly and quarterly aggregated reports. Users who attempt to run queries are reporting the following error message: error: Spectrum Scan Error: Access throttled.

    Which solution will resolve this error?

    A. Check file sizes of fact tables in Amazon S3, and look for large files. Break up large files into smaller files of equal size between 100 MB and 1 GB
    B. Reduce the number of queries that users can run in parallel.
    C. Check file sizes of fact tables in Amazon S3, and look for small files. Merge the small files into larger files of at least 64 MB in size.
    D. Review and optimize queries that submit a large aggregation step to Redshift Spectrum.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Amazon exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DBS-C01 exam preparations and Amazon certification application, do not hesitate to visit our Vcedump.com to find your solutions here.