Which SQL clause is used to rank rows within a partition of a result set, such as assigning a sequential number to each row within a department ordered by salary?

ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...)

A data engineer needs to produce a daily report showing, for each product category, the total sales and the running total of sales over the last 30 days. The sales table is large and frequently queried. Which SQL pattern should the engineer use to compute the running total efficiently?

Use a correlated subquery to sum sales for each row individually.

Use a self-join on the sales table to sum sales for each date range.

Use a window function with SUM() OVER (PARTITION BY category ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW).

Use a GROUP BY with ROLLUP to generate subtotals for each category.

A team has a Python transformation that reads from multiple tables, applies complex business logic, and writes results to a final table. They need to run this transformation on a schedule and want to minimize the number of objects to manage. They also want to avoid exposing the Python code to end users. Which approach should they choose?

Use an external Python script and schedule it with a cloud scheduler.

Use a Snowflake Stream and Task to incrementally process changes.

Create a Snowpark stored procedure and call it from a task.

Create a Snowpark UDF and call it from a SQL view.

SnowflakeSnowPro Advanced — Data Engineer

Domain 2Objective 1

Transform Data Using SQL and Snowpark DEA-C02 Practice Questions (Page 5)

Part of the Data Transformation domain, which accounts for 25% of the DEA-C02 exam.

25questions here

5free pages

6concepts

25%of the exam

Questions 21–25

21foundation · easy
Which SQL clause is used to rank rows within a partition of a result set, such as assigning a sequential number to each row within a department ordered by salary?
Select an answer first
22foundation · easy
Which Snowpark DataFrame method is used to add a new column computed from existing columns?
Select an answer first
23foundation · easy
Which type of UDF returns a single value for each input row?
Select an answer first
24application · medium
A data engineer needs to produce a daily report showing, for each product category, the total sales and the running total of sales over the last 30 days. The sales table is large and frequently queried. Which SQL pattern should the engineer use to compute the running total efficiently?
Select an answer first
25expert · hard
A team has a Python transformation that reads from multiple tables, applies complex business logic, and writes results to a final table. They need to run this transformation on a schedule and want to minimize the number of objects to manage. They also want to avoid exposing the Python code to end users. Which approach should they choose?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DEA-C02

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “DEA-C02” is a trademark of its owner, used for identification only.

Transform Data Using SQL and Snowpark DEA-C02 Practice Questions (Page 5)

Questions 21–25

Which SQL clause is used to rank rows within a partition of a result set, such as assigning a sequential number to each row within a department ordered by salary?

Which Snowpark DataFrame method is used to add a new column computed from existing columns?

Which type of UDF returns a single value for each input row?

A data engineer needs to produce a daily report showing, for each product category, the total sales and the running total of sales over the last 30 days. The sales table is large and frequently queried. Which SQL pattern should the engineer use to compute the running total efficiently?

Keep studying — Data Transformation