Ingest and transform batch data
10 practice questions under this official exam objective (DP-700) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Store semi-structured data readable by T-SQL, KQL, and Spark in an eventhouse
When data must be read with T-SQL, KQL, and Apache Spark and is written only by Spark, an eventhouse is the suitable Fabric data store because it is t
Shortcut caching supports only S3/GCS shortcuts and excludes files larger than 1 GB
With the cache for shortcuts enabled, only data from supported external shortcut sources (currently GCS, S3, S3-compatible, and on-premises data gatew
An S3 shortcut with workspace caching enabled minimizes egress without persisting raw data
Creating a shortcut references the Amazon S3 email data without copying it into the lakehouses, and enabling shortcut caching for the workspace serves
A data pipeline copies on-premises SQL Server data through the gateway into a warehouse
A data pipeline with a Copy data activity connects to on-premises SQL Server through the on-premises data gateway and copies Database1 into Warehouse1
A data pipeline with a storage event trigger gives event-driven, high-throughput file ingestion
For 500 GB files arriving daily in an external source, a data pipeline is the item that both triggers on new-file events and delivers the highest thro
Data pipelines are the gateway-compatible item to load a warehouse from on-prem SQL Server
To copy data from the on-premises SQL Server database Database1 into Warehouse1, use a data pipeline: its Copy data activity works through the on-prem
Cache serves Products and Stores but Trips expired after 48 hours without access
With shortcut caching enabled, GCS files under 1 GB that were read within the cache retention period are served from cache: ProductFile (8 MB, accesse
ForEach over the MAR1 endpoints with Copy data loads the bronze layer
The pipeline uses a ForEach activity to iterate over MAR1's seven REST endpoints and a Copy data activity inside it to load each entity into the bronz
A data pipeline with a storage event trigger delivers the highest-throughput file ingestion
For 500 GB files added daily to an external source, a data pipeline both triggers on file-arrival events and copies the data into Lakehouse1 at the hi
An S3 shortcut makes the book reviews available without copying the data
Creating a shortcut that points to the Amazon S3 bucket references the book review files in place, satisfying the Litware requirement to make the revi