Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You are building a Microsoft Fabric Eventstream to ingest sensor readings from Azure IoT Hub. Each event payload contains the fields deviceId (string), ts (epoch milliseconds), temperature (double), and humidity (double).

You must satisfy the following processing requirements:

  • Guarantee that statistics are calculated by the timestamp in each event, even if messages arrive out of order.
  • Discard any event that arrives more than 2 minutes after its ts value.
  • Produce a running 1-minute tumbling-window average of the temperature for each device and store the result in a Real-Time Analytics KQL database table.

Which configuration should you apply to the Eventstream input or query to meet all the requirements?

  • Mark ts as the event-time column and use a 1-minute hopping window with a 30-second hop size; do not configure out-of-order tolerance because tumbling windows implicitly drop late data.

  • Use the system column _arrivalTime for windowing, add a WHERE clause that filters events older than 2 minutes, and write results to the KQL table every minute.

  • Mark ts as the event-time column on the IoT Hub input, set a 2-minute out-of-order tolerance with the late-arrival policy set to Drop, and in the query use a 1-minute tumbling window on ts with GROUP BY deviceId.

  • Leave event ordering at the default arrival time, and in the query declare a 1-minute session window on ts; set the session timeout to 2 minutes to ignore late events.

Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
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