Microsoft Fabric Data Engineer Associate DP-700 Practice Question
Your organization has an existing Fabric lakehouse that stores 18 months of telemetry as Delta tables in OneLake. You must build a Real-Time Intelligence solution that joins the live sensor eventstream with this historical dataset while avoiding any additional data movement or duplication. Which storage approach should you configure for the historical data so it can be queried together with the streaming data in KQL?
Export the Delta data to Azure Blob Storage and ingest it from there as native storage.
Configure Fabric mirroring to replicate the lakehouse tables into Real-Time Intelligence.
Load the Delta files into new native KQL tables inside the Real-Time Intelligence workspace.
Create a shortcut in the KQL database that references the Delta folder in the lakehouse.
Shortcuts expose files that are already stored in OneLake to a KQL database without copying them. Creating a shortcut that points to the Delta folders in the lakehouse lets Real-Time Intelligence query the historical telemetry alongside the incoming eventstream. Native storage would create new KQL tables and copy the data, and mirrored storage is intended for syncing external transactional databases rather than data that is already resident in OneLake.
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 OneLake shortcut in Microsoft Fabric?
Open an interactive chat with Bash
What are Delta files, and how do they work in Fabric lakehouses?
Open an interactive chat with Bash
What is KQL, and why is it useful for Real-Time Intelligence solutions?
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 .