SnowPro Advanced: Data Engineer — Question 99

A company is running several machine learning models that were developed in Scala and are running on-premises. A Data Engineer has been asked to design a solution using Snowflake.

What is the FASTEST way to migrate the models to Snowflake?

Answer options

• A. Convert the Scala code to SQL and create new SQL User-Defined Functions (UDFs) in Snowflake.
• B. Create new Scala User-Defined Functions (UDFs) in Snowflake using the existing Scala code.
• C. Use Snowpark to create User-Defined Functions (UDFs) based on the existing Scala code.
• D. Use a Python function to create User-Defined Functions (UDFs) based on the existing Scala code.

Correct answer: C

Explanation

The fastest method to migrate the models to Snowflake is to use Snowpark to create User-Defined Functions (UDFs) based on the existing Scala code, as it supports Scala natively. Converting to SQL (Option A) or using Python (Option D) would require additional transformation and may lead to performance issues. Creating new Scala UDFs (Option B) is less efficient than utilizing Snowpark's capabilities.