Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

A Fabric solution ingests telemetry from IoT devices at a sustained rate of 250 000 events per second. You use an Eventstream to land the data into a Fabric Eventhouse table that analysts query with T-SQL. During peak traffic, analysts report slow query response times even after data has fully landed. Investigation shows that events often arrive several minutes late, causing multiple small, temporally-overlapping segments to be created in the table.

You need to improve both data-write and query performance while keeping compute consumption as low as possible.

Which change should you implement first?

  • Create a materialized view on the Eventhouse table that pre-aggregates the most common queries.

  • Scale the SQL analytics endpoint of the workspace to a higher capacity tier during peak hours.

  • Increase the number of physical partitions in the Eventhouse to match the number of IoT devices.

  • Enable the Optimize for out-of-order data feature on the destination Eventhouse table.

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