LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Databricks Certified Data Engineer - Associate

Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.


In a data engineering project, you are tasked with designing a solution to synchronize a target table in Azure Databricks with a source table that frequently receives incremental updates and deletions. The solution must ensure data consistency, handle both updates and deletions efficiently, and minimize operational costs. Considering these requirements, which command should you use and why? (Choose one option.)

Simulated



Explanation:

Option C is the correct answer because the MERGE command is specifically designed to handle both incremental updates and deletions from a source table to a target table efficiently. It ensures data consistency by synchronizing the target table with the source table, including processing deletions, which is crucial for the given requirements. Option A, while ensuring data consistency, does so at a higher operational cost and is not efficient for frequent updates. Option B fails to handle deletions, leading to data inconsistency. Option D, although efficient for loading data, cannot process deletions, making it inadequate for the scenario described.

Powered ByGPT-5