Databricks Certified Data Engineer Professional — Question 210

A 'transactions' table has been liquid clustered on the columns 'product_id’, ’user_id' and 'event_date'.

Which operation lacks support for cluster on write?

Answer options

• A. CTAS and RTAS statements
• B. spark.writeStream.format(’delta').mode(’append’)
• C. spark.write.format('delta’).mode('append')
• D. INSERT INTO operations

Correct answer: B

Explanation

The correct answer is B because spark.writeStream.format('delta').mode('append') does not support clustered writes as it is designed for streaming data. The other options, including CTAS, RTAS, and INSERT INTO operations, are capable of handling cluster on write operations.