70-761 Sales Practice Questions

2. In a sales database, how would you calculate the total sales for each product category?

• AA. SELECT Category, SUM(Sales) FROM SalesData GROUP BY Category;
• BB. SELECT SUM(Sales) FROM SalesData;
• CC. SELECT Category FROM SalesData;
• DD. SELECT Category, COUNT(Sales) FROM SalesData GROUP BY Category;

8. What SQL statement can retrieve the top 5 products by sales?

• AA. SELECT TOP 5 ProductName FROM Products ORDER BY Sales DESC;
• BB. SELECT ProductName FROM Products LIMIT 5;
• CC. SELECT FIRST 5 ProductName FROM Products;
• DD. SELECT ProductName FROM Products ORDER BY Sales;