DBS-C01 Exam Questions & Answers

Exam Code: DBS-C01

Exam Name: AWS Certified Database - Specialty (DBS-C01)

Updated: Mar 20, 2024

Q&As: 321

At Passcerty.com, we pride ourselves on the comprehensive nature of our DBS-C01 exam dumps, designed meticulously to encompass all key topics and nuances you might encounter during the real examination. Regular updates are a cornerstone of our service, ensuring that our dedicated users always have their hands on the most recent and relevant Q&A dumps. Behind every meticulously curated question and answer lies the hard work of our seasoned team of experts, who bring years of experience and knowledge into crafting these premium materials. And while we are invested in offering top-notch content, we also believe in empowering our community. As a token of our commitment to your success, we're delighted to offer a substantial portion of our resources for free practice. We invite you to make the most of the following content, and wish you every success in your endeavors.


Download Free Amazon DBS-C01 Demo

Experience Passcerty.com exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your Amazon DBS-C01 exam.

Instant download
Latest update demo according to real exam

*Email Address

* Our demo shows only a few questions from your selected exam for evaluating purposes

Free Amazon DBS-C01 Dumps

Practice These Free Questions and Answers to Pass the AWS Certified Specialty Exam

Questions 1

Amazon Aurora MySQL is being used by an ecommerce business to migrate its main application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing.

Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%.

Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select two.)

A. Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.

B. Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.

C. Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.

D. Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.

E. Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.

Show Answer
Questions 2

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.

What is the MOST cost-effective action that should be taken to avoid downtime?

A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB

B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down

C. Enable a read replicas and direct read traffic to it when Amazon RDS is down

D. Enable an Amazon RDS for MySQL Multi-AZ configuration

Show Answer
Questions 3

A database specialist must create nightly backups of an Amazon DynamoDB table in a mission-critical workload as part of a disaster recovery strategy.

Which backup methodology should the database specialist use to MINIMIZE management overhead?

A. Install the AWS CLI on an Amazon EC2 instance. Write a CLI command that creates a backup of the DynamoDB table. Create a scheduled job or task that executes the command on a nightly basis.

B. Create an AWS Lambda function that creates a backup of the DynamoDB table. Create an Amazon CloudWatch Events rule that executes the Lambda function on a nightly basis.

C. Create a backup plan using AWS Backup, specify a backup frequency of every 24 hours, and give the plan a nightly backup window.

D. Configure DynamoDB backup and restore for an on-demand backup frequency of every 24 hours.

Show Answer
Questions 4

An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company's Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.

What should the database specialist do to achieve this? (Choose two.)

A. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.

B. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.

C. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.

D. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.

E. Enable email notifications for AWS Trusted Advisor.

Show Answer
Questions 5

A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.

What should the company do to achieve this in the shortest amount of time?

A. Use a blue-green deployment with a complete application-level failover test

B. Use the RDS console to reboot the DB instance by choosing the option to reboot with failover

C. Use RDS fault injection queries to simulate the primary node failure

D. Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone

Show Answer

Viewing Page 1 of 3 pages. Download PDF or Software version with 321 questions