SnowPro Advanced: Architect — Question 134

What considerations should be taken into account when deciding which method to use to load data into Snowflake? (Choose three.)

Answer options

• A. The ETL method is typically faster than other methods, as it transforms data on ingestion.
• B. With the ETL method, users may need to reload the incoming data if there is an error in the process.
• C. The ELT method is more scalable than other methods as it uses Snowflake’s virtual warehouses.
• D. The ELT method can separate the ingestion and transformation resources, making it the most flexible method.
• E. The ELT method will not allow any type of data transformation on ingestion.
• F. With the ELT method, transformations may take longer to execute than other methods, as they depend on the size of the data.

Correct answer: B, C, D

Explanation

The correct answers B, C, and D highlight the potential pitfalls and advantages of the ETL and ELT methods when loading data into Snowflake. Option B points out the need for data reloading in ETL if errors occur, while options C and D showcase the scalability and flexibility of the ELT method due to its architecture. Options A, E, and F are incorrect as they either misrepresent the capabilities of ETL and ELT or provide misleading information about their performance characteristics.