It’s time to put what you’ve learned to the test, get 5 questions right to pass this unit.
Q1.
What are the advantages of creating additional queries against the same universe in one document?
There are two correct answers.
A
Facilitates auto-merge for queries sharing at least one common dimension.
B
Improves performance of queries with prompt filters when data tracking is turned on.
C
Enables you to compare results with different filters applied.
D
Simplifies visualization of related results from different data sources.
Q2.
Web Intelligence cannot automatically merge the [Store name] and [Store] objects. What are the possible reasons?
There are two correct answers.
A
They are attributes.
B
They refer to the same column.
C
They have different names.
D
They are from different universes.
Q3.
You have merged dimensions from two queries. How do you include objects from a third query in the merge?
There are two correct answers.
A
Select the existing merged dimension → Click … for more options → Unmerge → Select common object from all three queries → Click… for more options → Add to Merge
B
Select the dimension from the new query → Ctrl + Click the existing merged → Click … for more options → Merge
C
Select the existing merged dimension → Ctrl + Click the same dimension from the new query → Click … for more options → Add to Merge
D
Select the existing merged dimension → Click … for more options → Unmerge → Select common object from all three queries → Click… for more options → Merge
Q4.
Which data sources can you choose from when adding a query to a document?
Choose the correct answer.
A
Only Universes, BW Queries, and HANA views.
B
Only sources used by other documents already published to BI Platform.
C
Only those already used by other queries in the same document.
D
Any of the supported data sources for a single query.
Q5.
Which of the following options are available the first time that you run a new query in an existing document?
There are three correct answers.
A
Insert a table in a new report.
B
Synchronize measures from existing queries to common dimensions.
C
Add new data into an existing block.
D
Include the result objects in the document without generating a table.
E
Insert a table in the current report.
Q6.
On what can you base a merge between multiple queries?
Choose the correct answer.
A
Dimension or attributes with a common data type.
B
Objects from same universe with different data types.
C
Measures only when the lowest level of aggregation is the same.
D
Variables with different names but same data type.