DP-700 · Question #31
You are developing a data pipeline named Pipeline1. You need to add a Copy data activity that will copy data from a Snowflake data source to a Fabric warehouse. What should you configure?
The correct answer is C. Enable staging. When copying data from Snowflake to a Fabric warehouse using a Data pipeline's Copy data activity, enabling staging is a crucial configuration for optimized and efficient data transfer.
Question
Options
- ADegree of copy parallelism
- BFault tolerance
- CEnable staging
- DEnable logging
How the community answered
(35 responses)- A3% (1)
- B9% (3)
- C77% (27)
- D11% (4)
Why each option
When copying data from Snowflake to a Fabric warehouse using a Data pipeline's Copy data activity, enabling staging is a crucial configuration for optimized and efficient data transfer.
Degree of copy parallelism optimizes throughput but is a secondary optimization; enabling staging addresses the fundamental mechanism for efficient bulk data transfer between Snowflake and a warehouse.
Fault tolerance deals with handling data quality issues during copy, which is a different concern than the core mechanism for efficient data transfer between these systems.
When copying data from or to data stores like Snowflake or a Fabric warehouse, enabling staging allows the data to be first copied to an intermediate Azure Blob Storage or Data Lake Storage Gen2. This method leverages the bulk loading capabilities of these data stores, significantly improving throughput and performance for large datasets, making it an essential configuration for this specific scenario.
Enable logging is a feature for monitoring and troubleshooting data copy failures or skipped rows, not a configuration for optimizing the data transfer process itself.
Concept tested: Data pipeline Copy data activity staging
Source: https://learn.microsoft.com/en-us/fabric/data-factory/copy-activity-performance#data-integration-units
Topics
Community Discussion
No community discussion yet for this question.