Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You need to design a streaming solution in Microsoft Fabric for an industrial IoT application that emits more than one million telemetry events per second. The operations team must run ad-hoc, sub-second time-series queries over several weeks of retained data by using Kusto Query Language (KQL) in Real-Time Analytics workspaces. Which streaming engine should you recommend to meet these requirements with the least development effort?
Use a pipeline copy activity that batches events into CSV files every minute and lands them in OneLake.
Implement an Apache Spark Structured Streaming notebook that writes to a Delta Lake table in a lakehouse.
Build a Dataflow Gen2 that ingests the sensor events into a lakehouse incremental table.
Create a Real-Time Analytics KQL database and enable streaming ingestion.
A KQL database that uses streaming ingestion can accept millions of events per second with minimal configuration, stores the data in native columnar format for efficient long-term retention, and makes new events queryable within a few seconds. Once ingested, the Kusto engine can return interactive KQL queries in sub-second time, satisfying the operations team's analytics requirement. While Spark Structured Streaming can process data with very low end-to-end latency, it generally requires additional development to persist high-volume time-series data in a structure that KQL can query efficiently. Dataflows Gen2 and pipeline copy activities are oriented toward batch or micro-batch workloads and do not meet the throughput and immediate KQL querying needs.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a KQL database in Microsoft Fabric and how does streaming ingestion work?
Open an interactive chat with Bash
What are the main advantages of KQL over other query languages for real-time analytics?
Open an interactive chat with Bash
Why is Apache Spark Structured Streaming not suitable for this scenario?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .