A PySpark job processes a batch of customer data. The 'age' column has some null values. The business rule is to replace null ages with the average age of the entire dataset. Which approach should you use?

Compute the average age, then use fillna with that value.

Use fillna with a constant value of 0.

Use fillna with the median age.

A logistics company runs a daily batch pipeline that aggregates shipment counts by route. Occasionally, shipment data for a previous day arrives late and is included in the next day's batch. The business needs the daily aggregation to reflect late-arriving data without reprocessing the entire history. What should you do?

Design the pipeline to reprocess the affected day's data by using a date parameter and upsert the results.

Reprocess the entire history every day to ensure accuracy.

Ignore late-arriving data and only process data for the current day.

Process late data in the next day's batch and add it to the current day's totals.

Microsoft Certified:Fabric Data Engineer Associate

Domain 2Objective 2

Ingest and Transform Batch Data DP-700 Practice Questions (Page 4)

Part of the Ingest and transform data domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 48 practice questions to prepare you well beyond it. (estimate)

48questions here

10free pages

13concepts

30–35%of the exam

Questions 16–20

16foundation · easy
A data engineer must transform a large batch of data using complex custom logic that includes machine learning model scoring. Which transformation tool is most appropriate?
Select an answer first
17expert · hard
A PySpark job processes a batch of customer data. The 'age' column has some null values. The business rule is to replace null ages with the average age of the entire dataset. Which approach should you use?
Select an answer first
18foundation · easy
A data engineer needs to perform a simple data transformation that combines data from multiple sources and loads the result into a Fabric lakehouse. The transformation requires no custom code and should be maintainable by business analysts. Which tool should be selected?
Select an answer first
19application · medium
A logistics company runs a daily batch pipeline that aggregates shipment counts by route. Occasionally, shipment data for a previous day arrives late and is included in the next day's batch. The business needs the daily aggregation to reflect late-arriving data without reprocessing the entire history. What should you do?
Select an answer first
20foundation · easy
Which SQL clause is used to combine rows from two or more tables based on a related column?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-700

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-700” is a trademark of its owner, used for identification only.

Ingest and Transform Batch Data DP-700 Practice Questions (Page 4)

Questions 16–20

A data engineer must transform a large batch of data using complex custom logic that includes machine learning model scoring. Which transformation tool is most appropriate?

A PySpark job processes a batch of customer data. The 'age' column has some null values. The business rule is to replace null ages with the average age of the entire dataset. Which approach should you use?

A data engineer needs to perform a simple data transformation that combines data from multiple sources and loads the result into a Fabric lakehouse. The transformation requires no custom code and should be maintainable by business analysts. Which tool should be selected?

Which SQL clause is used to combine rows from two or more tables based on a related column?

Keep studying — Ingest and transform data