Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

Your team ingests high-frequency IoT events into a Delta table named sensor_data in a Microsoft Fabric lakehouse. The pipeline appends thousands of 10-KB files every hour. Analysts run queries such as SELECT * FROM sensor_data WHERE device_id = 'abc' and say latency has grown to several minutes. You must improve query performance without changing the ingestion pattern. Which action should you perform?

  • Enable Change Data Feed by setting the table property delta.enableChangeDataFeed = true.

  • Run VACUUM sensor_data RETAIN 0 HOURS to remove obsolete files immediately.

  • Run OPTIMIZE sensor_data ZORDER BY (device_id) in a Fabric notebook.

  • Export the table to plain Parquet files and reload it with COPY INTO.

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