You are working with Azure Synapse Analytics and need to transform data using Transact-SQL (T-SQL). The task involves joining two large tables, 'Orders' and 'Customers', on the 'CustomerID' field and then filtering the results to include only orders placed in the last year. Which T-SQL query would be most efficient for this task, considering the size of the tables and the need for performance optimization? | Microsoft Azure Data Engineer Associate - DP-203 Quiz