SnowPro Core Certification Free Practice Exam Questions

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

1. Question 222: If a size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
2. Question 223: Which SQL command can be used to verify the privileges that are granted to a role?
3. Question 224: What is the default Time Travel retention period?
4. Question 225: Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Choose two.)
5. Question 226: Which schema has the RESOURCE_MONITORS view?
6. Question 227: Snowflake's approach to the management of system access combines which of the following models? (Choose two.)
7. Question 228: According to Snowflake best practice recommendations, which role should be used to create databases?
8. Question 229: To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)
9. Question 230: When is the result set cache no longer available? (Choose two.)
10. Question 231: Which statements are true concerning Snowflake’s underlying cloud infrastructure? (Choose three.)