cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks Associate Practice Exam -query

jerry747847
New Contributor III

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III

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.

View solution in original post

6 REPLIES 6

Kaniz_Fatma
Community Manager
Community Manager

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

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

jerry747847
New Contributor III

thanks for the update

Hubert-Dudek
Esteemed Contributor III

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.

Great...thanks for your input Hubert👍

Hubert-Dudek
Esteemed Contributor III

and thanks for pdf with questions - really interesting

Hubert-Dudek
Esteemed Contributor III

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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!