Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You are designing a streaming data load into a bronze Delta table in a Microsoft Fabric lakehouse. The data arrives at high volume in Azure Event Hubs, and downstream teams must see each event once and only once in the table, even if a network failure forces the streaming job to restart. Which approach should you implement to meet the requirement with minimal custom infrastructure?
Schedule a pipeline copy activity that writes Event Hubs data to a temporary blob container and loads it into the Delta table hourly.
Create a Real-Time Intelligence Eventstream that routes events to a KQL database connected to the lakehouse.
Use a Fabric notebook with Spark Structured Streaming to read from Event Hubs and write to the Delta table in append mode, storing checkpoints in the lakehouse.
Configure a Dataflow Gen2 with incremental refresh to pull data from Event Hubs into the lakehouse every minute.
Spark Structured Streaming can read from Azure Event Hubs as a source and write directly to a Delta table in Microsoft Fabric. When you configure the write operation in Append mode and enable checkpointing to a reliable storage location (for example, the lakehouse's _checkpoint directory), Spark keeps track of processed offsets and committed files. On restart, the engine uses the checkpoint to resume from the last successfully written batch, guaranteeing exactly-once delivery semantics to the target Delta table. A Dataflow Gen2 incremental refresh and a copy activity are batch-oriented, not suited for sub-second streaming with exactly-once guarantees. KQL database ingestion from Event Hubs supports at-least-once delivery and lands data in a Kusto database, not a Delta table in a lakehouse.
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 Spark Structured Streaming?
Open an interactive chat with Bash
What is a Delta table in Microsoft Fabric?
Open an interactive chat with Bash
How does checkpointing work in Spark Structured Streaming?
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
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .