Dynatrace Associate · Free Practice Question Medium
Question 23
You need to configure Dynatrace to monitor a Cassandra database. Which two metrics are essential to track for query performance analysis?
-
A
Disk I/O throughput and JVM garbage collection
-
B
Cassandra cache hit ratio and connection pool usage
-
C
Query execution time and lock contention
-
D
Network latency and CPU utilization
Reveal correct answers
Correct answers: B, C
Explanation
Cassandra’s performance hinges on efficient query handling and cache utilization. Query execution time (A) directly impacts user-facing latency, while lock contention signals resource starvation during concurrent write operations (common in Cassandra’s SSTable compaction process). The cache hit ratio (C) reflects how effectively data is served from memory vs. disk, critical for low-latency reads. Connection pool usage (C) prevents thread exhaustion during high concurrency. While CPU (B) and disk I/O (D) are important, they’re generic infrastructure metrics and less specific to Cassandra’s query behavior. JVM metrics (D) apply only if Cassandra runs on Java, which Dynatrace monitors via OneAgent, but they don’t directly explain query performance.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
