PrepAway - Latest Free Exam Questions & Answers

What are two ways to select the top 20 rows for a given attribute?

What are two ways to select the top 20 rows for a given attribute? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Use the Advanced button in the Query Editor to select the attribute to sort by, and then select the
first 20 in the First/Last Functions.

B.
In the Properties Overview window click on Set Advanced Filtering Options, click Enable First/Last
Filter, select the attribute to sort by, click Descending, and then select the first 20 in the First/Last
Option.

C.
In the Properties Overview window click on the Query tab, click on Number of Rows to Return,
and enter 20. In the Workspace View click on the attribute column to sort by the attribute. Save the
workspace.

D.
Use the Advanced button in the Query Editor to select the attribute to sort by and click
Descending. In the Properties Overview window click on the Query tab, click on Number of Rows to
Return, and enter 20.

E.
In the Properties Overview window click on the Filter tab. Click the box under the attribute to
select it. Click in a cell under the attribute and select the Sort By function and Descending. In the
Properties Overview window click on the Query tab, click on Number of Rows to Return, and enter
20.


Leave a Reply