IBM
COG-612 · Question #20
COG-612 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock COG-612 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
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
Unlock COG-612 to see the answer
You've previewed enough free COG-612 questions. Unlock COG-612 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.