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 91:

    Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.

    Which procedures should the database professional do prior to establishing the read replica? (Select two.)

    A. Identify a potential downtime window and stop the application calls to the source DB instance.
    B. Ensure that automatic backups are enabled for the source DB instance.
    C. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
    D. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
    E. Modify the read replica parameter group setting and set the value to 1.

  • Question 92:

    A database specialist needs to configure an Amazon RDS for MySQL DB instance to close non-interactive connections that are inactive after 900 seconds.

    What should the database specialist do to accomplish this task?

    A. Create a custom DB parameter group and set the wait_timeout parameter value to 900. Associate the DB instance with the custom parameter group.
    B. Connect to the MySQL database and run the SET SESSION wait_timeout=900 command.
    C. Edit the my.cnf file and set the wait_timeout parameter value to 900. Restart the DB instance.
    D. Modify the default DB parameter group and set the wait_timeout parameter value to 900.

  • Question 93:

    A database specialist needs to reduce the cost of an application's database. The database is running on a Multi-AZ deployment of an Amazon ROS for Microsoft SQL Server DB instance. The application requires the database to support stored procedures, SQL Server Wire Protocol (TDS), and T-SQC The database must also be highly available. The database specialist is using AWS Database Migration Service (AWS DMS) to migrate the database to a new data store.

    Which solution will reduce the cost of the database with the LEAST effort?

    A. Use AWS Database Migration Service (DMS) to migrate to an RDS for MySQL Multi-AZ database. Update the application code to use the features of MySQL that correspond to SQL Server. Update the application to use the MySQL port.
    B. use AWS Database Migration Serve (OMS) to migrate to an RDS for PostgreSQL Multi- AZ database. Turn on the SQL_COMPAT optional extension within the database to allow the required features. Update the application to use the PostgreSQL port
    C. Use AWS Database Migration Service (OMS) to migrate to an RDS for SQL Server Single-AZ database. Update the application to use the new database endpoint
    D. Use AWS Database Migration Service (DMS) to migrate the database to Amazon Aurora PostgreSOL_ Turn on Babelfish for Aurora PostgreSOL_ Update the application to use the Babelfish TDS port.

  • Question 94:

    A database specialist needs to replace the encryption key for an Amazon RDS DB instance. The database specialist needs to take immediate action to ensure security of the database.

    Which solution will meet these requirements?

    A. Modify the DB instance to update the encryption key. Perform this update immediately without waiting for the next scheduled maintenance window.
    B. Export the database to an Amazon S3 bucket. Import the data to an existing DB instance by using the export file. Specify a new encryption key during the import process.
    C. Create a manual snapshot of the DB instance. Create an encrypted copy of the snapshot by using a new encryption key. Create a new DB instance from the encrypted snapshot.
    D. Create a manual snapshot of the DB instance. Restore the snapshot to a new DB instance. Specify a new encryption key during the restoration process.

  • Question 95:

    A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and OLAP reports for the human resources department. To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.

    Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

    A. Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
    B. Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.
    C. Create additional readers to cater to the different scenarios.
    D. Use custom endpoints to satisfy the different workloads.

  • Question 96:

    A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS. The company's main workload consists of a mission-critical application that updates its application data in a data store. The team at the Tokyo office is building dashboards with complex analytical queries using the application data. The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.

    Which solution meets these requirements?

    A. Use an Amazon RDS DB instance deployed in the us-east-1 Region with a read replica instance in the ap- northeast-1 Region. Create an Amazon ElastiCache cluster in the ap- northeast-1 Region to cache application data from the replica to generate the dashboards.
    B. Use an Amazon DynamoDB global table in the us-east-1 Region with replication into the ap-northeast-1 Region. Use Amazon QuickSight for displaying dashboard results.
    C. Use an Amazon RDS for MySQL DB instance deployed in the us-east-1 Region with a read replica instance in the ap-northeast-1 Region. Have the dashboard application read from the read replica.
    D. Use an Amazon Aurora global database. Deploy the writer instance in the us-east-1 Region and the replica in the ap-northeast-1 Region. Have the dashboard application read from the replica ap-northeast-1 Region.

  • Question 97:

    A stock market analysis firm maintains two locations: one in the us-east-1 Region and another in the eu-west-2 Region. The business want to build an AWS database solution capable of providing rapid and accurate updates.

    Dashboards with advanced analytical queries are used to present data in the eu-west-2 office. Because the corporation will use these dashboards to make purchasing choices, they must have less than a second to obtain application data.

    Which solution satisfies these criteria and gives the MOST CURRENT dashboard?

    A. Deploy an Amazon RDS DB instance in us-east-1 with a read replica instance in eu- west-2. Create an Amazon ElastiCache cluster in eu-west-2 to cache data from the read replica to generate the dashboards.
    B. Use an Amazon DynamoDB global table in us-east-1 with replication into eu-west-2. Use multi-active replication to ensure that updates are quickly propagated to eu-west-2.
    C. Use an Amazon Aurora global database. Deploy the primary DB cluster in us-east-1. Deploy the secondary DB cluster in eu-west-2. Configure the dashboard application to read from the secondary cluster.
    D. Deploy an Amazon RDS for MySQL DB instance in us-east-1 with a read replica instance in eu-west-2. Configure the dashboard application to read from the read replica.

  • Question 98:

    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?

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

  • Question 99:

    A database specialist has been entrusted by an ecommerce firm with designing a reporting dashboard that visualizes crucial business KPIs derived from the company's primary production database running on Amazon Aurora. The dashboard should be able to read data within 100 milliseconds after an update.

    The Database Specialist must conduct an audit of the Aurora DB cluster's present setup and provide a cost-effective alternative. The solution must support the unexpected read demand generated by the reporting dashboard without impairing the DB cluster's write availability and performance.

    Which solution satisfies these criteria?

    A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
    B. Provision a clone of the existing DB cluster for the new Application team.
    C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
    D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

  • Question 100:

    A bike rental company operates an application to track its bikes. The application receives location and condition data from bike sensors. The application also receives rental transaction data from the associated mobile app.

    The application uses Amazon DynamoDB as its database layer. The company has configured DynamoDB with provisioned capacity set to 20% above the expected peak load of the application. On an average day, DynamoDB used 22 billion read capacity units (RCUs) and 60 billion write capacity units (WCUs). The application is running well. Usage changes smoothly over the course of the day and is generally shaped like a bell curve. The timing and magnitude of peaks vary based on the weather and season, but the general shape is consistent.

    Which solution will provide the MOST cost optimization of the DynamoDB database layer?

    A. Change the DynamoDB tables to use on-demand capacity.
    B. Use AWS Auto Scaling and configure time-based scaling.
    C. Enable DynamoDB capacity-based auto scaling.
    D. Enable DynamoDB Accelerator (DAX).

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.