Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

A Fabric lakehouse contains a Delta table named order_transactions that stores 12 months of data. About 50 small Parquet files (10 MB each) are appended every day by an ingestion pipeline. Business analysts access the table through the SQL analytics endpoint, and almost every report applies a filter on the OrderDate column. Report performance has been degrading. You need to improve query latency without changing the ingestion process or modifying any reports. Which action should you perform first?

  • Enable the property delta.autoOptimize.optimizeWrite on the table.

  • Run VACUUM on the Delta table with a 7-day retention period.

  • Create a cached view that selects only the needed columns, including OrderDate.

  • Execute OPTIMIZE order_transactions WITH (ZORDER = (OrderDate)).

Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot