Which of the following is incorrect about copy activity in Azure DataFactory?

Answer options:

A.Copy data to Azure Data Lake Storage Gen2 (ADLS2) from SQL server in Parquet Format.
B.Copy CSVs from local File system storage to Azure Blob storage as Avro Format.
C.Use copy activity to copy a compressed file in zip format located in on-prem; extract it on the fly and insert it into an Azure SQL database.
D.Copy CSV Data in Gzip Compressed-text to Azure Blob Storage and then insert to Azure database for Postgres.

Correct Answer: D
Copy activity supports copy of files as-is between two file-based data stores. This copy can happen efficiently without serialization and deserialization. It supports Parsing and generating files of a given format. Copy CSV Data in Gzip Compressed-text to Azure Blob Storage and then insert to Azure SQL Database is supported, but it is not supported for Azure Database for Postgres. The important factor is Azure Database for Postgres is not currently supported as a sink for copy activity in the Azure data factory. Options A, B, and C are incorrect: Copy activity supports many activities which require serialization or deserialization and compression or decompression. So, these are all supported by copy activity in the Azure Data Factory.
Option D is correct: Currently, the Azure database for Postgres is not supported as a sink.
Reference: To know more, please refer to the docs below: 

https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-file-formats