Calculate the total sales amount for each region and store the results in a new...

Databricks Databricks-Certified-Data-Engineer-Associate Question Answer

Calculate the total sales amount for each region and store the results in a new dataframe called region_sales.

Given the expected result:

Which code will generate the expected result?

region_sales = sales_df.groupBy("region").agg(sum("sales_amountM).alias("total_sales_amount"))

region_sales = sales_df. sum ("salen_aiTiount") . groupBy ("region") .alias ("total_sale3_amount")

region_sales= sales_df.groupBy("category").sum(nsales_amount").alias("t_otal_sales_amounl")

region sales - sales_df.agg(sum("sales_amount").groupBy("region").alias("total sales amount"))

Databricks-Certified-Data-Engineer-Associate PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"