Ultimate access to all questions.
As a data engineer at a financial services company, you are responsible for implementing a data pipeline that processes sensitive customer transactions. The pipeline must include audit logging to track data lineage for compliance with regulatory requirements. You need to query the events log to retrieve detailed information about each data processing event, including the pipeline name, timestamp, and the source and target tables involved. The query must ensure that only relevant data processing events are considered and that the results are presented in a way that facilitates easy review of the most recent activities first. Which SQL query best meets these requirements? (Choose one option.)