Databricks Associate Practice Exam -query

[jerry747847]

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.

[Kaniz]

Hi @JERRY JAMES​ , Thank you for reaching out!

Let us look into this for you, and we'll follow up with an update.

[jerry747847]

thanks for the update

[Hubert-Dudek · Accepted solution]

I agree that I would not put it as the correct option as it can be controversial as we make calculations and not only data cleaning.

But anyway I would choose C

as A and B contains aggregation, and agg means gold.

D and E are copying data without changes, so it is still bronze.

[jerry747847]

Great...thanks for your input Hubert👍

[Hubert-Dudek]

and thanks for pdf with questions - really interesting

[Hubert-Dudek]

Question 17 is even worse.

"A data engineer is overwriting data" vs "should simply be overwritten instead"

One situation I assume is DROP and CREATE and another is INSERT INTO OVERWRITE but here both are called the same.

A data engineer is overwriting data in a table by deleting the table and recreating the table.

Another data engineer suggests that this is inefficient and the table should simply be

overwritten instead.