A Spark job reads a large Delta table, performs a group-by aggregation, and writes the result to a new Delta table. The job is slow because of a large shuffle. The table has a high cardinality group-by column. The engineer wants to reduce the shuffle size and improve job performance. Which optimization should the engineer apply?

Increase the number of shuffle partitions to 2000.

Use a broadcast hint on the group-by column.

Cache the input table in memory to avoid reading it again.

Enable adaptive query execution (AQE) and set a skew join hint on the group-by column.

Which Spark configuration setting controls the number of partitions used when shuffling data during operations like joins and aggregations?

spark.sql.autoBroadcastJoinThreshold

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 3

Optimize Performance DP-700 Practice Questions (Page 3)

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 11–15

11expert · medium
A Spark job reads a large Delta table, performs a group-by aggregation, and writes the result to a new Delta table. The job is slow because of a large shuffle. The table has a high cardinality group-by column. The engineer wants to reduce the shuffle size and improve job performance. Which optimization should the engineer apply?
Select an answer first
12foundation · easy
Which Spark configuration setting controls the number of partitions used when shuffling data during operations like joins and aggregations?
Select an answer first
13foundation · easy
Which table optimization technique in a Fabric Lakehouse can reduce the number of small files and improve query performance by rewriting data into larger, consolidated files?
Select an answer first
14foundation · easy
Which Eventhouse optimization technique reduces query latency by keeping frequently accessed data in memory rather than reading from disk each time?
Select an answer first
15foundation · easy
Which query performance technique involves creating an additional structure that allows the database engine to quickly locate rows matching a WHERE clause without scanning the entire table?
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 3)

Questions 11–15

Which Spark configuration setting controls the number of partitions used when shuffling data during operations like joins and aggregations?

Which table optimization technique in a Fabric Lakehouse can reduce the number of small files and improve query performance by rewriting data into larger, consolidated files?

Which Eventhouse optimization technique reduces query latency by keeping frequently accessed data in memory rather than reading from disk each time?

Which query performance technique involves creating an additional structure that allows the database engine to quickly locate rows matching a WHERE clause without scanning the entire table?

Keep studying — Monitor and optimize an analytics solution