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 with a warehouse in Fabric that contains a table named 'Products' with columns 'ProductID', 'ProductName', 'Category', and 'Price'. You need to write a SQL query to find the highest priced product in each category. How would you structure this query?
A
SELECT Category, MAX(Price) AS HighestPrice FROM Products GROUP BY Category;
B
SELECT Category, Price AS HighestPrice FROM Products;
C
SELECT Category, MAX(Price) AS HighestPrice FROM Products;
D
SELECT Category, Price AS HighestPrice FROM Products GROUP BY Category;