topic Re: Databricks Associate Practice Exam -query in Data Engineering

Databricks Associate Practice Exam -query

jerry747847 — Tue, 04 Oct 2022 06:39:23 GMT

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.pdf?_ga=2.185796329.1103386439.1663221490-957565140.1661854848

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.

Re: Databricks Associate Practice Exam -query

jerry747847 — Fri, 07 Oct 2022 19:07:44 GMT

thanks for the update

Re: Databricks Associate Practice Exam -query

Hubert-Dudek — Tue, 11 Oct 2022 14:18:53 GMT

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.

Re: Databricks Associate Practice Exam -query

Hubert-Dudek — Tue, 11 Oct 2022 14:19:26 GMT

and thanks for pdf with questions - really interesting

Re: Databricks Associate Practice Exam -query

Hubert-Dudek — Tue, 11 Oct 2022 14:37:37 GMT

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.

Re: Databricks Associate Practice Exam -query

jerry747847 — Wed, 12 Oct 2022 06:38:37 GMT

Great...thanks for your input Hubert👍