Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data engineer executes a query to load data into a downstream table using Delta format. After the upstream table is dropped and recreated without a specific column for compliance, the query fails upon rerun. What modification ensures the query runs successfully while preserving historical data in the downstream table?
A
Change the checkpoint location to a new path.
B
Add .drop('deleted_column_name') before writing to the downstream table.
C
Include .option('mergeSchema', 'true') and remove the checkpoint location option.
D
Add .outputMode('append') to the streaming query.
E
Both add .drop('deleted_column_name') and remove the checkpoint location option.