DP-750: Implementing Data Engineering Solutions Using Azure DatabricksDemo

By Microsoft · Question Mode

QuestionQ76

Prepare and process data

You have an Azure Databricks workspace enabled for Unity Catalog that contains a Delta table named Sales_orders.

Sales_orders stores historical sales data.

Each day, you receive a CSV file containing only new sales records. The file does not include updates to existing rows.

You need to load the daily data into Sales_orders. The solution must meet these requirements:

  • Preserve the existing data.
  • Add only the new records.
  • Minimize processing effort.

Which command should be included in the loading strategy?

  • A UPDATE
  • B INSERT OVERWRITE
  • C INSERT INTO
Explanation

INSERT INTO appends new rows to an existing Delta table, preserving its historical records. Because the source contains only inserts and no changes to existing rows, an append operation avoids the additional matching or replacement work required by update or overwrite operations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!