
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.)
A
SELECT pipeline_name, timestamp, source_table, target_table FROM events_log;
B
SELECT pipeline_name, timestamp, source_table, target_table FROM events_log WHERE event_type = 'data_processing';
C
SELECT pipeline_name, timestamp, source_table, target_table FROM events_log ORDER BY timestamp DESC;
D
SELECT pipeline_name, timestamp, source_table, target_table FROM events_log WHERE event_type = 'data_processing' ORDER BY timestamp DESC;