Which statement about the Copy Data Activity is true?

• A. Copy Data Activity can only transfer data between cloud-based data stores
• B. Copy Data Activity supports data movement from both on-premises and cloud-based sources
• C. Copy Data Activity is primarily used for complex data transformations and aggregations
• D. Copy Data Activity does not support parallelism or performance tuning options

Answer: (B)

At its core, the Copy Data Activity is about moving data from one place to another. It’s designed to transfer data between a wide range of data stores, using either cloud-based or on-premises resources. You can access on-premises sources via a self-hosted integration runtime and connect to cloud destinations, or vice versa, making it versatile for hybrid scenarios.

This activity is not geared toward heavy data transformation. If you need complex transformations and aggregations, you’d use a data flow or another transformation tool after copying the data. Copy Data Activity focuses on reliable, scalable data transfer, and you can tune performance with options like degree of copy, parallelism, and partitioning to handle large volumes efficiently.

So the statement that it supports data movement from both on-premises and cloud-based sources is true. The other options are incorrect because the activity is not limited to cloud-only sources, it is not primarily for complex transformations, and it does support parallelism and performance tuning.