Oracle Exam 1Z0-908 Topic 14 Question 93 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 93
Topic #: 14

[All 1Z0-908 Questions]

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.

Using Query Analyzer, where do you begin to look for problem queries?

ASort the ''Exec' column and check for SQL queries with low Query Response Time index (QRTi) values.

BLook for queries with low total latency times in the Latency section in the times series graph.

CLook for queries with big prolonged spikes in row activity/access graph in the times series graph.

DSort the ''Exec' column and check for SQL queries with high Query Response Time index (QRTi) values.

Show Suggested Answer

Suggested Answer: B, D, E

by Rochell at Oct 20, 2024, 04:05 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Beula

9 days ago

Wait, you're telling me MySQL has an 'Enterprise Monitor'? Does that come with a complimentary fedora and a lifetime supply of energy drinks?

upvoted 0 times

...

Maurine

12 days ago

B seems the most logical choice. Latency times are a clear indicator of where the issues lie. Who needs all that fancy 'Exec' column sorting, anyway?

upvoted 0 times

Sunshine

2 days ago

I agree, B does seem like the most logical choice. Latency times are a clear indicator of where the issues lie.

upvoted 0 times

...

Viola

18 days ago

C sounds like the best option to me. Checking for those big spikes in row activity/access is a surefire way to find the culprits.

upvoted 0 times

...

Jeniffer

23 days ago

I think A is the way to go. Sort by low QRTi values? That's counterintuitive, but I guess it makes sense if we're looking for the problem queries.

upvoted 0 times

Madonna

15 hours ago

User2: Yeah, that's a good starting point to find problem queries.

upvoted 0 times

...

Danilo

3 days ago

User1: I think A is the way to go. Sort by low QRTi values?

upvoted 0 times

...

Janna

28 days ago

D is the correct answer. We want to sort the 'Exec' column and look for queries with high QRTi values, as those are the problematic ones causing performance issues.

upvoted 0 times

Kristeen

11 days ago

User 2: Thanks for the tip! I'll make sure to focus on those queries first.

upvoted 0 times

...

Destiny

12 days ago

User 1: D is the correct answer. We want to sort the 'Exec' column and look for queries with high QRTi values, as those are the problematic ones causing performance issues.

upvoted 0 times

...