Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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
7 months ago
Selected Answer: E
E - Aggregations are performed from silver to gold
upvoted 2 times
...
agAshish
9 months, 4 weeks ago
Answer shoiuld be A , for writestream data should be stream only and not static
upvoted 1 times
benni_ale
7 months ago
that's a good point but i would say that A is performing a raw data ingestion into bronze
upvoted 3 times
...
...
SerGrey
10 months, 3 weeks ago
Selected Answer: E
E is correct
upvoted 2 times
...
surya_lolla
1 year 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 3 times
...
DavidRou
1 year 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, 1 month 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, 3 months ago
E is correct as it includes group by as well by store.
upvoted 2 times
...
rafahb
1 year, 7 months ago
Selected Answer: E
E option
upvoted 3 times
...
surrabhi_4
1 year, 7 months ago
Selected Answer: E
Option E
upvoted 3 times
...
XiltroX
1 year, 7 months ago
E is the correct answer.
upvoted 4 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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