SnowPro Core Certification Free Practice Exam Questions

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

1. Question 1011: Which element in the Query Profile interface shows the relationship between the nodes in the execution of a query?
2. Question 1012: Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?
3. Question 1013: Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)
4. Question 1014: Which role has the ability to create and manage users and roles?
5. Question 1015: Which function unloads data from a relational table to JSON?
6. Question 1016: How can a data provider share their Snowflake data? (Choose two.)
7. Question 1017: What does Snowflake recommend when planning virtual warehouse usage for a data load?
8. Question 1018: Which Snowflake command can be used to unload the result of a query to a single file?
9. Question 1019: What persistent data structures are used by the search optimization service to improve the performance of point lookups?
10. Question 1020: Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?