Microsoft Exam Questions

Which of the following describes the clause’s purpose?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the reason
for using the OFFSET-FETCH clause of the ORDER BY Transact-SQL statement.
Which of the following describes the clause’s purpose?

A.
It allows you to only retrieve a window or page of results from the result set.

B.
It allows you to only retrieve a window from the result set.

C.
It allows you to only retrieve a page of results from the result set.

D.
It allows you to retrieve a window or page of results, as well as the entire result set.

Explanation: