Which feature provides calculations such as Count and Sum over records?

Which feature provides calculations such as Count and Sum over records?

• A. Aggregate Functions
• B. Fields Requested
• C. Sort Order
• D. Criteria

Answer: (A)

Aggregate calculations over a set of records are provided by aggregate functions. These functions summarize data across many rows and return a single value, such as counting how many records exist or summing a numeric column. They can be applied to an entire dataset or within grouped subsets to produce one result per group. For example, you might use an aggregate function to count all active incidents or to sum the total downtime across all servers. Fields requested determines which columns are shown, not how data is summarized. Sort order changes how results are arranged, not the values calculated. Criteria filters which records are included, but does not perform calculations on the entire set. So aggregate functions are the feature that enables calculations like Count and Sum over records.

Aggregate calculations over a set of records are provided by aggregate functions. These functions summarize data across many rows and return a single value, such as counting how many records exist or summing a numeric column. They can be applied to an entire dataset or within grouped subsets to produce one result per group. For example, you might use an aggregate function to count all active incidents or to sum the total downtime across all servers.

Fields requested determines which columns are shown, not how data is summarized. Sort order changes how results are arranged, not the values calculated. Criteria filters which records are included, but does not perform calculations on the entire set. So aggregate functions are the feature that enables calculations like Count and Sum over records.