What is the purpose of Z-ordering in Delta Lake?

To automatically partition the table

To compress data to reduce storage

To co-locate related data in the same set of files to improve query performance

A data engineer is designing an ingestion process that must read JSON files from an external API response and load them into a Delta table. Which step is part of designing the ingestion logic?

Determining the extraction method and file type of the source data

Setting up a data quality dashboard

Selecting the cluster size for the target table

Defining the primary key for the target table

A financial services company receives market data updates every few seconds. They need to compute real-time risk metrics and also maintain a historical archive for regulatory queries. The risk metrics require sub-second latency, while the archive is queried infrequently. Which data loading approach should they use?

Streaming ingestion for real-time metrics and batch writes to an archive table

Use Azure Data Factory to load data every 5 seconds

Streaming ingestion for both real-time metrics and archive

Batch ingestion only, with a 1-minute interval

A marketing team analyzes website clickstream data. They need to answer questions like 'How many clicks per user per day?' and 'What is the average session duration per campaign?' The raw data is at the event level. To reduce query time and storage costs, what granularity should they use for the analysis table?

Daily aggregate per user and campaign

Microsoft Certified:Azure Databricks Data Engineer Associate

Domain 3Objective 1

Design and Implement Data Modeling in Unity Catalog DP-750 Practice Questions (Page 1)

Part of the Prepare and process data domain, which accounts for 30–35% of the DP-750 exam. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~15–28 in this domain), expect 4–7 from this objective — we provide 42 practice questions to prepare you well beyond it. (estimate)

42questions here

9free pages

10concepts

30–35%of the exam

Questions 1–5

1foundation · easy
What is the purpose of Z-ordering in Delta Lake?
Select an answer first
2foundation · easy
A data engineer is designing an ingestion process that must read JSON files from an external API response and load them into a Delta table. Which step is part of designing the ingestion logic?
Select an answer first
3expert · hard
A financial services company receives market data updates every few seconds. They need to compute real-time risk metrics and also maintain a historical archive for regulatory queries. The risk metrics require sub-second latency, while the archive is queried infrequently. Which data loading approach should they use?
Select an answer first
4application · medium
A marketing team analyzes website clickstream data. They need to answer questions like 'How many clicks per user per day?' and 'What is the average session duration per campaign?' The raw data is at the event level. To reduce query time and storage costs, what granularity should they use for the analysis table?
Select an answer first
5application · medium
A data science team creates a temporary table for exploratory analysis. They want to drop the table later and have the underlying files removed automatically. They do not need to share the table with other teams. Which table type should they use?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-750

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-750” is a trademark of its owner, used for identification only.

Design and Implement Data Modeling in Unity Catalog DP-750 Practice Questions (Page 1)

Questions 1–5

What is the purpose of Z-ordering in Delta Lake?

A data engineer is designing an ingestion process that must read JSON files from an external API response and load them into a Delta table. Which step is part of designing the ingestion logic?

A data science team creates a temporary table for exploratory analysis. They want to drop the table later and have the underlying files removed automatically. They do not need to share the table with other teams. Which table type should they use?

Keep studying — Prepare and process data