Review 60 SNOWPRO-CORE-RECERTIFICATION practice questions with answer explanations and community insights.
Question 1
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
0 days
1 day
7 days
14 days
Question 2
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?
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.
Question 3
What happens to the privileges granted to Snowflake system-defined roles?
The privileges cannot be revoked.
The privileges can be revoked by an ACCOUNTADMIN.
The privileges can be revoked by an ORGADMIN.
The privileges can be revoked by any user-defined role with appropriate privileges.
Question 4
What is the default access of a securable object until other access is granted?
No access
Read access
Write access
Full access
Question 5
Streams can be configured to query change data on which Snowflake objects? (Choose two.)
Pipe
Stage
Secure view
Materialized view
Shared table
We are moving to a new platform
CertificationTest is being migrated. Some pages may be slow or briefly unavailable; everything will be back to normal within a few hours. If you run into any issue, email support@certificationtest.net.