DATABRICKS-SPARK Question 51

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - agg accepts multiple aggregate expressions; this produces one row per dept with sum(salary) and count(*) aliased as n. Multiple aggregates in one agg avoids multiple passes over the data. F.count('*') counts rows including nulls.