Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
A . MERGE INTO table_name
B . COPY INTO table_name
C . UPDATE table_name
D . INSERT INTO OVERWRITE table_name
E . INSERT IF EXISTS table_name
Answer: A
Explanation:
here is the additional documentation for your review. https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-merge-into.html
Latest Databricks Certified Data Engineer Professional Dumps Valid Version with 278 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund