* Snowflake Marketplace allows customers to share or consume data through data listings.
* To participate as a provider or consumer, users must agree to additional terms of service.
* The ACCOUNTADMIN role is required to manage agreements and enable Marketplace features because this role has the necessary permissions to modify account-level configurations.
References:
* Snowflake Documentation: Snowflake Marketplace Setup
* Snowflake Roles and Privileges

To process unstructured data in Snowflake, external functions can be used.
External Functions: These allow you to call external services and processing engines from within Snowflake SQL. External functions can be used to handle complex processing tasks that are not natively supported by Snowflake, including those involving unstructured data.
Implementation: You define an external function in Snowflake that points to an external processing service (e.
g., AWS Lambda, Google Cloud Functions).
Snowflake Documentation on External Functions

The correct answers are A. Increase the size of the virtual warehouse and B. Edit the queries to process the data in smaller batches .
Memory spilling occurs when a query requires more memory than is available in the virtual warehouse.
Snowflake may spill intermediate data to local or remote storage, which can slow query performance.
Why A is correct:
Increasing the warehouse size provides more compute and memory resources. This can reduce or eliminate spilling for memory-intensive queries.
Why B is correct:
Rewriting queries to process data in smaller batches reduces the amount of intermediate data held in memory at one time. This can reduce spilling and improve performance.
Important note about option C:
Option C is misleading because a virtual warehouse cluster's size is changed by increasing the warehouse size
. Since option A already says this correctly, option C is not the best answer.
Why the other options are incorrect:
C). "Increase the size of the virtual warehouse clusters" is essentially a less precise duplicate of increasing warehouse size. The exam-style answer is A.
D). Suspending and resuming a warehouse may clear cache, but it does not increase available memory and does not solve memory spilling.
E). Clustering can improve pruning and reduce scanned data for some queries, but it is not the direct general solution for queries that are spilling because they are too large for memory.
Official Snowflake documentation reference:
Snowflake Query Profile documentation explains that spilling to local or remote storage can occur when operations do not fit in memory. Snowflake performance guidance recommends scaling up the warehouse or rewriting queries to reduce the amount of data processed.
Reference: Snowflake Documentation - Query Profile; Snowflake Documentation - Warehouse performance; SnowPro Core Study Guide - Performance Optimization.

* The Query Acceleration Service offloads portions of query processing to shared compute resources to handle larger-than-average queries without impacting virtual warehouse performance.
* This feature is ideal for resource-intensive queries and operates independently of virtual warehouse scaling.
References:
* Snowflake Documentation: Query Acceleration Service
* Snowflake Performance Optimization

Snowflake stored procedures can be created to execute with the privileges of the role that owns the procedure (owner's rights) or with the privileges of the role that calls the procedure (caller's rights). This allows for flexibility in managing security and access control within Snowflake1.