DP-203 Certification Practice Question #270

Question

You are designing a solution that will use tables in Delta Lake on Azure Databricks.

You need to minimize how long it takes to perform the following:

•	Queries against non-partitioned tables
•	Joins on non-partitioned columns

Which two options should you include in the solution? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Accepted Answer

Microsoft Learn is unusually explicit here: dynamic file pruning is especially efficient for non-partitioned tables and joins on non-partitioned columns, which directly matches the question wording. The same guidance notes that DFP’s effect depends on how the data is clustered, making Z-Ordering the complementary second choice. The suggested answer appears partial, but the community consensus and official documentation clearly support BD.

More DP-203 practice questions