Exam DEA-C02 Topic 1 Question 283 Discussion

Actual exam question for Snowflake's DEA-C02 exam
Question #: 283
Topic #: 1
You're using Snowpark Python to transform data in a Snowflake table called 'employee_data' which includes columns , 'department, 'salary' , and 'performance_rating'. You need to identify the top 3 highest-paid employees within each department based on their salary, but only for departments where the average performance rating is above 4.0. Which of the following approaches using Snowpark efficiently combines window functions, filtering, and aggregations to achieve this?

Suggested Answer: E Vote an answer

Option E is the most efficient approach, as it calculates the average performance rating per department first and then joins the original DataFrame to only include departments with an average rating above 4.0 using 'left join'. The correct department and salary calculations, filter to only the top 3 with high performace review.

by Jack at Sep 10, 2026, 12:52 PM

Limited Time Offer

15%

Off

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

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10