A data engineer is using a foreachBatch databricks video
data-engineer-professional video for a data engineer is using a foreachBatch logic to upsert data in a target Delta table. The function to be called at each new
Full Certification Question
A data engineer is using a foreachBatch logic to upsert data in a target Delta table. The function to be called at each new microbatch processing is displayed below with a blank: def upsert_data ( microBatchDF , batch_id ): microBatchDF . createOrReplaceTempView ( "sales_microbatch" ) sql_query = """ MERGE INTO sales_silver a USING sales_microbatch b ON a.item_id=b.item_id AND a.item_timestamp=b.item_timestamp WHEN NOT MATCHED THEN INSERT * """ ________________ Which option correctly fills in the blank to execute the sql query in the function on a cluster with recent Databricks Runtime above 10.5 ?