nerdexam
MicrosoftMicrosoft

DP-203 · Question #347

DP-203 Question #347: Real Exam Question with Answer & Explanation

The correct answer is B: Z-Ordering. 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, 2026

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)

Explanation

https://learn.microsoft.com/en-us/azure/databricks/optimizations/dynamic-file-pruning https://learn.microsoft.com/en-us/azure/databricks/delta/data-skipping

Community Discussion

No community discussion yet for this question.

Full DP-203 PracticeBrowse All DP-203 Questions