Dear Experts,

Can anyone please let me know how option "C" is the answer to Question 31 for PracticeExam-DataEngineerAssociate.

https://files.training.databricks.com/assessments/practice-exams/PracticeExam-DataEngineerAssociate....

Since option "C" contains the average function it can't be the correct option as aggregation is from the Silver to the Gold table as per my understanding.