A pipeline uses a Notebook activity that runs a Spark job to transform data. The job takes 30 minutes and uses a default Spark pool with 5 executors. The engineer wants to reduce runtime. Which change is most effective?

Increase the number of executors in the Spark pool.

Move the transformation to a Dataflow Gen2.

Use a smaller file format like CSV instead of Parquet.

Disable checkpointing in the notebook.

Which pipeline activity setting can improve throughput by allowing multiple activities to run at the same time rather than sequentially?

Data integration unit (DIU) count

An eventhouse stores high-volume log data. Queries that filter on a timestamp column are slow because the data is not optimally partitioned. The engineer wants to improve query performance without changing the data model. Which action should be taken?

Change the eventhouse's data retention policy to reduce the amount of data scanned.

Set the table's partition policy to partition by the timestamp column.

Enable the eventhouse's auto-scaling feature.

Create a materialized view that pre-aggregates the log data by timestamp.

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 3

Optimize Performance DP-700 Practice Questions (Page 4)

Part of the Monitor and optimize an analytics solution 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 30 practice questions to prepare you well beyond it. (estimate)

30questions here

6free pages

7concepts

30–35%of the exam

Questions 16–20

16application · medium
A pipeline uses a Notebook activity that runs a Spark job to transform data. The job takes 30 minutes and uses a default Spark pool with 5 executors. The engineer wants to reduce runtime. Which change is most effective?
Select an answer first
17foundation · easy
Which Eventhouse feature allows you to distribute data across multiple physical nodes to improve query performance by enabling parallel processing?
Select an answer first
18foundation · easy
Which query performance technique involves analyzing the query and its underlying tables to produce an efficient execution plan that the database engine can follow?
Select an answer first
19foundation · easy
Which pipeline activity setting can improve throughput by allowing multiple activities to run at the same time rather than sequentially?
Select an answer first
20application · medium
An eventhouse stores high-volume log data. Queries that filter on a timestamp column are slow because the data is not optimally partitioned. The engineer wants to improve query performance without changing the data model. Which action should be taken?
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.

Optimize Performance DP-700 Practice Questions (Page 4)

Questions 16–20

A pipeline uses a Notebook activity that runs a Spark job to transform data. The job takes 30 minutes and uses a default Spark pool with 5 executors. The engineer wants to reduce runtime. Which change is most effective?

Which Eventhouse feature allows you to distribute data across multiple physical nodes to improve query performance by enabling parallel processing?

Which query performance technique involves analyzing the query and its underlying tables to produce an efficient execution plan that the database engine can follow?

Which pipeline activity setting can improve throughput by allowing multiple activities to run at the same time rather than sequentially?

An eventhouse stores high-volume log data. Queries that filter on a timestamp column are slow because the data is not optimally partitioned. The engineer wants to improve query performance without changing the data model. Which action should be taken?

Keep studying — Monitor and optimize an analytics solution