🔥 3-day streak
Databricks Certified Data Engineer Associate29 / 150
Question 29 of 150

A data engineer is building a Silver-layer transformation from a Bronze customer table. The column `preferred_contact` frequently contains NULL values, and the business rule states that when it is NULL, the pipeline should fall back to the value in `secondary_contact`, and if that is also NULL, use the literal string 'unknown'. Which Spark SQL expression correctly implements this rule in a single column definition?

Reviewed for accuracy · Report an issueNext question