Exam DEA-C02 Topic 1 Question 115 Discussion

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

You've created a JavaScript UDF in Snowflake to perform complex string manipulation. You need to ensure this UDF can handle a large volume of data efficiently. The UDF is defined as follows:

When testing with a large dataset, you observe poor performance. Which of the following strategies, when applied independently or in combination, would MOST likely improve the performance of this UDF?

A. Replace the JavaScript UDF with a SQL UDF that uses built-in Snowflake string functions like 'REGEXP REPLACE and 'REPLACE. SQL UDFs are generally more optimized within Snowflake's execution engine. B. Ensure the input 'STRING' is defined with the maximum possible length to provide sufficient memory allocation for the JavaScript engine to manipulate the string. C. Pre-compile the regular expressions used within the JavaScript UDF outside of the function and pass them as constants into the function. JavaScript regex compilation is expensive, and pre-compilation can reduce overhead. D. Increase the warehouse size to the largest available size (e.g., X-Large) to provide more resources for the UDF execution. E. Convert the JavaScript UDF to a Java UDF, utilizing Java's more efficient string manipulation libraries and leveraging Snowflake's Java UDF execution environment.

Suggested Answer: A,C,E Vote an answer

Options A, C and E can all contribute to better performance. SQL UDFs benefit from Snowflake's optimized execution engine for standard operations, making them often faster than JavaScript UDFs for string manipulation when possible. Pre-compiling regular expressions (Option C) avoids redundant compilation steps during each UDF invocation. Converting to a Java UDF (Option E) gives more control over efficiency compared to JS. The option D may help, but the performance gain is not guaranteed and is more related to resource availability than the UDF's efficiency. The option B is not valid since the size of input STRING won't matter the javascript engine.

by Emmanuel at Mar 07, 2026, 05:21 PM

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