nerdexam
Snowflake

DEA-C02 · Question #95

A Data Engineer is using Snowpark to perform data transformations on large data sets in Snowflake. The Engineer wants to optimize the transformation process by minimizing the amount of data distribute

Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.

Performance Optimization

Question

A Data Engineer is using Snowpark to perform data transformations on large data sets in Snowflake. The Engineer wants to optimize the transformation process by minimizing the amount of data distributed across nodes, and leveraging Snowflake’s compute resources most effectively. Which combination of strategies should the Engineer use to meet these requirements?

Options

  • ALoad data using read, apply sorting operations before filtering, and use
  • BPerform joins using the default settings, apply transformations across all columns simultaneously,
  • CUse the method to store results temporarily, apply filtering operations
  • DCreate data samples with session.createDataFrame(), merge datasets using unionAll(),

Unlock DEA-C02 to see the answer

You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowpark Performance#Data Filtering#Distributed Data Optimization#Intermediate Data Strategy
Full DEA-C02 Practice