Question 1 (Topic 1)

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?

Select an option, then click Submit answer.

○ Log the user out.
○ Deactivate the network policy.
○ Prevent the user from executing additional queries.
○ Allow the user to continue until the session or login token expires.

Reference / correct answer:

Prevent the user from executing additional queries.

Most accepted answer: C. Prevent the user from executing additional queries.

Community votes: A=1, C=3

Selected Answer: C Has anyone found these 60-ish questions sufficient for prepping for the REcertification of snowpro core? So the renewal certification exam I mean? upvoted 2 times

Selected Answer: C When a user-level network policy is assigned, Snowflake does not immediately log the user out but enforces the policy on subsequent actions. If the user's IP address does not match the policy rules, Snowflake will block any further queries or operations from that session. upvoted 1 times

Selected Answer: C Answer C. https://docs.snowflake.com/en/user-guide/network-policies In addition, when a user-level network policy is associated with the user and the user is already logged into Snowflake, if the user’s network location does not match the user-level network policy rules, Snowflake prevents the user from executing further queries. upvoted 1 times

Selected Answer: A The reason C. Prevent the user from executing additional queries is not the correct answer is because Snowflake's network policies are designed to enforce security by immediately terminating sessions that do not comply with the policy rules. When a user's IP address does not match the user-level network policy, Snowflake logs the user out to prevent any potential security risks12. Preventing the user from executing additional queries while allowing them to remain logged in could still pose a security threat, as the user would still have an active session. Logging the user out ensures that any unauthorized access is immediately cut off. upvoted 1 times

In addition, when a user-level network policy is associated with the user and the user is already logged into Snowflake, if the user’s network location does not match the user-level network policy rules, Snowflake prevents the user from executing further queries. upvoted 1 times

Question 2 (Topic 1)

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

Select an option, then click Submit answer.

○ Pipe
○ Stage
○ Secure view
○ Materialized view
○ Shared table

Question 3 (Topic 1)

At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?

Select an option, then click Submit answer.

○ Account
○ Database
○ Schema
○ Table

Free SNOWPRO-CORE-RECERTIFICATION – Snowflake SNOWPRO-CORE-RECERTIFICATION Practice Test Question