Which KQL keyword is used to limit the results of a query to a specified number of rows?

Which KQL keyword is used to limit the results of a query to a specified number of rows?

• A. Select
• B. Take
• C. Project
• D. Where

Answer: (A)

Limiting the number of rows returned by a KQL query is done with the take operator. You append | take N to the query to keep only the first N rows of the result. This is different from selecting which columns to show (project) or filtering which rows are included (where). If you wanted a random subset, you could use sample, but to strictly cap the result count, take is the correct choice.

Limiting the number of rows returned by a KQL query is done with the take operator. You append | take N to the query to keep only the first N rows of the result. This is different from selecting which columns to show (project) or filtering which rows are included (where). If you wanted a random subset, you could use sample, but to strictly cap the result count, take is the correct choice.