SnowPro Core Certification Free Practice Exam Questions

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

1. Question 1152: A query is using more credits than expected. The Query Profile shows that a majority of the query execution is spent on remote disk I/O. How can this be preven…
2. Question 1153: In a SPLIT_PART function, what will the returned value be if the partNumber is out of range?
3. Question 1154: From which locations can data files be downloaded using the GET command? (Choose two.)
4. Question 1155: What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PI)? (Choose two.)
5. Question 1156: Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)
6. Question 1157: A security review identified several roles that are no longer being used. Which of the roles can be dropped?
7. Question 1158: How can a Snowflake user automate virtual warehouse operations for optimal credit consumption? (Choose two.)
8. Question 1159: Which data protection feature should only be used when all other data recovery options have been attempted?
9. Question 1160: A single cluster virtual warehouse has no free resources. What will happen to new queries that are run against this warehouse?
10. Question 1161: How does the search optimization service improve query performance?