The below spark command is looking to databricks video

October 01, 2025  ·  PT1H46M27S  ·  EN

data-engineer-associate video for the below spark command is looking to create a summary table based customerId and the number of times the customerId is

Question 1 Be Honest

« Back   Next data-engineer-associate Certification Question »

Answer

Full Certification Question

The below spark command is looking to create a summary table based customerId and the number of times the customerId is present in the event_log delta table and write a one-time micro-batch to a summary table, fill in the blanks to complete the query. spark . _________ . format ( "delta" ) . table ( "events_log" ) . groupBy ( "customerId" ) . count () . _______ . format ( "delta" ) . outputMode ( "complete" ) . option ( "checkpointLocation" , "/tmp/delta/eventsByCustomer/_checkpoints/" ) . trigger ( ______ ) . table ( "target_table" )