C_BOWI_40 · Question #143
Which two statements are true of the Web Intelligence default behavior when performing a UNION combined query method?
The correct answer is A. It performs a UNION. C. It returns all values less the duplicates. Web Intelligence's default combined query behavior uses UNION, which eliminates duplicate rows from the merged result set.
Question
Which two statements are true of the Web Intelligence default behavior when performing a UNION combined query method?
Options
- AIt performs a UNION.
- BIt performs a UNION ALL.
- CIt returns all values less the duplicates.
- DIt returns all values including the duplicates.
How the community answered
(36 responses)- A92% (33)
- B3% (1)
- D6% (2)
Why each option
Web Intelligence's default combined query behavior uses UNION, which eliminates duplicate rows from the merged result set.
Web Intelligence applies the SQL UNION operator by default when combining queries, which merges result sets while enforcing duplicate elimination.
UNION ALL retains all rows including duplicates and is not the default behavior; it must be explicitly selected as an alternative combined query method.
Because UNION is the default - not UNION ALL - the combined result set contains all unique rows with any duplicate records removed, consistent with standard SQL UNION semantics.
Returning all values including duplicates is the behavior of UNION ALL, which is the non-default option in Web Intelligence combined queries.
Concept tested: Combined query UNION default behavior in Web Intelligence
Source: https://help.sap.com/viewer/ad62de02-ba29-44fb-88c3-2cb1a7f5c659/4.2/en-US
Topics
Community Discussion
No community discussion yet for this question.