IBM Exam C9560-503 Topic 1 Question 28 Discussion

Actual exam question for IBM's C9560-503 exam

Question #: 28
Topic #: 1

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

AUse 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.

BIn 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.

CIn 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.

DUse 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.

EIn 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.

Show Suggested Answer

Suggested Answer: A, B

by Lai at May 09, 2022, 07:07 PM

Limited Time Offer

25%

Off

Get Premium C9560-503 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!