DP-203 Question #243: Real Exam Question with Answer & Explanation

Question

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 Analytics dedicated SQL pool. The CSV file contains 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

Options

• AAdd a select transformation that selects only the rows which will cause truncation errors.
• BAdd a sink transformation that writes the rows to a file in blob storage.
• CAdd a filter transformation that filters out rows which will cause truncation errors.
• DAdd a Conditional Split transformation that separates the rows which will cause truncation errors.