Amazon Exam DBS-C01 Topic 6 Question 71 Discussion

Actual exam question for Amazon's DBS-C01 exam

Question #: 71
Topic #: 6

A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL Server environment. The cause of a recent spike in CPU utilization was not determined using the standard metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A Database Specialist needs to determine what caused the CPU spike.

Which combination of steps should be taken to provide more visibility into the processes and queries running during an increase in CPU load? (Choose two.)

AEnable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.

BEnable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.

CImplement a caching layer to help with repeated queries on the RDS SQL Server DB instance.

DUse Amazon QuickSight to view the SQL statement being run.

EEnable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.

Show Suggested Answer

Suggested Answer: C

by Reita at Feb 24, 2023, 05:41 AM

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!