ExamTopics Logo
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam
Go to Exam

Exam Certified Data Engineer Associate topic 1 question 35 discussion

Actual exam question from Databricks's Certified Data Engineer Associate
Question #: 35
Topic #: 1
[All Certified Data Engineer Associate Questions]

Which of the following Structured Streaming queries is performing a hop from a Silver table to a Gold table?

  • A.
  • B.
  • C.
  • D.
  • E.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by XiltroX at April 2, 2023, 2:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
benni_ale
9 months, 2 weeks ago
Selected Answer: E
E - Aggregations are performed from silver to gold
upvoted 3 times
...
agAshish
1 year ago
Answer shoiuld be A , for writestream data should be stream only and not static
upvoted 1 times
benni_ale
9 months, 2 weeks ago
that's a good point but i would say that A is performing a raw data ingestion into bronze
upvoted 4 times
...
...
SerGrey
1 year, 1 month ago
Selected Answer: E
E is correct
upvoted 2 times
...
surya_lolla
1 year, 3 months ago
The best practice is to use "Complete" as output mode instead of "append" when working with aggregated tables. Since gold layer is work final aggregated tables, the only option with output mode as complete is option E.
upvoted 4 times
...
DavidRou
1 year, 3 months ago
Selected Answer: E
E is the right answer. The "gold layer" is used to store aggregated clean data, E is the only answer in wich aggregation is performed.
upvoted 1 times
...
tocs
1 year, 4 months ago
Selected Answer: E
E as we're doing an aggregation and we're rewriting the whole table and not just appending.
upvoted 2 times
...
GhaneshK
1 year, 6 months ago
E is correct as it includes group by as well by store.
upvoted 2 times
...
rafahb
1 year, 10 months ago
Selected Answer: E
E option
upvoted 3 times
...
surrabhi_4
1 year, 10 months ago
Selected Answer: E
Option E
upvoted 3 times
...
XiltroX
1 year, 10 months ago
E is the correct answer.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel