Home / Data Engineer Associate / Objective 3.7

Domain 3: Data Transformation and Modeling · 22% of the exam · Full exam outline

3.7 Apply data quality checks and validation rules to ensure reliable Silver and Gold datasets.

Practice questions

Question 1easy

A pipeline defines @dp.expect("valid_qty", "qty > 0") on a silver table, with no other expectation decorators. What happens to an incoming record whose qty is -3?

Included in Master: master every domain.See plans
Question 2easy

A team declares PRIMARY KEY (order_id) on a gold Delta table in Unity Catalog, then finds that a job inserted two rows with the same order_id without any error. Why was the insert allowed?

Included in Master: master every domain.See plans