In a report, which of the following is true when enabling the local cache property on a query?

Question

Options

• ALocal cache is only supported on batch re|
• BData is cached and may improve performance.
• DThe scalability of a report is negatively impacted.

• A
  71% (35)
• B
  10% (5)
• D
  18% (9)

Explanation

Option A is correct because local cache for queries in a report is restricted to batch report execution contexts - it cannot be applied to interactive or real-time report runs, making it a feature with a specific, limited scope rather than a general-purpose optimization tool.

Option B is a tempting distractor: while data is technically cached, the statement that it "may improve performance" is misleading in this context - the primary purpose and constraint of local cache is its batch-only support, not a general performance enhancement. Option D is incorrect because local caching does not negatively impact scalability; if anything, reducing repeated data fetches would relieve load rather than worsen it.

Memory tip: Think "batch = cached, live = not cached." Local cache is a batch-exclusive feature - if the report runs in real-time or interactively, local cache simply doesn't apply.

No community discussion yet for this question.