Which of the following is an example of when the query cache would avoid roundtrips to the

Question

Options

• Arepetitive master-detail requests
• Bdrill through reports
• Creports with multiple queries
• Ddrill down reports

• A
  71% (17)
• B
  4% (1)
• C
  17% (4)
• D
  8% (2)

Explanation

Repetitive master-detail requests are the ideal query cache use case because the same queries execute repeatedly - for example, fetching a master record and its associated details each time a user opens the same record. The cache intercepts the duplicate query and returns the stored result, eliminating the roundtrip to the database entirely.

B (Drill-through reports) are wrong because drill-through navigates to underlying raw data in a different context, typically generating unique queries each time rather than repeating the same one. C (Reports with multiple queries) is wrong because having many queries doesn't imply repetition - distinct queries each miss the cache and still hit the database. D (Drill-down reports) is wrong because each drill-down level (e.g., year → quarter → month) usually produces a different query with different parameters, so cache reuse is minimal.

Memory tip: Think "cache = same again." The query cache only helps when the exact same query runs more than once - master-detail fits because users frequently open the same records repeatedly, making it a high-repetition pattern.

No community discussion yet for this question.