You work for MDFT Pro, a well-known training agency that manages student enrollment data. Claire, a Data Engineer at MDFT Pro, has created a Fabric warehouse called StudentRecords that loads data using a data pipeline named DailyEnrollmentSync. The pipeline uses a Copy data activity with a dynamic SQL source that generates different SQL queries based on parameters passed at runtime (such as date ranges, department IDs, and course categories). The pipeline is scheduled to run every 15 minutes to keep the warehouse synchronized with the source enrollment system. Recently, Claire discovered that DailyEnrollmentSync keeps failing during certain time windows. To troubleshoot the issue, she needs to identify the exact SQL query that was executed when the pipeline failed, including all the dynamically generated values and parameters. This information will help her determine whether the failure is caused by syntax errors in the query generation logic or invalid parameter values.
What should Claire do to identify which SQL query was executed when the pipeline failed?
Choose the correct answer from the options below.
Explanations for each answer: