Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You manage a Microsoft Fabric workspace. A partner team lands nightly Parquet files in an Azure Data Lake Storage Gen2 (ADLS Gen2) container. Business users want to query this data from a Fabric lakehouse by using both T-SQL and Spark, while avoiding any additional data movement or duplication. Which ingestion approach should you implement?
Build a Dataflow Gen2 that loads the Parquet files into a lakehouse table each night.
Ingest the files with an Eventstream and land them into Real-Time Intelligence storage.
Create a OneLake shortcut in the lakehouse that points to the ADLS Gen2 Parquet folder.
Enable mirroring for the ADLS Gen2 container so that the files are replicated into OneLake.
A OneLake shortcut creates a metadata pointer from the lakehouse to a folder in external storage such as ADLS Gen2. Because the data stays in its original location, no copy operation is required, yet the files appear as native tables in the lakehouse and are queryable through both Spark and the SQL analytics endpoint. Mirroring is designed for databases, not file stores, and it physically replicates data into OneLake. Dataflow Gen2 performs an ETL load that copies data into the lakehouse, so it does not meet the zero-copy requirement. Eventstreams are intended for real-time streaming ingestion and are not suitable for scheduled batch file ingestion from ADLS Gen2.
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
How does a OneLake shortcut enable zero-copy data access?
Open an interactive chat with Bash
What are the key differences between Dataflow Gen2 and a OneLake shortcut?
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 .