Amazon Web Services certkiller aws Certified Database Dbs-c01 Syllabus Exam Questions Answers by Boden q27 vce pdf

Page: 7 / 23

Exam Name:	AWS Certified Database - Specialty
Exam Code:	DBS-C01 Dumps
Vendor:	Amazon Web Services	Certification:	AWS Certified Database
Questions:	324 Q&A's	Shared By:	boden

Question 28

On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.

Which solution satisfies these criteria?

Options:

Amazon DynamoDB global tables

Amazon DynamoDB streams with AWS Lambda to replicate the data

An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards

An Amazon Aurora global database

Discussion

Mylo

Excellent dumps with authentic information… I passed my exam with brilliant score.

Dominik Aug 29, 2024

That's amazing! I've been looking for good study material that will help me prepare for my upcoming certification exam. Now, I will try it.

Honey

I highly recommend it. They made a big difference for me and I'm sure they'll help you too. Just make sure to use them wisely and not solely rely on them. They should be used as a supplement to your regular studies.

Antoni Oct 25, 2024

Good point. Thanks for the advice. I'll definitely keep that in mind.

Marley

Hey, I heard the good news. I passed the certification exam!

Jaxson Oct 5, 2024

Yes, I passed too! And I have to say, I couldn't have done it without Cramkey Dumps.

Joey

I highly recommend Cramkey Dumps to anyone preparing for the certification exam. They have all the key information you need and the questions are very similar to what you'll see on the actual exam.

Dexter Aug 7, 2024

Agreed. It's definitely worth checking out if you're looking for a comprehensive and reliable study resource.

Question 29

A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and OLAP reports for the human resources department. To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.

Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

Options:

Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.

Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.

Create additional readers to cater to the different scenarios.

Use custom endpoints to satisfy the different workloads.

Discussion

Question 30

A company has an application environment that deploys Amazon Aurora PostgreSQL databases as part of its CI/CD process that uses AWS CloudFormatlon. The company's database administrator has received reports of performance Issues from the resulting database but has no way to investigate the issues.

Which combination of changes must the database administrator make to the database deployment to automate the collection of performance data? (Select TWO.)

Options:

Turn on Amazon DevOps Guru for the Aurora database resources in the CloudFormat10n template.

Turn on AWS CloudTraiI in each AWS account_

Turn on and contigure AWS Config tor all Aurora PostgreSQL databases.

Update the CloudFormatlon template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances.

Update the CloudFormatlon template to turn on Performance Insights for Aurora PostgreSQL.

Discussion

Answer:

D, E

Explanation:

Explanation:

The combination of changes that the database administrator must make to the database deployment to automate the collection of performance data are:

Update the CloudFormation template to enable Amazon CloudWatch monitoring on the Aurora PostgreSQL DB instances. This will allow the database administrator to monitor the CPU utilization, memory usage, disk I/O, network throughput, and other metrics of the DB instances. CloudWatch monitoring is enabled by default for Aurora DB instances, but it can also be specified in the CloudFormation template using the MonitoringInterval property of the AWS::RDS::DBInstance resource1.
Update the CloudFormation template to turn on Performance Insights for Aurora PostgreSQL. This will allow the database administrator to analyze the database load and identify the most resource-intensive SQL queries, hosts, or users. Performance Insights is a feature of Amazon RDS that provides an easy-to-use dashboard to visualize and troubleshoot database performance. Performance Insights can be enabled in the CloudFormation template using the PerformanceInsightsEnabled property of the AWS::RDS::DBInstance resource2.

The other options are not relevant or sufficient for the requirement of automating the collection of performance data for the Aurora PostgreSQL databases. For example:

Turning on Amazon DevOps Guru for the Aurora database resources in the CloudFormation template is not necessary, as DevOps Guru is a service that uses machine learning to identify operational issues and risks across applications and infrastructure. DevOps Guru does not provide detailed performance data or analysis for Aurora PostgreSQL databases3.
Turning on AWS CloudTrail in each AWS account is not sufficient, as CloudTrail is a service that records API calls and events for AWS services. CloudTrail does not provide performance data or analysis for Aurora PostgreSQL databases, although it can help with auditing and compliance4.
Turning on and configuring AWS Config for all Aurora PostgreSQL databases is not relevant, as AWS Config is a service that tracks and evaluates the configuration changes of AWS resources. AWS Config does not provide performance data or analysis for Aurora PostgreSQL databases, although it can help with governance and security5.

Question 31

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?

Options:

The user name and password the application is using are incorrect.

The security group assigned to the application servers does not have the necessary rules to allow inbound connections from the DB instance.

The security group assigned to the DB instance does not have the necessary rules to allow inbound connections from the application servers.

The user name and password are correct, but the user is not authorized to use the DB instance.