Microsoft
DP-203 · Question #347
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 o
The correct answer is B. Z-Ordering D. dynamic file pruning (DFP). https://learn.microsoft.com/en-us/azure/databricks/optimizations/dynamic-file-pruning https://learn.microsoft.com/en-us/azure/databricks/delta/data-skipping
Submitted by tarun92· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
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.
Options
- Athe clone command
- BZ-Ordering
- CApache Spark caching
- Ddynamic file pruning (DFP)
How the community answered
(32 responses)- A9% (3)
- B75% (24)
- C16% (5)
Explanation
https://learn.microsoft.com/en-us/azure/databricks/optimizations/dynamic-file-pruning https://learn.microsoft.com/en-us/azure/databricks/delta/data-skipping
Topics
#Delta Lake#Z-Ordering#dynamic file pruning#Azure Databricks optimization
Community Discussion
No community discussion yet for this question.