SOL-C01 · Question #105
SOL-C01 Question #105: Real Exam Question with Answer & Explanation
The correct answer is C: Use a COPY INTO statement with a SELECT statement that performs the transformations.. The COPY INTO statement with a SELECT statement provides the most efficient and recommended way to transform data during the load process. It leverages Snowflake's compute engine for transformations, avoiding the overhead of external scripts or stored procedures for simple transf
Question
A data engineer is loading data into Snowflake from an external stage. They need to transform data during the load process. Which of the following is the MOST efficient and recommended approach for performing this transformation in Snowflake?
Options
- AUse Snowpipe with a transformation script running on a separate compute instance.
- BUse a Stored Procedure to read the data from the stage, transform it, and then insert it into the
- CUse a COPY INTO statement with a SELECT statement that performs the transformations.
- DDownload the data from the stage, transform it using a Python script, and then upload it into
- ECreate a View that transforms the data after loading it into a staging table.
Explanation
The COPY INTO statement with a SELECT statement provides the most efficient and recommended way to transform data during the load process. It leverages Snowflake's compute engine for transformations, avoiding the overhead of external scripts or stored procedures for simple transformations. Using views would transform the data on read, not during load.
Topics
Community Discussion
No community discussion yet for this question.