← Back to exam page

DBS-C01 – AWS Certified Database - Specialty

Loading demo links...

Showing 7–9 of 15 questions

Question 7

A development team asks a database specialist to create a copy of a production Amazon RDS for MySQL DB instance every morning. The development team will use the copied DB instance as a testing environment for development. The original DB instance and the copy will be hosted in different VPCs of the same AWS account. The development team wants the copy to be available by 6 AM each day and wants to use the same endpoint address each day.

Which combination of steps should the database specialist take to meet these requirements MOST cost-effectively? (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Create a snapshot of the production database each day before the 6 AM deadline.
  • ○

    Create an RDS for MySQL DB instance from the snapshot. Select the desired DB instance size.
  • ○

    Update a defined Amazon Route 53 CNAME record to point to the copied DB instance.
  • ○

    Set up an AWS Database Migration Service (AWS DMS) migration task to copy the snapshot to the copied DB instance.
  • ○

    Use the CopySnapshot action on the production DB instance to create a snapshot before 6 AM.
  • ○

    Update a defined Amazon Route 53 alias record to point to the copied DB instance.
Question 8

A company uses the Amazon DynamoDB table contractDB in us-east-1 for its contract system with the following schema:

orderID (primary key) timestamp (sort key) contract (map) createdBy (string) customerEmail (string)

After a problem in production, the operations team has asked a database specialist to provide an IAM policy to read items from the database to debug the application. In addition, the developer is not allowed to access the value of the customerEmail field to stay compliant.

Which IAM policy should the database specialist use to achieve these requirements?

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D

Question 9

A database specialist manages a critical Amazon RDS for MySQL DB instance for a company. The data stored daily could vary from .01% to 10% of the current database size. The database specialist needs to ensure that the DB instance storage grows as needed.

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

Select an option, then click Submit answer.

  • ○

    Configure RDS Storage Auto Scaling.
  • ○

    Configure RDS instance Auto Scaling.
  • ○

    Modify the DB instance allocated storage to meet the forecasted requirements.
  • ○

    Monitor the Amazon CloudWatch FreeStorageSpace metric daily and add storage as required.