Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.)
A
SELECT EmployeeID, SUM(HoursWorked) AS TotalHours, MIN(WorkDate) AS FirstWorkDate FROM EmployeeWorkHours WHERE YEAR(WorkDate) = 2022 AND MONTH(WorkDate) = 3 GROUP BY EmployeeID;
B
SELECT EmployeeID, SUM(HoursWorked) AS TotalHours, MAX(WorkDate) AS LastWorkDate FROM EmployeeWorkHours WHERE YEAR(WorkDate) = 2022 AND MONTH(WorkDate) = 3 GROUP BY EmployeeID;
C
SELECT EmployeeID, SUM(HoursWorked) AS TotalHours, AVG(WorkDate) AS AvgWorkDate FROM EmployeeWorkHours WHERE YEAR(WorkDate) = 2022 AND MONTH(WorkDate) = 3 GROUP BY EmployeeID;
D
SELECT EmployeeID, SUM(HoursWorked) AS TotalHours, MAX(WorkDate) AS LastWorkDate FROM EmployeeWorkHours WHERE WorkDate BETWEEN '2022-03-01' AND '2022-03-31' GROUP BY EmployeeID;