Apache Spark 3 for Data Engineering and Analytics with Python - Aggregations with Grouping

What is the first step in grouping data before applying an aggregation function?

• Creating a new DataFrame

• Selecting specific columns

• Creating a heading

• Filtering the data

Which function is used to perform a count aggregation on grouped data?

• sum()

• count()

• max()

• min()

How can you order the results of a count aggregation?

• By using the filter function

• By using the orderBy function

• By using the groupBy function

• By using the select function

What is the purpose of using the agg function in the context of this tutorial?

• To filter data

• To perform multiple aggregations

• To create a new DataFrame

• To group data by multiple columns

When grouping data by origin state and city, which state is used as a filter in the example?

• New York

• California

• Texas

• Florida

Which aggregation functions are demonstrated in the final section of the tutorial?

• max, avg, count

• min, avg, sum

• max, min, sum, count

• sum, avg, count

What was the error corrected in the final section of the tutorial?

• Missing a round bracket

• Incorrect column name

• Wrong function used

• Missing a semicolon