nerdexam
Snowflake

COF-C02 · Question #267

How does a scoped URL expire?

The correct answer is B. When the persisted query result period ends. A scoped URL is generated using the BUILD_SCOPED_FILE_URL function and provides temporary, secure access to a staged file. Its expiration is tied directly to the persistence period of the query result that generated it - once that persisted query result expires (the default…

Account Access and Security

Question

How does a scoped URL expire?

Options

  • AWhen the data cache clears.
  • BWhen the persisted query result period ends.
  • CThe encoded URL access is permanent.
  • DThe length of time is specified in the expiration_time argument.

How the community answered

(57 responses)
  • A
    2% (1)
  • B
    91% (52)
  • C
    5% (3)
  • D
    2% (1)

Explanation

A scoped URL is generated using the BUILD_SCOPED_FILE_URL function and provides temporary, secure access to a staged file. Its expiration is tied directly to the persistence period of the query result that generated it - once that persisted query result expires (the default result retention period is 24 hours, configurable up to 90 days), the scoped URL also becomes invalid. It is not permanent (C is wrong), it is not tied to the data cache (A is wrong), and unlike pre-signed URLs, you cannot specify an expiration_time argument when creating a scoped URL (D is wrong, which describes a pre-signed URL).

Topics

#Scoped URL#File Access#Query Result Cache#Security

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice