You are working as a Fabric Analytics Engineer and have been tasked with generating a report that summarizes the total hours worked by each employee in a specific month and year. The dataset includes columns for EmployeeID, WorkDate, and HoursWorked. The report must include the EmployeeID, the total hours worked, and the last date the employee worked during the specified month. Additionally, the solution must optimize for performance by minimizing the data scanned during the query execution. Which of the following SQL queries would you use to achieve this requirement? (Choose one option.) | Microsoft Fabric Analytics Engineer Associate DP-600 Quiz