C2090-620 practice

Q5 Single choice

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 Quantty 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?

A
The author must add a sort key data item directly to Query3.
B
The author must sort the Order method data item in Query1 and the Product line data item in Query2.
C
The author must sort the data item in the Query3 that retrieves both Order method and Product line data.
D
The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3.