SnowPro Core Certification Free Practice Exam Questions

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

1. Question 577: While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?
2. Question 578: Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
3. Question 579: What is the MAXIMUM size limit for a record of a VARIANT data type?
4. Question 580: Which identity providers are valid type values for federated authentication on the SAML_IDENTITY_PROVIDER parameter? (Choose two.)
5. Question 581: Snowflake strongly recommends that all users with what type of role be required to use Multi-Factor Authentication (MFA)?
6. Question 582: How is the hierarchy of database objects organized in Snowflake?
7. Question 583: What is the MINIMUM size of a table for which Snowflake recommends considering adding a clustering key?
8. Question 584: There are 300 concurrent users on a production Snowflake account using a single cluster virtual warehouse. The queries are small, but the response time is very…
9. Question 585: What is the MAXIMUM number of days a Snowflake-managed encryption key can be used before it gets automatically rotated?
10. Question 586: Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end…