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

Questions 26–30

1. 26application · medium

   A manufacturing company uses Azure Data Factory to orchestrate multiple pipelines that load data from various sources into a central data lake. The pipelines are developed by different teams, and they share common activities such as logging and error handling. The company wants to standardize these common activities and make them easier to maintain. What should you do?

   • ACreate a custom activity in each pipeline that performs the common logging and error handling.
   • BCreate a separate integration runtime for each team and configure the pipelines to use it.
   • CUse a shared pipeline that contains the common activities and call it from other pipelines using the 'Execute Pipeline' activity.
   • DUse a trigger to run all pipelines at the same time and rely on the monitoring dashboard to identify issues.
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   In Azure Synapse Pipelines, which trigger type is best for processing data in fixed, non-overlapping time windows, such as hourly batches?

   • AManual trigger
   • BSchedule trigger
   • CEvent-based trigger
   • DTumbling window trigger
   Reveal Solution Discussion Select an answer first
4. 28application · medium

   A company runs a Spark job in Azure Synapse as part of a pipeline. The Spark job processes streaming data from Event Hubs and writes aggregated results to a Delta Lake table. The job sometimes fails due to checkpointing issues, causing data loss or duplication. The team wants to make the job more reliable. What should they do?

   • AConfigure the Spark job to use a checkpoint location on Azure Data Lake Storage Gen2.
   • BAdd a retry policy to the pipeline activity that runs the Spark job.
   • CChange the output sink to a SQL pool instead of Delta Lake.
   • DIncrease the number of executors for the Spark job.
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   You have a batch pipeline in Azure Data Factory that occasionally fails due to transient network issues. Which activity setting should you configure to automatically retry the activity a few times before failing the pipeline?

   • ADependency condition on the activity
   • BRetry policy on the activity
   • CIntegration runtime type
   • DTimeout on the activity
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   In Azure Data Factory, what is the purpose of a pipeline parameter?

   • ATo store connection strings for linked services
   • BTo pass values into a pipeline at runtime
   • CTo configure the integration runtime
   • DTo define the schema of a dataset
   Reveal Solution Discussion Select an answer first