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

    A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.

    How should the Database Specialist apply the parameter group change for the DB instance?

    A. Select the option to apply the change immediately
    B. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
    C. Apply the change manually by rebooting the DB instance during the approved maintenance window
    D. Reboot the secondary Multi-AZ DB instance

  • Question 152:

    A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL-based connections should be disallowed access to the database.

    Which solution addresses these requirements?

    A. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.
    B. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.
    C. Set the rds.force_ssl=0 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.
    D. Set the rds.force_ssl=1 parameter in DB parameter groups. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.

  • Question 153:

    A coffee machine manufacturer is equipping all of its coffee machines with 10T sensors. The 10T core application is writing measurements for each record to Amazon Timestream. The records have multiple dimensions and measures. The measures include multiple measure names and values.

    An analysis application is running queries against the Timestream database and is focusing on data from the current week. A database specialist needs to optimize the query costs of the analysis application.

    Which solution will meet these requirements?

    A. Ensure that queries contain whole records over the relevant time range.
    B. Use time range, measure name, and dimensions in the WHERE clause of the query.
    C. Avoid canceling any query after the query starts running.
    D. Implement exponential backoff in the application.

  • Question 154:

    A software company is conducting a security audit of its three-node Amazon Aurora MySQL DB cluster. Which finding is a security concern that needs to be addressed?

    A. The AWS account root user does not have the minimum privileges required for client applications.
    B. Encryption in transit is not configured for all Aurora native backup processes.
    C. Each Aurora DB cluster node is not in a separate private VPC with restricted access.
    D. The IAM credentials used by the application are not rotated regularly.

  • Question 155:

    A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance.

    Which strategy would allow for a successful migration with the LEAST amount of downtime?

    A. Deploy a new RDS for MySQL DB instance and configure it for access from the on- premises data center. Use the mysqldump utility to create an initial snapshot from the on- premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instance. Immediately point the application to the DB instance.
    B. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instance. Use AWS DMS to migrate data into a new RDS for MySQL DB instance. Point the application to the DB instance.
    C. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data center. Use the mysqldump utility to create a snapshot of the on-premises MySQL server. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instance. Point the application to the DB instance.
    D. Deploy a new RDS for MySQL DB instance and configure it for access from the on- premises data center. Use the mysqldump utility to create an initial snapshot from the on- premises MySQL server, and copy it to an Amazon S3 bucket. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instance. Establish replication into the new DB instance using MySQL replication. Stop application access to the on-premises MySQL server and let the remaining transactions replicate over. Point the application to the DB instance.

  • Question 156:

    A company with 500,000 employees needs to supply its employee list to an application used by human resources. Every 30 minutes, the data is exported using the LDAP service to load into a new Amazon DynamoDB table. The data model has a base table with Employee ID for the partition key and a global secondary index with Organization ID as the partition key.

    While importing the data, a database specialist receives ProvisionedThroughputExceededException errors. After increasing the provisioned write capacity units (WCUs) to 50,000, the specialist receives the same errors. Amazon CloudWatch metrics show a consumption of 1,500 WCUs.

    What should the database specialist do to address the issue?

    A. Change the data model to avoid hot partitions in the global secondary index.
    B. Enable auto scaling for the table to automatically increase write capacity during bulk imports.
    C. Modify the table to use on-demand capacity instead of provisioned capacity.
    D. Increase the number of retries on the bulk loading application.

  • Question 157:

    A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics. The company wants to migrate the database to the AWS Cloud. Database specialist must choose one or more AWS services to run the company's workloads.

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

    A. Use Amazon Redshift for relational data. Use Amazon DynamoDB for JSON data
    B. Use Amazon Redshift for relational data and JSON data.
    C. Use Amazon RDS for relational data. Use Amazon Neptune for JSON data
    D. Use Amazon Redshift for relational data. Use Amazon S3 for JSON data.

  • Question 158:

    A huge gaming firm is developing a centralized method for storing the status of various online games' user sessions. The workload requires low-latency key-value storage and will consist of an equal number of reads and writes. Across the games' geographically dispersed user base, data should be written to the AWS Region nearest to the user. The design should reduce the burden associated with managing data replication across Regions.

    Which solution satisfies these criteria?

    A. Amazon RDS for MySQL with multi-Region read replicas
    B. Amazon Aurora global database
    C. Amazon RDS for Oracle with GoldenGate
    D. Amazon DynamoDB global tables

  • Question 159:

    A business maintains a SQL Server database on-premises. Active Directory authentication is used to provide users access to the database. The organization transferred their database successfully to Amazon RDS for SQL Server. The organization, however, has reservations regarding user authentication in the AWS Cloud environment.

    Which authentication solution should a database professional provide?

    A. Deploy Active Directory Federation Services (AD FS) on premises and configure it with an on-premises Active Directory. Set up delegation between the on- premises AD FS and AWS Security Token Service (AWS STS) to map user identities to a role using theAmazonRDSDirectoryServiceAccess managed IAM policy.
    B. Establish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Directory. Use AWS SSO to configure an Active Directory user delegated to access the databases in RDS for SQL Server.
    C. Use Active Directory Connector to redirect directory requests to the companyTMs on- premises Active Directory without caching any information in the cloud. Use the RDS master user credentials to connect to the DB instance and configure SQL Server logins and users from the Active Directory users and groups.
    D. Establish a forest trust between the on-premises Active Directory and AWS Directory Service for Microsoft Active Directory. Ensure RDS for SQL Server is using mixed mode authentication. Use the RDS master user credentials to connect to the DB instance and configure SQL Server logins and users from the Active Directory users and groups.

  • Question 160:

    A large IT hardware manufacturing company wants to deploy a MySQL database solution in the AWS Cloud. The solution should quickly create copies of the company's production databases for test purposes. The solution must deploy the test databases in minutes, and the test data should match the latest production data as closely as possible. Developers must also be able to make changes in the test database and delete the instances afterward.

    Which solution meets these requirements?

    A. Leverage Amazon RDS for MySQL with write-enabled replicas running on Amazon EC2. Create the test copies using a mysqidump backup from the RDS for MySQL DB instances and importing them into the new EC2 instances.
    B. Leverage Amazon Aurora MySQL. Use database cloning to create multiple test copies of the production DB clusters.
    C. Leverage Amazon Aurora MySQL. Restore previous production DB instance snapshots into new test copies of Aurora MySQL DB clusters to allow them to make changes.
    D. Leverage Amazon RDS for MySQL. Use database cloning to create multiple developer copies of the production DB instance.

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.