Databricks Certified Data Engineer - Associate

Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.


Which SQL command is capable of inserting, updating, or deleting rows based on a condition that checks for the existence of a row(s)?





Explanation:

The MERGE INTO command is designed to perform insert, update, or delete operations based on a condition that checks if a row exists. This is particularly useful for synchronizing two tables by inserting, updating, or deleting rows in a target table based on a source table. For more details, refer to the Databricks documentation on MERGE INTO.