C_BOWI_40 · Question #29
Which two statements are true of an ambiguous query?
The correct answer is B. It can be resolved with a context. D. It contains one or more objects that can potentially return two different types of information. An ambiguous query in Web Intelligence arises when one or more objects can return different types of information, and it is resolved by applying a context defined in the universe.
Question
Which two statements are true of an ambiguous query?
Options
- AIt can be resolved with a loop.
- BIt can be resolved with a context.
- CIt contains all possible combinations of rows from the tables inferred by the objects.
- DIt contains one or more objects that can potentially return two different types of information.
How the community answered
(50 responses)- A18% (9)
- B76% (38)
- C6% (3)
Why each option
An ambiguous query in Web Intelligence arises when one or more objects can return different types of information, and it is resolved by applying a context defined in the universe.
Loops in a schema are resolved using aliases or contexts, but a loop itself is a different structural problem from an ambiguous query and is not the resolution mechanism for ambiguity.
Contexts are universe-level constructs that tell the query which join path to follow, directly resolving the ambiguity when an object can be interpreted in more than one way.
Returning all combinations of rows from tables describes a Cartesian product, which is the result of a missing join, not the definition of an ambiguous query.
This is the defining characteristic of an ambiguous query - at least one object maps to multiple possible join paths or fact tables, producing potentially conflicting result sets.
Concept tested: Resolving ambiguous queries using universe contexts
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/aa996c69-b2e5-4d2c-bdb0-0cf0c18bc5d0/4697acd36e041014910aba7db0e91070.html
Topics
Community Discussion
No community discussion yet for this question.