Manage Batches and Pipelines DP-203 Practice Questions (Page 7)

Questions 31–32

1. 31foundation · easy

   In Azure Data Factory, which component is used to initiate a pipeline run based on a schedule or an event?

   • ATrigger
   • BDataset
   • CLinked service
   • DIntegration runtime
   Reveal Solution Discussion Select an answer first
2. 32application · medium

   A healthcare company runs a nightly Azure Data Factory pipeline that loads patient records from a legacy system to Azure SQL Database. The pipeline has a Copy activity that fails when it encounters a row with a malformed date. The team wants the pipeline to continue processing the rest of the rows and log the failed rows for later investigation. What should they configure?

   • AAdd a 'Data Flow' activity with a conditional split to filter out bad rows.
   • BUse a 'Lookup' activity to validate the data before the copy and fail the pipeline if any bad rows are found.
   • CSet the Copy activity's 'Fault tolerance' to 'Skip incompatible rows' and enable logging.
   • DChange the sink to a staging table and use a stored procedure to handle errors.
   Reveal Solution Discussion Select an answer first