Snowflake SnowPro Core Recertification - SnowPro Core Recertification (COF-R02) Exam
Page: 1 / 12
Total 60 questions
Question #1 (Topic: Exam A)
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
Question #2 (Topic: Exam A)
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?
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
Question #3 (Topic: Exam A)
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
Question #4 (Topic: Exam 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
Question #5 (Topic: Exam 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
