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
    :Jul 12, 2026

Amazon DBS-C01 Online Questions & Answers

  • Question 1:

    A company is migrating its on-premises database workloads to the AWS Cloud. A database specialist performing the move has chosen AWS DMS to migrate an Oracle database with a large table to Amazon RDS. The database specialist notices that AWS DMS is taking significant time to migrate the data. Which actions would improve the data migration speed? (Choose three.)

    A. Create multiple AWS DMS tasks to migrate the large table.
    B. Configure the AWS DMS replication instance with Multi-AZ.
    C. Increase the capacity of the AWS DMS replication server.
    D. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
    E. Enable an Amazon RDS Multi-AZ configuration.
    F. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

  • Question 2:

    A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.

    Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.

    Which approach should the Database Specialist take to reduce downtime?

    A. Deploy multiple read replicas and have the team members make changes to separate replica instances
    B. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
    C. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
    D. Enable the Amazon RDS for MySQL Backtrack feature

  • Question 3:

    A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully.

    What could be the reason for this?

    A. When stopping the DB instance, the option to create a snapshot should have been selected.
    B. When stopping the DB instance, the duration for stopping the DB instance should have been selected.
    C. Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.
    D. Stopped DB instances will automatically restart if the instance is not manually started after 7 days.

  • Question 4:

    An IT consulting company wants to reduce costs when operating its development environment databases. The company's workflow creates multiple Amazon Aurora MySQL DB clusters for each development group. The Aurora DB clusters are only used for 8 hours a day. The DB clusters can then be deleted at the end of the development cycle, which lasts 2 weeks.

    Which of the following provides the MOST cost-effective solution?

    A. Use AWS CloudFormation templates. Deploy a stack with the DB cluster for each development group. Delete the stack at the end of the development cycle.
    B. Use the Aurora DB cloning feature. Deploy a single development and test Aurora DB instance, and create clone instances for the development groups. Delete the clones at the end of the development cycle.
    C. Use Aurora Replicas. From the master automatic pause compute capacity option, create replicas for each development group, and promote each replica to master. Delete the replicas at the end of the development cycle.
    D. Use Aurora Serverless. Restore current Aurora snapshot and deploy to a serverless cluster for each development group. Enable the option to pause the compute capacity on the cluster and set an appropriate timeout.

  • Question 5:

    A large retail company recently migrated its three-tier ecommerce applications to AWS. The company's backend database is hosted on Amazon Aurora PostgreSQL. During peak times, users complain about longer page load times. A

    database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.

    How should this issue be resolved?

    A. Modify the application to commit transactions in batches
    B. Add a new Aurora Replica to the Aurora DB cluster.
    C. Add an Amazon ElastiCache for Redis cluster and change the application to write through.
    D. Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).

  • Question 6:

    A company has branch offices in the United States and Singapore. The company has a three-tier web application that uses a shared database. The database runs on an Amazon RDS for MySQL DB instance that is hosted in the us-west-2 Region. The application has a distributed front end that is deployed in us-west-2 and in the ap-southeast-1 Region. The company uses this front end as a dashboard that provides statistics to sales managers in each branch office.

    The dashboard loads more slowly in the Singapore branch office than in the United States branch office. The company needs a solution so that the dashboard loads consistently for users in each location.

    Which solution will meet these requirements in the MOST operationally efficient way?

    A. Take a snapshot of the DB instance in us-west-2. Create a new DB instance in ap- southeast-2 from the snapshot. Reconfigure the ap-southeast-1 front-end dashboard to access the new DB instance.
    B. Create an RDS read replica in ap-southeast-1 from the primary DB instance in us-west-2. Reconfigure the ap-southeast-1 front-end dashboard to access the read replica.
    C. Create a new DB instance in ap-southeast-1. Use AWS Database Migration Service (AWS DMS) and change data capture (CDC) to update the new DB instance in ap- southeast-1. Reconfigure the ap-southeast-1 front-end dashboard to access the new DB instance.
    D. Create an RDS read replica in us-west-2, where the primary DB instance resides. Create a read replica in ap-southeast-1 from the read replica in us-west-2. Reconfigure the ap-southeast-1 front-end dashboard to access the read replica in ap-southeast-1.

  • Question 7:

    A company has an on-premises production Microsoft SQL Server with 250 GB of data in one database. A database specialist needs to migrate this on-premises SQL Server to Amazon RDS for SQL Server. The nightly native SQL Server backup file is approximately 120 GB in size. The application can be down for an extended period of time to complete the migration. Connectivity between the on-premises environment and AWS can be initiated from on-premises only.

    How can the database be migrated from on-premises to Amazon RDS with the LEAST amount of effort?

    A. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Download the backup files on an Amazon EC2 instance and restore them from the EC2 instance into the new production RDS instance.
    B. Back up the SQL Server database using a native SQL Server backup. Upload the backup files to Amazon S3. Restore the backup files from the S3 bucket into the new production RDS instance.
    C. Provision and configure AWS DMS. Set up replication between the on-premises SQL Server environment to replicate the database to the new production RDS instance.
    D. Back up the SQL Server database using AWS Backup. Once the backup is complete, restore the completed backup to an Amazon EC2 instance and move it to the new production RDS instance.

  • Question 8:

    A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.

    Which step should be taken to troubleshoot this issue?

    A. Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine's IP address
    B. Ensure that the RDS DB instance's subnet group includes a public subnet to allow the Developer to connect
    C. Ensure that the RDS DB instance has not reached its maximum connections limit
    D. Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections

  • Question 9:

    An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second. The number of orders and exact schedule for the sale will vary each day. During the sale, approximately 10,000 concurrent users will look at the deals before buying items. Outside of the sale, the traffic volume is very low. The acceptable performance for read/write queries should be under 25 ms. Order items are about 2 KB in size and have a unique identifier. The company requires the most cost- effective solution that will automatically scale and is highly available.

    Which solution meets these requirements?

    A. Amazon DynamoDB with on-demand capacity mode
    B. Amazon Aurora with one writer node and an Aurora Replica with the parallel query feature enabled
    C. Amazon DynamoDB with provisioned capacity mode with 5,000 write capacity units (WCUs) and 10,000 read capacity units (RCUs)
    D. Amazon Aurora with one writer node and two cross-Region Aurora Replicas

  • Question 10:

    A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific database wait events to better understand the situation.

    How can the Database Specialists accomplish this?

    A. Enable the option to push all database logs to Amazon CloudWatch for advanced analysis
    B. Create appropriate Amazon CloudWatch dashboards to contain specific periods of time
    C. Enable Amazon RDS Performance Insights and review the appropriate dashboard
    D. Enable Enhanced Monitoring will the appropriate settings

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.