Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
In the context of implementing a Change Data Capture (CDC) mechanism in a data pipeline using the APPLY CHANGES INTO command, consider the following scenario: A financial institution requires real-time synchronization of transaction data from a source table to a target customer account table to ensure account balances are always accurate. The solution must handle inserts, updates, and deletes, manage conflicts, and maintain data integrity without overwriting existing data unnecessarily. Given these requirements, which of the following best describes the behavior of the APPLY CHANGES INTO command and its suitability for this scenario? (Choose the best option.)
A
The APPLY CHANGES INTO command overwrites the entire target table with data from the source table, which is efficient but does not meet the requirement for maintaining data integrity.
B
The APPLY CHANGES INTO command inserts new records from the source table into the target table without updating or deleting existing records, which partially meets the synchronization requirement.
C
The APPLY CHANGES INTO command captures changes from the source table and applies them to the target table by inserting new records, updating existing ones, and handling deletions, thus maintaining data integrity and meeting all given requirements.
D
The APPLY CHANGES INTO command deletes records in the target table that do not match the source table, ensuring the target table only contains the latest data but fails to handle updates and inserts.