SnowPro Core Recertification Free Practice Exam Questions

51 real SnowPro Core Recertification exam questions with answers and AI explanations. Snowflake certification prep — page 4 of 6.

1. Question 31: What MINIMUM privilege is required on an external stage for any role in the GET REST API to access unstructured data files using a file URL?
2. Question 32: Which Snowflake data governance feature can support auditing when a user query reads column data?
3. Question 34: What action can be performed using the GET command in Snowflake?
4. Question 35: What does the LATERAL modifier for the FLATTEN function do?
5. Question 36: How long does Snowflake retain information in the ACCESS_HISTORY view?
6. Question 37: What are the primary authentication methods that Snowflake supports for securing REST API interactions? (Choose two.)
7. Question 38: Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
8. Question 39: Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
9. Question 40: By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
10. Question 41: What happens to the privileges granted to Snowflake system-defined roles?