IBM Exam C2090-620 Topic 1 Question 3 Discussion

Actual exam question for IBM's C2090-620 exam

Question #: 3
Topic #: 1

[All C2090-620 Questions]

In Report Studio, an author merges Query1 and Query2 into one result set (Query3) using a Union set operator. Query1 contains two data items: Order method and Revenue. Query2 also contains two data items: Product line and Quantity sold. The author wants to display the data from Query3 in a list report. How can the author ensure that all the order method results appear together and all product line results appear together in the list report?

AThe author must add a sort key data item directly to Query3.

BThe author must sort the Order method data item in Query1 and the Product line data item in Query2.

CThe author must sort the data item in the Query3 that retrieves both Order method and Product line data.

DThe author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3.

Show Suggested Answer

Suggested Answer: D

by Gracia at Dec 30, 2022, 12:19 AM

Limited Time Offer

25%

Off

Get Premium C2090-620 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!