Databricks · Databricks Data Engineer Associate
Gold objects and data quality
Databricks Data Engineer Associate · Lesson 12 of 22 · 1:16:45
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Engineer Associate exam. In this lesson: gold objects (views, materialized views, and streaming tables), choosing the right object, expectations in Lakeflow pipelines, and constraints with quarantine tables. Includes three original practice questions.
Preview the topics
- Store managers open a dashboard of daily sales totals dozens of times each morning, and each open recomputes an aggregation over two billion rows, although the sales change only once a night. Which gold object should the data engineer build?
- A pipeline loads Hollowbrook's sales into silver. Rows with a negative quantity must never reach the table, while the rest of each batch must still load. Which expectation action fits?
- A silver table of orders must never contain a row without a store ID, whatever job or notebook writes to it, and the team does not use a pipeline for this table. What should the data engineer add?