DP-203 Certification Practice Question #170

Question

You have an Azure subscription that contains an Azure Databricks workspace. The workspace contains a notebook named Notebook1.

In Notebook1, you create an Apache Spark DataFrame named df_sales that contains the following columns:

•	Customer
•	SalesPerson
•	Region
•	Amount

You need to identify the three top performing salespersons by amount for a region named HQ.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Accepted Answer

To identify the top three salespeople in the `HQ` region, the DataFrame must first be filtered to rows where `Region` equals `HQ`. Those filtered rows are then grouped by `SalesPerson`, aggregated with `sum(Amount)` to compute total sales per person, ordered descending by the aggregate total, and finally trimmed to the top three rows with `limit(3)`. That sequence matches the high-vote community answer and the standard Spark DataFrame workflow for grouped top-N analysis.

More DP-203 practice questions