What does the `MERGE INTO` SQL statement do in Delta Lake?

AIt merges two Delta tables into a single table by appending all rows

BIt performs an upsert: matching rows are updated, non-matching rows can be inserted or deleted

CIt merges table schema changes from a source table into a target table

DIt combines two streaming DataFrames into a single output stream

More Data Processing & Transformations Questions

62 questions

Full Databricks Certified Data Engineer Associate Practice Test

All topics covered

All Databricks Certified Data Engineer Associate Questions

Browse by topic

Related Questions

In Apache Spark, what is the difference between a transformation and an action?...

easy

A data engineer wants to add a new column `discounted_price` to a PySpark DataFrame `df` that equals...

easy

A data engineer has a PySpark DataFrame `orders` and wants to calculate the total order amount group...

medium

A data engineer writes the following Spark SQL to query a Delta table:\n\n```sql\nSELECT customer_id...

medium

A data engineer needs to join a large `transactions` DataFrame with a small `lookup` DataFrame that ...

medium

View all Data Processing & Transformations questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.

What does the MERGE INTO SQL statement do in Delta Lake?

Related Questions

Discussion

What does the `MERGE INTO` SQL statement do in Delta Lake?