SAP BO Online certification exam model Tests

Thank you very much for taking test

Test your caliber

1. Which two operators are used as calculation context operators?
In	Select

2. Where can you set the default universe when using Web Intelligence within InfoView?
Query Panel	Report Panel
InfoView Options	InfoView Preferences

3. Which tab should you use to change the page orientation of a report?
Click File > Page Setup and select "Page Orientation"	In InfoView Preferences, change the default page orientation
Select the report tab; in Report Manager, select the "Properties" tab and select the "Page Orientation"	Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation"

4. Which three layout options can you use when creating sections in a report?
Relative Position	Avoid Page Break in Section

5. Which two are calculation context types?
Input	Logical

6. You want to compare the sales revenue performance of the top 20% of your customers to the average of all of your customers. You decide to apply a rank on the table that shows customers and revenue and create a variable to show the average revenue for all customers. Which function should you use in the variable?
NoFilter()	NoRank()
AverageAll()	IgnoreFilter()

7. Which three are drill options?
Hide drill toolbar	Prompt if drill requires additional data

8. Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?
Left(5; [Product Name])	Left([Product Name]; 5)
Right((Product Name), 5)	Right(5, [Product Name])

9. Which two locations can you use to set the drill options?
Report Properties	Query Panel Properties
Preferences in InfoView	Scope of Analysis Properties

10. Which type of relationship links sub-queries by default?
OR	AND
NOR	NAND

11. You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?
Sum	Detail
Measure	Dimension

12. Which statement is a benefit of using a Web Intelligence formula?
The formula can be reused in a document from the Data tab	The formula can be reused to create a variable
The formula can be saved into a new function	The formula can be saved and reused in a measure object

13. Which three data sources can you synchronize in a Web Intelligence XI 3.0 document (WID)?
Personal data files	Stored procedure data source

14. What is the default behavior when creating a report from two queries from the same universe?
Result produces two table blocks	Dimension objects are automatically merged
Results are shown on two different report tabs	Dimension objects are not automatically merged

15. Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?
Web Intelligence	InfoView Preferences
Microsoft Excel File Options	Web Intelligence Rich Client

16. Where are formulas stored when created in Web Intelligence?
In the universe	On the report page
In the Central Management Server (CMS) database	In the metadata of the Cube

17. Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?
The Scope of Analysis is empty	The Scope of Analysis is not empty
The query drill mode option is enabled	The query drill mode option is not enabled

18. Your document displays all data in black. Which dialog box should you use to configure the colors of your document data?
Document Palette	Document Formats
Display Preferences	Data Tracking Options

19. Which statement describes the performance impact that data tracking has on report refresh times, assuming that the data changes but the number of rows retrieved and the data volume stays the same?
It will refresh up to three times faster	It will refresh up to three times slower
It will refresh faster each time the report is refreshed	It will refresh slower each time the report is refreshed

20. Which two statements describe reasons for using the FormatDate() function?
You want to convert a string object into a date object	You want to convert a date object into a string object