1. Which sort option should you use to add Temporary Values?
A. Ascending
B. Descending
C. Custom Sort
D. Adaptive Sort
Ans: C
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?
A. The cell reads "Last Refresh Date: 1/22/08".
B. The "Computation Error" error message is displayed.
C. The "Incompatible Data Types" error message is displayed.
D. The cell reads "Last Refresh Date: {Tuesday, January 22, 2008}".
Ans: A
3. Which two functions could you use to concatenate the First Name and Last Name objects? (Choose two.)
A. =[First Name]+[Last Name]
B. =[First Name]&[Last Name]
C. =[First Name]||[Last Name]
D. =Concatenation([First Name];[Last Name])
E. =Concatenation([First Name],[Last Name])
Ans: A and D
4. Which panel should you use to create sub-queries?
A. Data Panel
B. Query Panel
C. Report Panel
D. Slice and Dice Panel
Ans: B
5. Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID)?
A. Advanced
B. Query
C. Active X
D. Interactive
Ans: D
6. Which two statements are correct about saving documents? (Choose two.)
A. They are stored in folders.
B. They are stored in categories.
C. They can be assigned to a folder.
D. They can be assigned to a category.
Ans: A and D
7. Which three can you use to start the Web Intelligence Rich Client from? (Choose three.)
A. InfoView
B. Command Line
C. Start > All Programs
D. Central Management Console
Ans: A,B and C
8. Which Pos() function syntax should you use to find the location of the space in the Category string "Evening wear"?
A. Pos([Category] , "" )
B. Pos((Category) , "" )
C. Pos([Category] ; " " )
D. Pos({Category} ; " " )
Ans: C
9. Which three statements are true of contexts? (Choose three.)
A. Contexts are defined in a report.
B. Contexts are defined in a universe.
C. You can combine objects in different contexts.
D. You can combine any objects within the same context to create a query.
Ans: B,C ,D
10. Which method should you use to group query filters together to form one AND statement?
A. Drag the queries together
B. Drag the query filters to the Group panel
C. Select the filters, right-click and select Group
D. Select the filters, then click the Group Filters button on the toolbar
Ans: A
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?
A. Date()
B. Char()
C. ToChar()
D. ToDate()
Ans: D
12. Which three options are valid Page Layout Options in the Properties tab of a document? (Choose three.)
A. Top margin
B. Left margin
C. Page orientation
D. Background color
E. Visited hyperlink colors
Ans: A,B,C
13. Which options can you select when you save a Web Intelligence document (WID)?
Note: There are 2 correct answers to this question.
A. Refresh on open
B. Associate universe
C. Permanent regional formatting
D. Send to users
Ans: A,C
14. You are working in the Web Intelligence Rich Client. Which two file formats can you save a document in? (Choose two.)
A. TXT
B. XLS
C. PDF
D. CSV
Ans: B,C
15. Which Web Intelligence viewer panel should you use to create links to documents by browsing to the file without typing any syntax?
A. Java Report Panel
B. ActiveX Report Panel
C. Interactive HTML Panel
D. .NET Interactive Report Panel
Ans: C
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?
A. Contact the system administrator.
B. Edit the document in tracking mode.
C. Open the document in tracking mode.
D. Resave the document with data tracking formats enabled.
Ans: A
17. Which two statements are true about the AND operator? (Choose two.)
A. Used when any condition is met by two filters
B. Used when all conditions are met by two filters
C. Used when all conditions are met by more than two filters
D. Used when only one condition is met by any of the filters
Ans: B,C
18. How many blocks can you create in a Web Intelligence document (WID)?
A. 1
B. 2
C. 4
D. 8
E. Unlimited
Ans: E
19. Which tool do you use to edit merged objects in BusinessObjects Web Intelligence XI 3.0?
A. The Data tab of the Document Properties
B. The Edit Dimensions button on the Reporting toolbar
C. The Merge Dimensions button on the Reporting toolbar
D. The Object Properties in the Data tab of the Report Manager
Ans: C
20. Which is a benefit of using query drill?
A. Data is pre-fetched and stored for all levels prior to drill.
B. Data is pre-formatted and stored for all levels prior to drill.
C. Dedicated SQL statements are generated for each drill.
D. Levels you can drill through are based on your security profile.
Ans: C
21. Which two operators are used as calculation context operators? (Choose two.)
A. In
B. Where
C. Select
D. Having
Ans: A,B
22. Where can you set the default universe when using Web Intelligence within InfoView?
A. Query Panel
B. Report Panel
C. InfoView Options
D. InfoView Preferences
Ans: D
23. Which tab should you use to change the page orientation of a report?
A. Click File > Page Setup and select "Page Orientation"
B. In InfoView Preferences, change the default page orientation
C. Select the report tab; in Report Manager, select the "Properties" tab and select the "Page Orientation"
D. Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation"
Ans: D
24. Which three layout options can you use when creating sections in a report? (Choose three.)
A. Relative Position
B. Start on New Page
C. Keep Blocks Together
D. Avoid Page Break in Section
Ans: A,B,C
25. Which two are calculation context types?
A. Input
B. Output
C. Logical
D. Conditional
Ans: A,B
26. 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?
A. NoFilter()
B. NoRank()
C. AverageAll()
D. IgnoreFilter()
Ans: A
27. Which three are drill options? (Choose three.)
A. Hide drill toolbar
B. Show drill filters
C. Prompt if drill requires additional data
D. Synchronize drill on report block
Ans: A,B,D
28. Which function would you use to extract the word "casual" from the product name "casual pants" of the Product Name field?
A. Left(5; [Product Name])
B. Left([Product Name]; 5)
C. Right((Product Name), 5)
D. Right(5, [Product Name])
Ans: B
29. Which two locations can you use to set the drill options? (Choose two.)
A. Report Properties
B. Query Panel Properties
C. Preferences in InfoView
D. Scope of Analysis Properties
E. Tools/Options in Web Intelligence Rich Client
Ans: C,E
30. Which type of relationship links sub-queries by default?
A. OR
B. AND
C. NOR
D. NAND
Ans: B
31. 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?
A. Sum
B. Detail
C. Measure
D. Dimension
Ans: C
32. Which statement is a benefit of using a Web Intelligence formula?
A. The formula can be reused in a document from the Data tab.
B. The formula can be reused to create a variable.
C. The formula can be saved into a new function.
D. The formula can be saved and reused in a measure object.
Ans: B
33. Which three data sources can you synchronize in a Web Intelligence XI 3.0 document (WID)? (Choose three.)
A. Personal data files
B. Stored procedure data source
C. Queries from the same universe
D. Queries from different universes
Ans: A,C,D
34. What is the default behavior when creating a report from two queries from the same universe?
A. Result produces two table blocks.
B. Dimension objects are automatically merged.
C. Results are shown on two different report tabs.
D. Dimension objects are not automatically merged.
Ans: B
35. Where can you set the priority options for saving a Web Intelligence document (WID) to Microsoft Excel?
A. Web Intelligence
B. InfoView Preferences
C. Microsoft Excel File Options
D. Web Intelligence Rich Client
Ans: B
36. Where are formulas stored when created in Web Intelligence?
A. In the universe
B. On the report page
C. In the Central Management Server (CMS) database
D. In the metadata of the Cube
Ans: B
37. Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?
A. The Scope of Analysis is empty.
B. The Scope of Analysis is not empty.
C. The query drill mode option is enabled.
D. The query drill mode option is not enabled.
Ans: B
38. Your document displays all data in black. Which dialog box should you use to configure the colors of your document data?
A. Document Palette
B. Document Formats
C. Display Preferences
D. Data Tracking Options
Ans: A
39. 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?
A. It will refresh up to three times faster.
B. It will refresh up to three times slower.
C. It will refresh faster each time the report is refreshed.
D. It will refresh slower each time the report is refreshed.
Ans: B
40. Which two statements describe reasons for using the FormatDate() function? (Choose two.)
A. You want to convert a string object into a date object.
B. You want to convert a date object into a string object.
C. You want to format a date so that it is displayed as a string when it is concatenated with another string.
D. You want to modify the format of a string object into a non-standard date format.
Ans: B,C
41. Which two statements are true of an ambiguous query? (Choose two.)
A. It can be resolved with a loop.
B. It can be resolved with a context.
C. It contains all possible combinations of rows from the tables inferred by the objects.
D. It contains one or more objects that can potentially return two different types of information.
Ans: B,C
42. Which method should you use to activate "Interactive Viewing"?
A. Preferences in Web Intelligence
B. Preferences in InfoView
C. In the Document Properties
D. In the Report Properties
Ans: B
43. You are working with a previously saved document and you have deleted a logical operator.
Which two methods can you use to recover the logical operator? (Choose two.)
A. Rebuild the filters.
B. Click the Undo button in the Query panel.
C. From the Tools menu, select Recover Operator.
D. Close the Query panel without executing and then open the query.
Ans: A,D
44. Which four authentication methods are available for Web intelligence Rich Client? (Choose four.)
A. AD
B. NT
C. LDAP
D. Vintella
E. Kerberos
F. Enterprise
Ans: A,B,C,F
45. Which Report Manager tab should you use to change report formatting?
A. Map
B. Data
C. Properties
D. Templates
Ans: C
46. Which three options are Web Intelligence drill mode options? (Choose three.)
A. Drill By
B. Drill Up
C. Drill Down
D. Drill Through
Ans: A,B,C
47. Which statement describes a benefit of using the NoFilter() function?
A. It overrides query filters.
B. It overrides query ranking.
C. It overrides report ranking.
D. It overrides universe security.
Ans: C
48. You are working with a set of store revenues. All stores have positive revenue values. Which formula should you use to display the variance value of the Revenue measure in your document when data tracking is active?
A. =[Revenue]/RefValue([Revenue])
B. =[Revenue]/PreValue([Revenue])
C. =[Revenue]/HistValue([Revenue])
D. =[Revenue]/BaseValue([Revenue])
Ans: A
49. Which function would you use to extract the word "pants" from the product name "casual pants" of the Product Name field?
A. Right(5; [Product Name])
B. Right([Product Name]; 5)
C. Right((Product Name), 5)
D. Right(5, [Product Name])
Ans: B
50. Which operator should you use to control the output context of a calculation that is relevant to the different environment levels within your document?
A. In
B. Out
C. ForAll
D. ForEach
Ans: A
51. Which BusinessObjects Enterprise tool supports Offline Mode logins?
A. InfoView
B. Java Panel
C. Interactive Panel
D. Web Intelligence Rich Client
Ans: D
52. Which two methods can you use to aggregate measures at the section level in BusinessObjects Web Intelligence XI 3.0? (Choose two.)
A. Drag the measure from the Data tab into the section header.
B. Copy the measure from the Data tab into the section header.
C. While pressing the ALT key, drag the measure from the table to the section header.
D. While pressing the CTRL key, drag the measure from the table to the section header.
Ans: A,D
53. Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?
A. Right-click the table block and select "Turn To"
B. Click Format > Charts and select "Convert to Chart"
C. Right-click the table block and select "Convert to Chart"
D. Click Tools > Charts and select "Change Table to Chart"
Ans: A
54. Where in Web Intelligence Rich Client interface can you see the data source for a document built on a local data source?
A. Global Settings
B. Report Settings
C. Query Properties
D. Document Properties
Ans: C
55. What automatically happens when you create a chart using the Templates tab in Web Intelligence?
A. Data is filtered using template dimensions.
B. Structure mode is selected.
C. Data is displayed on the report page.
D. Select Objects dialog box opens.
Ans: B
56. Which two are benefits of using breaks? (Choose two.)
A. Creates a navigation map
B. Makes the table block easier to read
C. Splits the block into smaller table blocks
D. Enables the use of subtotals in one block
Ans: B,D
57. Which two statements are true of contexts? (Choose two.)
A. You can combine objects in different contexts.
B. You cannot combine objects in different contexts.
C. You can combine any object within the same context to create a query.
D. You can combine only measures within the same context to create a query.
Ans: A,C
58. What is the maximum number for alerters in a document?
A. 8
B. 16
C. 30
D. 32
Ans: C
59. Which method should you use to store a Web Intelligence Rich Client document in an enterprise secured location?
A. Save the document to the Enterprise directories.
B. Save the document to the Enterprise documents.
C. Export the document to the Central Management Server (CMS).
D. Export the document to the Central Configuration Manager (CCM).
Ans: B
60. What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?
A. A new block is created.
B. A new section is created.
C. An error message is displayed.
D. The currently selected cell is displayed.
Ans: B
61. Which two are running aggregate functions in Web Intelligence? (Choose two.)
A. RunningMax()
B. RunningSum()
C. RunningTotal()
D. RunningMean()
Ans: A,B
62. For what purposes can you use the Page Layout of a report?
Note: There are 2 correct answers to this question.
A. To display the definition of the block
B. To define how the report will look like in PDF mode
C. To define how the report will look like when printed.
D. To display the report page by default.
Ans: B,C
63. Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
A. Local Settings
B. Browser Preferences
C. User Machine Settings
D. InfoView Preferences
Ans: D
64. Which three are prerequisites for combining data from multiple data providers? (Choose three.)
A. There are two or more queries in your document.
B. Both data providers must have the same dimension values.
C. Data values from each linked dimension must have a common format.
D. Object name from different universes in both data providers must be the same.
Ans: A,B,C
65. Which two break properties can you use when setting Break Priority? (Choose two.)
A. Order Breaks
B. Vertical Breaks
C. Crosstab Breaks
D. Horizontal Breaks
Ans: B,D
66. Which method should you use to activate data tracking?
A. Select the "Track" button on the toolbar.
B. In the Query panel, enable "Keep History".
C. In the InfoView Preferences, enable "Track Data Changes".
D. Right-click the column in the report and select "Activate Data Tracking".
Ans: A
67. Which two search criteria are valid when using Delegated List of Values? (Choose two.)
A. a*
B. *a
C. a%
D. %a
Ans: A,B
68. For which tasks do you use an If() function?
Note: There are 2 correct answers to this question.
A. To conditionally show rows in a block
B. To conditionally execute a scheduled report
C. To display dynamically grouped values
D. To display a dynamic list of values
Ans: A,C
69. You need to create a report that compares data to a reference data set. You create the report and activate the track data option. The report correctly indicates the changes in the data; however when you make another change to the report, the display no longer indicates any data tracking. What actions could have caused this behavior?
Note: There are 2 correct answers to this question.
A. You drilled outside the scope of analysis.
B. You activated query drill mode.
C. You added a report break.
D. You added a chart to the report.
Ans: A,B
70. To which destinations can you send a Web Intelligence document (WID) through InfoView of BusinessObjects Web Intelligence XI 3.0?
Note: There are 3 correct answers to this question
A. Broadcast Agent
B. Business Objects Inbox
C. FTP
D. Email
E. File Server
Ans: B,C,D
71. Which three calculations can you use in a measure object in Web Intelligence? (Choose three.)
A. Min
B. Max
C. Count
D. Count All
Ans: A,B,C
72. Which three object types can you use in a Web Intelligence universe query? (Choose three.)
A. Class
B. Detail
C. Measure
D. Dimension
E. User Defined
Ans: B,C,D
73. 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?
A. The cell reads "Last Refresh Date: 1/22/08".
B. The "Computation Error" error message is displayed.
C. The "Incompatible Data Types" error message is displayed.
D. The cell reads "Last Refresh Date: {Tuesday, January 22, 2008}".
Ans: A
74. You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?
A. =RunningSum([Sales Revenue], Region)
B. =RunningTotal([Sales Revenue], Region)
C. =RunningSum([Sales Revenue] ; ([Region]))
D. =RunningTotal([Sales Revenue], Reset[Region])
Ans: C
75. Which method should you use to see report filters?
A. Right-click the report and select "Show Filter Pane"
B. On the toolbar, click the "Show/Hide Filter Pane" button
C. In the Filters panel, enable the "Show Report Filters" option
D. In InfoView Preferences, enable the "Show Report Filters" option
Ans: B
76. Which three methods can you use to apply a section in the Web Intelligence Rich Client? (Choose three.)
A. Click the "Set Master" button in the toolbar.
B. Drag the column to be sectioned outside the block.
C. Select the column; select Reporting Menu Option and then select "Set As Section".
D. Right-click the column on which you want to create a section. From the drop-down menu, select "Set As Section".
Ans: B,C,D
77. Which scenarios should you use breaks for? (Choose two.)
A. Generating subtotals in one table block
B. Breaking the table into multiple table blocks
C. Grouping repeated values in one table block
D. Generating running sum in multiple table blocks
Ans: A,C
78. Which two character functions can modify character string and return the word "Department" from the string "Department Fast Foods"? (Choose two.)
A. Pos()
B. SubStr()
C. Length()
D. Replace()
Ans: B,D
79. Which two options can you change when using Quick Display Mode? (Choose two.)
A. Limit Query Results
B. Sample Query Results
C. Vertical Records Per Page
D. Horizontal Records Per Page
Ans: C,D
80. Which three features can you use in Interactive View mode of BusinessObjects Web Intelligence XI 3.0? (Choose three.)
A. Sort
B. Filters
C. Format Cell
D. Merge Dimensions
Ans: A,B,C