nerdexam
Snowflake

COF-R02 · Question #223

What affects whether the query results cache can be used?

The correct answer is B. If the virtual warehouse has been suspended. See the full explanation below for the reasoning.

Question

What affects whether the query results cache can be used?

Options

  • AIf the query contains a deterministic function
  • BIf the virtual warehouse has been suspended
  • CIf the referenced data in the table has changed
  • DIf multiple users are using the same virtual warehouse

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    78% (25)
  • C
    13% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice