IBM
COG-612 · Question #20
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…
The correct answer is D. The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item. See the full explanation below for the reasoning.
Question
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?
Options
- 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
How the community answered
(55 responses)- A4% (2)
- B13% (7)
- C5% (3)
- D78% (43)
Community Discussion
No community discussion yet for this question.