SnowPro Core Certification — Question 1090

Which type of workload is recommended for Snowpark-optimized virtual warehouses?

Answer options

• A. Workloads with ad hoc analytics
• B. Workloads that have large memory requirements
• C. Workloads with unpredictable data volumes for each query
• D. Workloads that are queried with small table scans and selective filters

Correct answer: B

Explanation

The correct answer is B because Snowpark-optimized virtual warehouses are specifically designed to handle workloads that require significant memory, allowing for efficient processing of large datasets. Options A, C, and D do not emphasize the memory aspect, focusing instead on analytics, unpredictability, and filtering, which may not leverage the full capabilities of Snowpark.