Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Amazon
  3. DBS-C01

Amazon DBS-C01 Exam (page: 4)
Amazon AWS Certified Database - Specialty
Updated on: 07-Feb-2026

Viewing Page 4 of 42
DBS-C01 PDF 359 Questions

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.
Which approach should the Database Specialist take to reduce downtime?

  1. Deploy multiple read replicas and have the team members make changes to separate replica instances
  2. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
  3. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
  4. Enable the Amazon RDS for MySQL Backtrack feature

Answer(s): C



A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements:

-Only certain on-premises corporate network IPs should connect to the DB instance.
-Connectivity is allowed from the corporate network only.

Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)

  1. Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
  2. Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
  3. Move the DB instance to a private subnet using AWS DMS.
  4. Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
  5. Disable the publicly accessible setting.
  6. Connect to the DB instance using private IPs and a VPN.

Answer(s): B,E,F



A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.

What should the Database Specialist do to meet these requirements?

  1. Restore a snapshot from the production cluster into test clusters
  2. Create logical dumps of the production cluster and restore them into new test clusters
  3. Use database cloning to create clones of the production cluster
  4. Add an additional read replica to the production cluster and use that node for testing

Answer(s): C



A company with branch offices in Portland, New York, and Singapore has a three-tier web application that leverages a shared database. The database runs on Amazon RDS for MySQL and is hosted in the us-west-2 Region. The application has a distributed front end deployed in the us-west-2, ap-southheast-1, and us-east-2 Regions.

This front end is used as a dashboard for Sales Managers in each branch office to see current sales statistics. There are complaints that the dashboard performs more slowly in the Singapore location than it does in Portland or New York. A solution is needed to provide consistent performance for all users in each location.

Which set of actions will meet these requirements?

  1. Take a snapshot of the instance in the us-west-2 Region. Create a new instance from the snapshot in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  2. Create an RDS read replica in the ap-southeast-1 Region from the primary RDS DB instance in the us- west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  3. Create a new RDS instance in the ap-southeast-1 Region. Use AWS DMS and change data capture (CDC) to update the new instance in the ap-southeast-1 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.
  4. Create an RDS read replica in the us-west-2 Region where the primary instance resides. Create a read replica in the ap-southeast-1 Region from the read replica located on the us-west-2 Region. Reconfigure the ap-southeast-1 front-end dashboard to access this instance.

Answer(s): B



A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime using AWS DMS. A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover. The migration must have minimal impact on the performance of the source database.
Which approach will MOST effectively meet these requirements?

  1. Use the AWS Schema Conversion Tool (AWS SCT) to convert source Oracle database schemas to the target Aurora DB cluster. Verify the datatype of the columns.
  2. Use the table metrics of the AWS DMS task created for migrating the data to verify the statistics for the tables being migrated and to verify that the data definition language (DDL) statements are completed.
  3. Enable the AWS Schema Conversion Tool (AWS SCT) premigration validation and review the premigration checklist to make sure there are no issues with the conversion.
  4. Enable AWS DMS data validation on the task so the AWS DMS task compares the source and target records, and reports any mismatches.

Answer(s): D

Explanation:


Reference:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html



A company is planning to close for several days. A Database Specialist needs to stop all applications along with the DB instances to ensure employees do not have access to the systems during this time. All databases are running on Amazon RDS for MySQL.

The Database Specialist wrote and executed a script to stop all the DB instances.
When reviewing the logs, the Database Specialist found that Amazon RDS DB instances with read replicas did not stop.

How should the Database Specialist edit the script to fix this issue?

  1. Stop the source instances before stopping their read replicas
  2. Delete each read replica before stopping its corresponding source instance
  3. Stop the read replicas before stopping their source instances
  4. Use the AWS CLI to stop each read replica and source instance at the same time

Answer(s): B



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?

  1. Amazon DocumentDB
  2. Amazon RDS Multi-AZ deployment
  3. Amazon DynamoDB global table
  4. Amazon Aurora Global Database

Answer(s): C

Explanation:


Reference:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GlobalTables.html



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?

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

Answer(s): C

Explanation:


Reference:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html



Viewing Page 4 of 42



Share your comments for Amazon DBS-C01 exam with other users:

Mungara 3/14/2023 12:10:00 AM

thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES