SnowPro Core Certification Free Practice Exam Questions

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

1. Question 1122: How can a 5 GB table be downloaded into a single file MOST efficiently?
2. Question 1123: What Snowflake recommendation is designed to ensure that staged data is only loaded once?
3. Question 1124: What Snowflake objects can contain custom application logic written in JavaScript? (Choose two.)
4. Question 1125: What should an account administrator do to help a user log into Snowflake, if the user cannot authenticate using Multi-Factor Authentication (MFA)?
5. Question 1126: Which Snowflake feature improves the performance of point lookup queries?
6. Question 1127: What optional properties can a Snowflake user set when creating a virtual warehouse? (Choose two.)
7. Question 1128: What metadata is stored for each micro-partition? (Choose two.)
8. Question 1129: How can the Query Profile be used to troubleshoot a problematic query?
9. Question 1130: How can the ACCESS_HISTORY view in the ACCOUNT_USAGE schema be used to review the data governance settings for an account? (Choose two.)
10. Question 1131: How can a relational table be unloaded into a JSON file?