In a batch processing scenario, what does an 'upsert' operation do?

Only inserts new rows, ignoring existing ones

Deletes all rows and inserts fresh data

Updates existing rows and inserts new rows

Only updates existing rows, ignoring new ones

A financial services company uses Azure Databricks to process daily transactions stored in Delta Lake. The pipeline performs upserts using a MERGE operation. After a recent pipeline run, the finance team discovered that a bug caused incorrect updates to a subset of records. You need to revert the Delta table to the state before the erroneous run while preserving the ability to audit the change. What should you do?

Use the OPTIMIZE command to rewrite the table and eliminate the bad records.

Run a DELETE statement to remove the incorrect records and re-insert the correct ones from the source.

Use Delta Lake time travel to restore the table to the version before the erroneous run.

Use the VACUUM command to remove the erroneous data files and then reload the table.

In Azure Data Factory, which feature allows you to validate the schema and data of source files before they are processed by a pipeline?

Copy activity's batch size setting

Schema drift detection in mapping data flows

Microsoft Certified:Azure Data Engineer Associate

Domain 2Objective 2

Develop a Batch Processing Solution DP-203 Practice Questions (Page 3)

Part of the Develop data processing domain, which accounts for 40–45% of the DP-203 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~16–29 in this domain), expect 4–7 from this objective — we provide 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

16concepts

40–45%of the exam

Questions 11–15

11foundation · easy
In a batch processing scenario, what does an 'upsert' operation do?
Select an answer first
12foundation · easy
In Azure Databricks, which configuration parameter in a Spark DataFrame write operation controls the number of rows or bytes per output file, helping to manage file sizes in batch processing?
Select an answer first
13expert · hard
A financial services company uses Azure Databricks to process daily transactions stored in Delta Lake. The pipeline performs upserts using a MERGE operation. After a recent pipeline run, the finance team discovered that a bug caused incorrect updates to a subset of records. You need to revert the Delta table to the state before the erroneous run while preserving the ability to audit the change. What should you do?
Select an answer first
14foundation · easy
In Azure Data Factory, which feature allows you to validate the schema and data of source files before they are processed by a pipeline?
Select an answer first
15foundation · easy
Which technology in Azure Synapse Analytics dedicated SQL pools allows you to load data from external files in Azure Data Lake Storage Gen2 or Azure Blob Storage using T-SQL statements?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-203

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-203” is a trademark of its owner, used for identification only.

Develop a Batch Processing Solution DP-203 Practice Questions (Page 3)

Questions 11–15

In a batch processing scenario, what does an 'upsert' operation do?

In Azure Databricks, which configuration parameter in a Spark DataFrame write operation controls the number of rows or bytes per output file, helping to manage file sizes in batch processing?

In Azure Data Factory, which feature allows you to validate the schema and data of source files before they are processed by a pipeline?

Which technology in Azure Synapse Analytics dedicated SQL pools allows you to load data from external files in Azure Data Lake Storage Gen2 or Azure Blob Storage using T-SQL statements?

Keep studying — Develop data processing