SAP BO Online free exam model Tests

Thank you very much for taking test

Test your caliber

1. Which sort option should you use to add Temporary Values?
Ascending	Descending
Custom Sort	Adaptive Sort

2. You use the Last Refresh Date cell from the Templates in the Report Manager on your report page. You then reformat the cell as Tuesday, January 22, 2008. What is the result when you edit the formula, using the Formula toolbar, to concatenate the string "Last Refresh Date: " and the LastExecutiondate() function?
The cell reads "Last Refresh Date: 1/22/08"	The "Computation Error" error message is displayed
The "Incompatible Data Types" error message is displayed	The cell reads "Last Refresh Date: {Tuesday, January 22, 2008}"

3. Which two functions could you use to concatenate the First Name and Last Name objects?
=[First Name]+[Last Name]	=[First Name]&[Last Name]
=[First Name]||[Last Name]	=Concatenation([First Name],[Last Name])

4. Which panel should you use to create sub-queries?
Data Panel	Query Panel
Report Panel	Slice and Dice Panel

5. Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID)?
Advanced	Query
Active X	Interactive

6. Which two statements are correct about saving documents?
They are stored in folders	They are stored in categories

7. Which three can you use to start the Web Intelligence Rich Client from?
InfoView	Central Management Console

8. Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
Pos([Category] , "" )	Pos((Category) , "" )
Pos([Category] ; " " )	Pos({Category} ; " " )

9. Which three statements are true of contexts?
Contexts are defined in a report	Contexts are defined in a universe

10. Which method should you use to group query filters together to form one AND statement?
Drag the queries together	Drag the query filters to the Group panel
Select the filters, right-click and select Group	Select the filters, then click the Group Filters button on the toolbar

11. In the creation of a document, you have to import a personal data file. The data file contains date information, but when the file is imported, the dates are imported as character strings. Which function should you use to change the format from string to date?
Date()	Char()
ToChar()	ToDate()

12. Which three options are valid Page Layout Options in the Properties tab of a document?
Top margin	Background color

13. Which options can you select when you save a Web Intelligence document (WID)?
Refresh on open	Associate universe

14. You are working in the Web Intelligence Rich Client. Which two file formats can you save a document in?
TXT	XLS

15. Which Web Intelligence viewer panel should you use to create links to documents by browsing to the file without typing any syntax?
Java Report Panel	ActiveX Report Panel
Interactive HTML Panel	.NET Interactive Report Panel

16. You open a Web Intelligence document (WID) with tracked data changes. You wish to change the color of the tracked data. You however cannot change the format of the tracked data. What should you do to enable formatting of the tracked data?
Contact the system administrator	Edit the document in tracking mode
Open the document in tracking mode	Resave the document with data tracking formats enabled

17. Which two statements are true about the AND operator?
Used when any condition is met by two filters	Used when all conditions are met by two filters

18. How many blocks can you create in a Web Intelligence document (WID)?
1	2
4	Unlimited

19. Which tool do you use to edit merged objects in BusinessObjects Web Intelligence XI 3.0?
The Data tab of the Document Properties	The Edit Dimensions button on the Reporting toolbar
The Merge Dimensions button on the Reporting toolbar	The Object Properties in the Data tab of the Report Manager

20. Which is a benefit of using query drill?
Data is pre-fetched and stored for all levels prior to drill	Data is pre-formatted and stored for all levels prior to drill
Dedicated SQL statements are generated for each drill	Levels you can drill through are based on your security profile