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
    :Apr 22, 2025

Amazon Amazon Certifications DBS-C01 Questions & Answers

  • Question 71:

    A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours. Which solution will meet these requirements and is the MOST operationally efficient?

    A. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot. Move the snapshot to the company's Amazon S3 bucket.

    B. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.

    C. Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.

    D. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

  • Question 72:

    A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB. To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts. The company expects more than 10,000 users.

    How should a database specialist implement access control with the LEAST operational effort?

    A. Use web identity federation on the mobile app and AWS STS with an attached IAM role to get temporary credentials to access DynamoDB.

    B. Use web identity federation on the mobile app and create individual IAM users with credentials to access DynamoDB.

    C. Use a self-developed user management system on the mobile app that lets users access the data from DynamoDB through an API.

    D. Use a single IAM user on the mobile app to access DynamoDB.

  • Question 73:

    A company's development team needs to have production data restored in a staging AWS account. The production database is running on an Amazon RDS for PostgreSQL Multi-AZ DB instance, which has AWS KMS encryption enabled using the default KMS key. A database specialist planned to share the most recent automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in the AWS Management Console.

    What should the database specialist do to resolve this?

    A. Disable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.

    B. Copy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.

    C. Modify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account.

    D. Copy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.

  • Question 74:

    A global digital advertising company captures browsing metadata to contextually display relevant images, pages, and links to targeted users. A single page load can generate multiple events that need to be stored individually. The maximum size of an event is 200 KB and the average size is 10 KB. Each page load must query the user's browsing history to provide targeting recommendations. The advertising company expects over 1 billion page visits per day from users in the United States, Europe, Hong Kong, and India. The structure of the metadata varies depending on the event. Additionally, the browsing metadata must be written and read with very low latency to ensure a good viewing experience for the users.

    Which database solution meets these requirements?

    A. Amazon DocumentDB

    B. Amazon RDS Multi-AZ deployment

    C. Amazon DynamoDB global table

    D. Amazon Aurora Global Database

  • Question 75:

    A company has a database fleet that includes an Amazon RDS for MySQL DB instance. During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.

    A database specialist must enable encryption for the DB instance. The database specialist also must encrypt all connections to the DB instance.

    Which combination of actions should the database specialist take to meet these requirements? (Choose three.)

    A. In the RDS console, choose Enable encryption to encrypt the DB instance by using an AWS Key Management Service (AWS KMS) key.

    B. Encrypt the read replica of the unencrypted DB instance by using an AWS Key Management Service (AWS KMS) key. Fail over the read replica to the primary DB instance.

    C. Create a snapshot of the unencrypted DB instance. Encrypt the snapshot by using an AWS Key Management Service (AWS KMS) key. Restore the DB instance from the encrypted snapshot. Delete the original DB instance.

    D. Require SSL connections for applicable database user accounts.

    E. Use SSL/TLS from the application to encrypt a connection to the DB instance.

    F. Enable SSH encryption on the DB instance.

  • Question 76:

    A company has an AWS CloudFormation template written in JSON that is used to launch new Amazon RDS for MySQL DB instances. The security team has asked a database specialist to ensure that the master password is automatically rotated every 30 days for all new DB instances that are launched using the template.

    What is the MOST operationally efficient solution to meet these requirements?

    A. Save the password in an Amazon S3 object. Encrypt the S3 object with an AWS KMS key. Set the KMS key to be rotated every 30 days by setting the EnableKeyRotation property to true. Use a CloudFormation custom resource to read the S3 object to extract the password.

    B. Create an AWS Lambda function to rotate the secret. Modify the CloudFormation template to add an AWS::SecretsManager::RotationSchedule resource. Configure the RotationLambdaARN value and, for the RotationRules property, set the AutomaticallyAfterDays parameter to 30.

    C. Modify the CloudFormation template to use the AWS KMS key as the database password. Configure an Amazon EventBridge rule to invoke the KMS API to rotate the key every 30 days by setting the ScheduleExpression parameter to ***/30***.

    D. Integrate the Amazon RDS for MySQL DB instances with AWS IAM and centrally manage the master database user password.

  • Question 77:

    A company has an application that uses an Amazon DynamoDB table as its data store. During normal business days, the throughput requirements from the application are uniform and consist of 5 standard write calls per second to the DynamoDB table. Each write call has 2 KB of data.

    For 1 hour each day, the company runs an additional automated job on the DynamoDB table that makes 20 write requests per second. No other application writes to the DynamoDB table. The DynamoDB table does not have to meet any additional capacity requirements.

    How should a database specialist configure the DynamoDB table's capacity to meet these requirements MOST cost-effectively?

    A. Use DynamoDB provisioned capacity with 5 WCUs and auto scaling.

    B. Use DynamoDB provisioned capacity with 5 WCUs and a write-through cache that DynamoDB Accelerator (DAX) provides.

    C. Use DynamoDB provisioned capacity with 10 WCUs and auto scaling.

    D. Use DynamoDB provisioned capacity with 10 WCUs and no auto scaling.

  • Question 78:

    A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is governed by multiple financial regulatory agencies. The RDS DB instance is set up with security groups to allow access to certain

    Amazon EC2 servers only.

    AWS KMS is used for encryption at rest.

    Which step will provide additional security?

    A. Set up NACLs that allow the entire EC2 subnet to access the DB instance

    B. Disable the master user account

    C. Set up a security group that blocks SSH to the DB instance

    D. Set up RDS to use SSL for data in transit

  • Question 79:

    A company's application development team wants to share an automated snapshot of its Amazon RDS database with another team. The database is encrypted with a custom AWS Key Management Service (AWS KMS) key under the "WeShare" AWS account. The application development team needs to share the DB snapshot under the "WeReceive" AWS account.

    Which combination of actions must the application development team take to meet these requirements? (Choose two.)

    A. Add access from the "WeReceive" account to the custom AWS KMS key policy of the sharing team.

    B. Make a copy of the DB snapshot, and set the encryption option to disable.

    C. Share the DB snapshot by setting the DB snapshot visibility option to public.

    D. Make a copy of the DB snapshot, and set the encryption option to enable.

    E. Share the DB snapshot by using the default AWS KMS encryption key.

  • Question 80:

    A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups.

    Which solution will meet this requirement with the LEAST operational overhead?

    A. Configure an RDS event notification subscription for DB security group events.

    B. Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification.

    C. Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups.

    D. Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups.

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.