A Company Has a Database Monitoring Solution That Uses Amazon

question 94

Multiple Choice

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.)

• A) Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.
• B) Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
• C) Implement a caching layer to help with repeated queries on the RDS SQL Server DB instance.
• D) Use Amazon QuickSight to view the SQL statement being run.
• E) Enable Amazon RDS Performance Insights to view the database load and filter the load by waits, SQL statements, hosts, or users.

---

Definitions:

Weighted Average

A calculation that considers the varying weights of different items in a dataset, providing a measure that reflects their relative importance.

Free Cash Flow

The cash that a company generates after accounting for cash outflows to support operations and maintain its capital assets.

Expansionary Gaps

Situations where actual GDP exceeds potential GDP, leading to inflationary pressure due to high demand.

Contractionary Gaps

Contractionary gaps occur when an economy’s actual output is lower than its potential output, often leading to unemployment and underutilized resources.