PrepAway - Latest Free Exam Questions & Answers

How can the author ensure that all the order method results appear together and all product line results appea

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

PrepAway - Latest Free Exam Questions & Answers

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.

Explanation:


Leave a Reply