Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
As a Fabric Analytics Engineer, you are working with a lakehouse that contains a dataset of employee performance reviews. The dataset includes columns for EmployeeID, ReviewDate, and PerformanceScore. Your manager has asked you to generate a report that shows the average performance score for each employee, sorted from highest to lowest average score. Additionally, the report must exclude any employees who have fewer than 3 reviews to ensure statistical significance. Which SQL query would you use to accomplish this task? Choose the correct option from the following:
A
SELECT EmployeeID, AVG(PerformanceScore) AS AvgScore FROM EmployeeReviews GROUP BY EmployeeID HAVING COUNT() >= 3 ORDER BY AvgScore ASC;
B
SELECT EmployeeID, AVG(PerformanceScore) AS AvgScore FROM EmployeeReviews GROUP BY EmployeeID HAVING COUNT() >= 3 ORDER BY AvgScore DESC;
C
SELECT EmployeeID, SUM(PerformanceScore) / COUNT() AS AvgScore FROM EmployeeReviews GROUP BY EmployeeID HAVING COUNT() >= 3 ORDER BY AvgScore DESC;
D
SELECT EmployeeID, MAX(PerformanceScore) AS AvgScore FROM EmployeeReviews GROUP BY EmployeeID HAVING COUNT() >= 3 ORDER BY AvgScore DESC;