Exam DEA-C02 Topic 1 Question 127 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 127
Topic #: 1

You are designing a data pipeline that requires applying a complex scoring algorithm to customer data in Snowflake. This algorithm involves multiple steps, including feature engineering, model loading, and prediction. You want to encapsulate this logic within a reusable component and apply it to incoming data streams efficiently. Which of the following approaches is most suitable and scalable for implementing this scoring logic as a UDF/UDTF, considering real-time data processing and low latency requirements?

A. A SQL UDF containing a series of nested CASE statements to implement the entire scoring algorithm. B. A Python UDF that loads a pre-trained machine learning model (e.g., using scikit-learn) and performs predictions on the input data. C. A Java UDTF that leverages a custom Java library for feature engineering and model prediction, deployed as a JAR file to Snowflake's internal stage. D. A Python UDTF using Snowpark, leveraging external libraries like 'torch' for accelerated calculations and ML model inference by GPU. E. A JavaScript UDF that uses basic JavaScript functions to perform the entire scoring algorithm without external dependencies.

Suggested Answer: D Vote an answer

Python UDTFs in Snowpark provide a powerful and scalable way to perform complex scoring algorithms, especially when combined with the GPU. Snowpark optimizes data processing within Snowflake's engine, and integration with Anaconda allows for using machine learning libraries such as scikit-learn or Pytorch for model loading and prediction and external libraries like 'torch' for accelerated calculations and ML model inference by GPU. SQL UDFs are not suitable for complex algorithms. JavaScript UDFs lack the necessary functionality and performance for advanced scoring. While Java UDTFs can be used, managing JAR files and potentially less efficient integration can be disadvantages. Using Python with SNOWPARK for GPU is suitable for real-time scoring and low latency.

by Lewis at Jun 26, 2026, 07:24 AM

Limited Time Offer

15%

Off

Get Premium DEA-C02 Questions as Interactive Self Test Engine or PDF

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business