Which of the following is incorrect about copy activity in Azure DataFactory?
Click on the arrows to vote for the correct answer
A. B. C. D.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.
The incorrect statement about copy activity in Azure DataFactory is option B: Copy CSVs from local File system storage to Azure Blob storage as Avro Format.
Explanation:
Azure DataFactory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines. The copy activity is one of the core activities in Azure DataFactory, which is used to copy data from a source to a destination.
Let's go through each option to see which one is incorrect:
A. Copy data to Azure Data Lake Storage Gen2 (ADLS2) from SQL server in Parquet Format. This option is correct. Azure DataFactory's copy activity can copy data from SQL Server to Azure Data Lake Storage Gen2 in the Parquet format. Parquet is a columnar storage format that is efficient for processing large amounts of data.
B. Copy CSVs from local File system storage to Azure Blob storage as Avro Format. This option is incorrect. The copy activity can copy CSV files from local file system storage to Azure Blob storage, but it cannot convert the CSV format to Avro format. Avro is a row-based format that is used for storing data in a compact and efficient manner.
C. Use copy activity to copy a compressed file in zip format located on-prem; extract it on the fly and insert it into an Azure SQL database. This option is correct. The copy activity can extract data from a compressed file in zip format and insert it into an Azure SQL database. This is useful when you have large files that need to be compressed to reduce their size for faster transfer.
D. Copy CSV Data in Gzip Compressed-text to Azure Blob Storage and then insert to Azure database for Postgres. This option is correct. The copy activity can copy Gzip compressed CSV data to Azure Blob storage and then insert it into an Azure database for Postgres. Gzip is a compression format that can be used to reduce the size of data for faster transfer.
In summary, the incorrect statement about copy activity in Azure DataFactory is option B, which states that CSV files can be copied to Azure Blob storage as Avro format.