Question 48 of 156 from exam DP-900: Microsoft Azure Data Fundamentals

Question 48 of 156 from exam DP-900: Microsoft Azure Data Fundamentals

Prev Question Next Question

Question

HOTSPOT -

Select the answer that correctly completes the sentence.

Hot Area:

Explanations

An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:

-> APPROX_COUNT_DISTINCT

-> AVG

-> CHECKSUM_AGG

-> COUNT

-> COUNT_BIG

-> GROUPING

-> GROUPING_ID

-> MAX

-> MIN

-> STDEV

-> STDEVP

-> STRING_AGG

-> SUM

VAR -

-> VARP

https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15
Prev Question Next Question