Snowflake SnowPro Core Recertification - SnowPro Core Recertification (COF-R02) Exam

Page:    1 / 12   
Total 60 questions

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

  • A. 0 days
  • B. 1 day
  • C. 7 days
  • D. 14 days


Answer : B

A Snowflake user is actively logged into Snowflake when a user-level network policy is assigned to that user.
What will Snowflake do if the user's IP address does not match the user-level network policy rules?

  • A. Log the user out.
  • B. Deactivate the network policy.
  • C. Prevent the user from executing additional queries.
  • D. Allow the user to continue until the session or login token expires.


Answer : C

What happens to the privileges granted to Snowflake system-defined roles?

  • A. The privileges cannot be revoked.
  • B. The privileges can be revoked by an ACCOUNTADMIN.
  • C. The privileges can be revoked by an ORGADMIN.
  • D. The privileges can be revoked by any user-defined role with appropriate privileges.


Answer : A

What is the default access of a securable object until other access is granted?

  • A. No access
  • B. Read access
  • C. Write access
  • D. Full access


Answer : A

Streams can be configured to query change data on which Snowflake objects? (Choose two.)

  • A. Pipe
  • B. Stage
  • C. Secure view
  • D. Materialized view
  • E. Shared table


Answer : BC

Page:    1 / 12   
Total 60 questions