exam questions

Exam DP-900 All Questions

View all questions & answers for the DP-900 exam

Exam DP-900 topic 1 question 48 discussion

Actual exam question from Microsoft's DP-900
Question #: 48
Topic #: 1
[All DP-900 Questions]

HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
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
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Eltooth
Highly Voted 2 years, 2 months ago
Max and Min
upvoted 19 times
...
mamahani
Highly Voted 1 year, 5 months ago
I took the exam 12.04.2023 and got 1000, 100% score; this question appeared, correct answer: MAX and MIN
upvoted 15 times
...
Swamy90572
Most Recent 3 weeks, 5 days ago
Max and Min
upvoted 1 times
...
man5484
1 month, 3 weeks ago
Max and Min are examples of aggregate functions in SQL. They are used to calculate the maximum and minimum values of a column, respectively. Aggregate functions perform a calculation on a set of values and return a single result.
upvoted 1 times
...
heobanten04
5 months, 1 week ago
I took the exam on 30.03.2024 and got 936; this question appeared, correct answer: MAX and MIN
upvoted 2 times
...
AGTraining
6 months, 2 weeks ago
max and min
upvoted 1 times
...
james2033
10 months, 2 weeks ago
MAX and MIN are aggregate functions.
upvoted 1 times
...
chiiiweiii
1 year, 6 months ago
Correct Answer
upvoted 3 times
...
YOGESHGP19111982
1 year, 7 months ago
MIN MAZ
upvoted 1 times
...
Abains
1 year, 10 months ago
Correct
upvoted 1 times
...
dk87
2 years, 3 months ago
Exam: 05/18/2022
upvoted 5 times
...
Ashishsingh07
2 years, 4 months ago
MIN MAX
upvoted 3 times
...
bfan95
2 years, 4 months ago
correct
upvoted 4 times
...
arif17
2 years, 4 months ago
answer is correct.
upvoted 3 times
...
pads98
2 years, 4 months ago
answer is correct.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago