WGU Data-Management-Foundations Question Answer
Which function is considered an aggregate function?
MAX
TRIM
ABS
DESC
Aggregate functionsperform calculationson a set of values and return asingle result.MAX()is one such function, returning thelargest value in a column.
Common Aggregate Functions:
A screenshot of a computer AI-generated content may be incorrect.
Example Usage:
sql
SELECT MAX(Salary) FROM Employees;
Retrieves thehighest salaryin the Employees table.
Why Other Options Are Incorrect:
Option B (TRIM) (Incorrect):Removes spaces from strings butis not an aggregate function.
Option C (ABS) (Incorrect):Returns theabsolute value of a numberbut doesnot aggregate multiple rows.
Option D (DESC) (Incorrect):Used in ORDER BY forsorting in descending order,not for aggregation.
Thus, the correct answer isMAX(), as it is atrue aggregate function.
TESTED 01 Jan 2026
Copyright © 2014-2026 ACE4Sure. All Rights Reserved