Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
You have an Azure Data Lake Storage Gen2 account containing two folders named Folder1 and Folder2. You are using Azure Data Factory to copy multiple files from Folder1 to Folder2 and receive the following error:
Operation on target Copy_sks failed: Failure happened on 'Sink' side. ErrorCode=DelimitedTextMoreColumnsThanDefined, 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException, Message=Error found when processing 'Csv/Tsv Format Text' source '0_2020_11_09_11_43_32.avro' with row number 53: found more columns than expected column count 27., Source=Microsoft.DataTransfer.Common,'
What should you do to resolve this error?
You have an Azure Data Lake Storage Gen2 account containing two folders named Folder1 and Folder2. You are using Azure Data Factory to copy multiple files from Folder1 to Folder2 and receive the following error:
Operation on target Copy_sks failed: Failure happened on 'Sink' side. ErrorCode=DelimitedTextMoreColumnsThanDefined, 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException, Message=Error found when processing 'Csv/Tsv Format Text' source '0_2020_11_09_11_43_32.avro' with row number 53: found more columns than expected column count 27., Source=Microsoft.DataTransfer.Common,'
What should you do to resolve this error?
Exam-Like
A
Change the Copy activity setting to Binary Copy.
B
Comments
Loading comments...