- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 11:39 PM
Dear Experts,
Can anyone please let me know how option "C" is the answer to Question 31 for 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.
- Labels:
-
Certification
-
Dear Experts
-
GA
-
Question
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 07:18 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2022 12:07 PM
thanks for the update
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 07:18 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 11:38 PM
Great...thanks for your input Hubert👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 07:19 AM
and thanks for pdf with questions - really interesting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-11-2022 07:37 AM
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.
![](/skins/images/B38AF44D4BD6CE643D2A527BE673CCF6/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/B38AF44D4BD6CE643D2A527BE673CCF6/responsive_peak/images/icon_anonymous_message.png)