Exam DEA-C02 Topic 1 Question 114 Discussion

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

You are developing a data pipeline in Snowflake that uses SQL UDFs for data transformation. You need to define a UDF that calculates the Haversine distance between two geographical points (latitude and longitude). Performance is critical. Which of the following approaches would result in the most efficient UDF implementation, considering Snowflake's execution model?

A. Create a SQL UDF that directly calculates the Haversine distance using Snowflake's built-in mathematical functions (SIN, COS, ACOS, RADIANS). This is straightforward and easy to implement. B. Create a Java UDF that calculates the Haversine distance, leveraging optimized mathematical libraries. This allows for potentially faster execution due to lower- level optimizations. C. Create an External Function (using AWS Lambda or Azure Functions) to calculate the Haversine distance. This allows for offloading the computation to a separate compute environment. D. Create a SQL UDF that pre-calculates the RADIANS for latitude and longitude only once and stores them in a temporary table, using those values for subsequent distance calculations within the same session. E. Create a SQL UDF leveraging Snowflake's VECTORIZED keyword, hoping to automatically leverage SIMD instructions, without any code changes to mathematical calculation inside the UDF

Suggested Answer: A Vote an answer

SQL UDFs are generally the most efficient for simple calculations within Snowflake because they are executed within the Snowflake engine, minimizing data movement and overhead. While Java UDFs (option B) can offer optimizations, the overhead of invoking the Java environment often outweighs the benefits for this type of calculation. External Functions (option C) introduce significant latency due to network communication. Option D provides temporary performance improvements for the specific session, but is not the most efficient general solution. Vectorized keyword doesn't exists in snowflake to create UDFs, Hence it won't allow compilation. This questions emphasis on understanding the trade-offs between different UDF types and their performance implications within the Snowflake architecture.

by Winifred at Aug 20, 2025, 04:55 AM

Limited Time Offer

15%

Off

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

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business