SnowPro Core Certification Free Practice Exam Questions

1321 real SnowPro Core Certification exam questions with answers and AI explanations. Snowflake certification prep — page 73 of 133.

1. Question 729: What does the “percentage scanned from cache” represent in the Query Profile?
2. Question 730: What is the impact on queries that are being executed when a resource monitor set to the “Notify & Suspend” threshold level is exceeded?
3. Question 731: Which user preferences can be set for a user profile in Snowsight? (Choose two.)
4. Question 732: What is the recommended way to change the existing file format type in my_format from CSV to JSON?
5. Question 733: Based on Snowflake recommendations, when creating a hierarchy of custom roles, the top-most custom role should be assigned to which role?
6. Question 734: What type of query will benefit from the query acceleration service?
7. Question 735: What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)
8. Question 736: Which function determines the kind of value stored in a VARIANT column?
9. Question 737: What does the VARIANT data type impose a 16 MB size limit on?
10. Question 738: Which role has the ability to create a share from a shared database by default?