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

    An internet advertising firm stores its data in an Amazon DynamoDb table. Amazon DynamoDB Streams are enabled on the table, and one of the keys has a global secondary index. The table is encrypted using a customer-managed AWS

    Key Management Service (AWS KMS) key.

    The firm has chosen to grow worldwide and want to duplicate the database using DynamoDB global tables in a new AWS Region.

    An administrator observes the following upon review:

    No role with the dynamodb: CreateGlobalTable permission exists in the account. An empty table with the same name exists in the new Region where replication is desired.

    A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.

    Which settings will prevent you from creating a global table or replica in the new Region? (Select two.)

    A. A global secondary index with the same partition key but a different sort key exists in the new Region where replication is desired.
    B. An empty table with the same name exists in the Region where replication is desired.
    C. No role with the dynamodb:CreateGlobalTable permission exists in the account.
    D. DynamoDB Streams is enabled for the table.
    E. The table is encrypted using a KMS customer managed key.

  • Question 192:

    A healthcare company is running an application on Amazon EC2 in a public subnet and using Amazon DocumentDB (with MongoDB compatibility) as the storage layer. An audit reveals that the traffic between the application and Amazon DocumentDB is not encrypted and that the DocumentDB cluster is not encrypted at rest. A database specialist must correct these issues and ensure that the data in transit and the data at rest are encrypted.

    Which actions should the database specialist take to meet these requirements? (Select TWO.)

    A. Download the SSH RSA public key for Amazon DocumentDB. Update the application configuration to use the instance endpoint instead of the cluster endpoint and run queries over SSH.
    B. Download the SSL .pem public key for Amazon DocumentDB. Add the key to the application package and make sure the application is using the key while connecting to the cluster.
    C. Create a snapshot of the unencrypted cluster. Restore the unencrypted snapshot as a new cluster with the --storage-encrypted parameter set to true. Update the application to point to the new cluster.
    D. Create an Amazon DocumentDB VPC endpoint to prevent the traffic from going to the Amazon DocumentDB public endpoint. Set a VPC endpoint policy to allow only the application instance's security group to connect.
    E. Activate encryption at rest using the modify-db-cluster command with the --storage- encrypted parameter set to true. Set the security group of the cluster to allow only the application instance's security group to connect.

  • Question 193:

    A pharmaceutical company's drug search API is using an Amazon Neptune DB cluster. A bulk uploader process automatically updates the information in the database a few times each week. A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with a ThrottlingException error. The problem also occurred with subsequent uploads.

    The database specialist must create a solution to prevent ThrottlingException errors for the database. The solution must minimize the downtime of the cluster.

    Which solution meets these requirements?

    A. Create a read replica that uses a larger instance size than the primary DB instance. Fail over the primary DB instance to the read replica.
    B. Add a read replica to each Availability Zone. Use an instance for the read replica that is the same size as the primary DB instance. Keep the traffic between the API and the database within the Availability Zone.
    C. Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance.
    D. Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster.

  • Question 194:

    A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process.

    Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade.

    What should a database specialist do to prevent data loss during the stack upgrade?

    A. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack.
    B. Modify the stack policy using the aws cloudformation update-stack command and the set-stack-policy command, then make the DB resource protected.
    C. Create a snapshot of the DB instance. Update the stack. Restore the database to a new instance.
    D. Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications.

  • Question 195:

    A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS. A deep review is performed and the AWS Schema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL Server Standard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL. The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.

    What is the MOST cost-effective and operationally efficient solution?

    A. Run SQL Server Enterprise Edition on Amazon EC2.
    B. Run SQL Server Standard Edition on Amazon RDS.
    C. Run SQL Server Enterprise Edition on Amazon RDS.
    D. Run Amazon Aurora MySQL leveraging SQL Server on Linux compatibility libraries.

  • Question 196:

    A company needs to migrate Oracle Database Standard Edition running on an Amazon EC2 instance to an Amazon RDS for Oracle DB instance with Multi-AZ. The database supports an ecommerce website that runs continuously. The company can only provide a maintenance window of up to 5 minutes.

    Which solution will meet these requirements?

    A. Configure Oracle Real Application Clusters (RAC) on the EC2 instance and the RDS DB instance. Update the connection string to point to the RAC cluster. Once the EC2 instance and RDS DB instance are in sync, fail over from Amazon EC2 to Amazon RDS.
    B. Export the Oracle database from the EC2 instance using Oracle Data Pump and perform an import into Amazon RDS. Stop the application for the entire process. When the import is complete, change the database connection string and then restart the application.
    C. Configure AWS DMS with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.
    D. Configure AWS DataSync with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application when the replication is in sync, change the database connection string, and then restart the application.

  • Question 197:

    A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormatlon. The company's database administrator has received reports of performance Issues from the resulting database but has no way to investigate the issues.

    Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Select TWO.)

    A. Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormat10n template.
    B. Turn on AWS CloudTraiI in each AWS account_
    C. Turn on and contigure AWS Config tor all Aurora PostgreSQL databases.
    D. Update the CloudFormatlon template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.
    E. Update the CloudFormatlon template to turn on Performance Insights for Aurora PostgreSQL.

  • Question 198:

    A company conducted a security audit of its AWS infrastructure. The audit identified that data was not encrypted in transit between application servers and a MySQL database that is hosted in Amazon RDS.

    After the audit, the company updated the application to use an encrypted connection. To prevent this problem from occurring again, the company's database team needs to configure the database to require in-transit encryption for all connections.

    Which solution will meet this requirement?

    A. Update the parameter group in use by the DB instance, and set the require_secure_transport parameter to ON.
    B. Connect to the database, and use ALTER USER to enable the REQUIRE SSL option on the database user.
    C. Update the security group in use by the DB instance, and remove port 80 to prevent unencrypted connections from being established.
    D. Update the DB instance, and enable the Require Transport Layer Security option.

  • Question 199:

    After restoring an Amazon RDS snapshot from 3 days ago, a company's Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?

    A. The restored DB instance does not have Enhanced Monitoring enabled
    B. The production DB instance is using a custom parameter group
    C. The restored DB instance is using the default security group
    D. The production DB instance is using a custom option group

  • Question 200:

    A company has an application that uses an Amazon DynamoDB table to store user data. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time.

    A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table's provisioned read capacity units (RCUs) are being used.

    What should the database specialist do?

    A. Enable auto scaling for the DynamoDB table.
    B. Use four threads and parallel DynamoDB API Scan operations.
    C. Double the table's provisioned RCUs.
    D. Set the Limit and Offset parameters before every call to the API.

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.