You are creating an Azure Data Factory data flow that will ingest data from a CSV file, cast columns to specified types of data, and insert the data into a table in an
Azure Synapse Analytic dedicated SQL pool. The CSV file contains three columns named username, comment, and date.
The data flow already contains the following:
✑ A source transformation.
✑ A Derived Column transformation to set the appropriate types of data.
✑ A sink transformation to land the data in the pool.
You need to ensure that the data flow meets the following requirements:
✑ All valid rows must be written to the destination table.
✑ Truncation errors in the comment column must be avoided proactively.
✑ Any rows containing comment values that will cause truncation errors upon insert must be written to a file in blob storage.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Francesco1985
Highly Voted 2 years, 10 months agoonyerleft
Highly Voted 2 years, 4 months agokkk5566
Most Recent 7 months, 4 weeks agoanks84
1 year, 7 months agoDeeksha1234
1 year, 9 months agoSebK
2 years, 1 month agoEmmettBrown
2 years, 3 months agoPallaviPatel
2 years, 3 months agovictor90
2 years, 4 months agorashjan
2 years, 4 months agosatyamkishoresingh
2 years, 8 months agoMarcus1612
2 years, 7 months agoberserksap
2 years, 6 months agoAvithK
2 years, 8 months agodata_guy
4 months, 3 weeks ago