Amazon DBS-C01 DBS-C01 AWS Certified Database – Specialty Exam

Earn an industry-recognized credential from AWS that validates your expertise in the breadth of AWS database services and accelerating the use of database technology to drive your organization’s business transformation. Build credibility and confidence by highlighting your ability to design, recommend, and maintain the optimal AWS database solution for a use case.

Abilities Validated by the Certification
Understand and differentiate the key features of AWS database services
Analyze needs and requirements to recommend and design appropriate database solutions using AWS services

Recommended Knowledge and Experience
At least 5 years of experience with database technologies
At least 2 years of hands-on experience working on AWS
Experience and expertise working with on-premises and AWS-Cloud-based relational and nonrelational databases

Prepare for Your Exam
There is no better preparation than hands-on experience. Review the exam guide for information about the competencies assessed on this certification exam. You can also review the sample questions for format examples or take a practice exam.

Looking for more resources to help build your database expertise? Explore options including an AWS Database Learning Path, exam readiness training, an in-depth AWS Database Ramp-Up Guide, suggested whitepapers and FAQs, and more.

Introduction
The AWS Certified Database – Specialty (DBS-C01) examination is intended for individuals who perform in a database-focused role. This exam validates an examinee’s comprehensive understanding of databases, including the concepts of design, migration, deployment, access, maintenance, automation, monitoring, security, and troubleshooting.

It validates an examinee’s ability to:
 Understand and differentiate the key features of AWS database services.
 Analyze needs and requirements to design and recommend appropriate database solutions using AWS services.

Recommended AWS Knowledge
 A minimum of 5 years of experience with common database technologies
 At least 2 years of hands-on experience working on AWS
 Experience and expertise working with on-premises and AWS Cloud-based relational and NoSQL databases

Exam Content

Response Types
There are two types of questions on the examination:
 Multiple choice: Has one correct response and three incorrect responses (distractors).
 Multiple response: Has two or more correct responses out of five or more options.

Select one or more responses that best complete the statement or answer the question. Distractors, or incorrect answers, are response options that an examinee with incomplete knowledge or skill would likely choose. However, they are generally plausible responses that fit in the content area defined by the test objective.
Unanswered questions are scored as incorrect; there is no penalty for guessing.

Unscored Content
Your examination may include unscored items that are placed on the test to gather statistical information. These items are not identified on the form and do not affect your score.

Exam Results
The AWS Certified Database – Specialty (DBS-C01) examination is a pass or fail exam. The examination is scored against a minimum standard established by AWS professionals who are guided by certification industry best practices and guidelines.

Your results for the examination are reported as a score from 100–1,000, with a minimum passing score of 750. Your score shows how you performed on the examination as a whole and whether or not you passed. Scaled scoring models are used to equate scores across multiple exam forms that may have slightly different difficulty levels.

Your score report contains a table of classifications of your performance at each section level. This information is designed to provide general feedback concerning your examination performance. The examination uses a compensatory scoring model, which means that you do not need to “pass” the individual sections, only the overall examination. Each section of the examination has a specific weighting, so some sections have more questions than

others. The table contains general information, highlighting your strengths and weaknesses. Exercise caution when interpreting section-level feedback.

Content Outline
This exam guide includes weightings, test domains, and objectives only. It is not a comprehensive listing of the content on this examination. The table below lists the main content domains and their weightings.

Domain 1: Workload-Specific Database Design 26%
Domain 2: Deployment and Migration 20%
Domain 3: Management and Operations 18%
Domain 4: Monitoring and Troubleshooting 18%
Domain 5: Database Security 18%

TOTAL 100%

Domain 1: Workload-Specific Database Design
1.1 Select appropriate database services for specific types of data and workloads
1.2 Determine strategies for disaster recovery and high availability
1.3 Design database solutions for performance, compliance, and scalability
1.4 Compare the costs of database solutions

Domain 2: Deployment and Migration
2.1 Automate database solution deployments
2.2 Determine data preparation and migration strategies
2.3 Execute and validate data migration

Domain 3: Management and Operations
3.1 Determine maintenance tasks and processes
3.2 Determine backup and restore strategies
3.3 Manage the operational environment of a database solution

Domain 4: Monitoring and Troubleshooting
4.1 Determine monitoring and alerting strategies
4.2 Troubleshoot and resolve common database issues
4.3 Optimize database performance

Domain 5: Database Security
5.1 Encrypt data at rest and in transit
5.2 Evaluate auditing solutions
5.3 Determine access control and authentication mechanisms
5.4 Recognize potential security vulnerabilities within database solutions

QUESTION 1
A company has deployed an e-commerce web application in a new AWS account. An Amazon RDS for
MySQL Multi-AZ DB instance is part of this deployment with a database-1.xxxxxxxxxxxx.us-east-
1.rds.amazonaws.com endpoint listening on port 3306. The company’s Database Specialist is able to log in to
MySQL and run queries from the bastion host using these details.
When users try to utilize the application hosted in the AWS account, they are presented with a generic error
message. The application servers are logging a “could not connect to server: Connection times out” error
message to Amazon CloudWatch Logs.
What is the cause of this error?

A. The user name and password the application is using are incorrect.
B. The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.
C. The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.
D. The user name and password are correct, but the user is not authorized to use the DB instance.

Correct Answer: C

QUESTION 2
An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and
recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to
reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

A. Set DeletionProtection to True
B. Set MultiAZ to True
C. Set TerminationProtection to True
D. Set DeleteAutomatedBackups to False
E. Set DeletionPolicy to Delete
F. Set DeletionPolicy to Retain

Correct Answer: ACF

QUESTION 3
A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster
with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection
failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS
events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?

A. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
B. The client-side application is caching the DNS data and its TTL is set too high
C. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
D. There were no active Aurora Replicas in the Aurora DB cluster

Correct Answer: C

QUESTION 4
A company is deploying a solution in Amazon Aurora by migrating from an on-premises system. The IT
department has established an AWS Direct Connect link from the company’s data center. The company’s
Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from
being set over the network. The migration appears to be working successfully, and the data can be queried from a desktop machine.
Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster. Both
Analysts are unable to connect to Aurora. Their user names and passwords have been verified as valid and
the Database Specialist can connect to the DB cluster using their accounts. The Database Specialist also
verified that the security group configuration allows network from all corporate IP addresses.
What should the Database Specialist do to correct the Data Analysts’ inability to connect?

A. Restart the DB cluster to apply the SSL change.
B. Instruct the Data Analysts to download the root certificate and use the SSL certificate on the connection string to connect.
C. Add explicit mappings between the Data Analysts’ IP addresses and the instance in the security group assigned to the DB cluster.
D. Modify the Data Analysts’ local client firewall to allow network traffic to AWS.

Correct Answer: D


 

Certkingdom Review, Certkingdom Amazon DBS-C01 AWS Certified Database PDF

Best Amazon DBS-C01 AWS Certified Database Certification, Amazon DBS-C01 AWS Certified Database Training at certkingdom.com