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

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.

Discussion

Aryan

Absolutely rocked! They are an excellent investment for anyone who wants to pass the exam on the first try. They save you time and effort by providing a comprehensive overview of the exam content, and they give you a competitive edge by giving you access to the latest information. So, I definitely recommend them to new students.

Jessie (not set)

did you use PDF or Engine? Which one is most useful?

Esmae

I highly recommend Cramkey Dumps to anyone preparing for the certification exam.

Mollie (not set)

Absolutely. They really make it easier to study and retain all the important information. I'm so glad I found Cramkey Dumps.

Teddie

yes, I passed my exam with wonderful score, Accurate and valid dumps.

Isla-Rose (not set)

Absolutely! The questions in the dumps were almost identical to the ones that appeared in the actual exam. I was able to answer almost all of them correctly.

Carson

Yeah, definitely. I would definitely recommend Cramkey Dumps to anyone who is preparing for an exam.

Rufus (not set)

Me too. They're a lifesaver!

Cecilia

Yes, I passed my certification exam using Cramkey Dumps.

Helena (not set)

Great. Yes they are really effective

Page: 7 / 23

Title

Questions

Posted