nerdexam
Microsoft

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.

Ingest and transform data

Question

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?

Options

  • ADegree of copy parallelism
  • BFault tolerance
  • CEnable staging
  • DEnable logging

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    9% (3)
  • C
    77% (27)
  • D
    11% (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.

ADegree of copy parallelism

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.

BFault tolerance

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.

CEnable stagingCorrect

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.

DEnable logging

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

#Copy data activity#Data staging#Data ingestion#Fabric Warehouse

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice