CLOUD-DEPLOYMENT-AND-OPERATIONS practice question 12 of 15
(Which Performance Insights view provides information on the hardware resource that may be causing a bottleneck?)
Full set: 67 questionsThe AWS Performance Insights "Wait event" view is the primary tool for identifying resource bottlenecks. This view breaks down the database load by what the database engine is waiting for. If the top wait events are CPU, it indicates a CPU bottleneck. Similarly, if wait events like io/file/read or io/file/write are dominant, it points to a storage (I/O) bottleneck. By analyzing the types of waits consuming the most time, an administrator can directly identify which specific hardware resource is constrained and causing the performance issue.
B. Users: This view shows which database user accounts are generating load, not which hardware resource is the bottleneck.
C. Hosts: This view identifies which client hosts are connected and generating load, not the constrained hardware resource on the database server.
D. Statement: This view pinpoints the specific SQL queries causing high load but does not directly identify the underlying hardware resource bottleneck.
1. Amazon RDS User Guide, "Wait events" section: "When you tune a database, you often try to find out what resources the engine is waiting for. For example, sessions might be waiting for buffers in memory to be freed, data files to be read, or logs to be written. These resources are called wait events." This directly links wait events to resource contention.
Source: AWS Documentation, Amazon RDS User Guide, Section: "Wait events". Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USERPerfInsights.Concepts.html#USERPerfInsights.Concepts.Waits
2. Amazon RDS User Guide, "Database load" section: The documentation explains that the database load (DB load) chart can be sliced by dimensions, with "Waits" being a key dimension. "The Waits dimension groups the DB load by wait event. This view shows you which wait events are contributing the most to DB load." This confirms that analyzing waits is the intended method for understanding the cause of load.
Source: AWS Documentation, Amazon RDS User Guide, Section: "Database load". Retrieved from https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USERPerfInsights.TheDashboard.html#USERPerfInsights.TheDashboard.DBLoad
Keep practicing
Take the free CLOUD-DEPLOYMENT-AND-OPERATIONS practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CLOUD-DEPLOYMENT-AND-OPERATIONS practice questions
- Question 1(What is the role of AWS Trusted Advisor?)
- Question 2(Which action must be used to create a metric filter in the Amazon CloudWatch console?)
- Question 3(Which CloudWatch metric filter includes log events with the word ERROR but excludes log …
- Question 4(Media files are stored in an S3 bucket in region A. Demand for the files from region B h…
- Question 5(A company is using Route 53 for Domain Name System (DNS) hosting. The company requires a…
- Question 6(A company configures the CloudFront caching TTL to the following settings: Min: 0, Max: …
