Ultimate access to all questions.
In a scenario where a data pipeline in Azure Data Factory consistently fails during the execution of a complex transformation activity, describe the troubleshooting steps you would take to identify and resolve the issue, including the tools and methods you would use to diagnose the problem.