1.
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.)
Correct Answer(s)
A. Rebuild the filters.
D. Close the Query panel without executing and then open the query.
Explanation
To recover the deleted logical operator in a previously saved document, you can use two methods. First, you can rebuild the filters to recreate the logical operator. Second, you can close the Query panel without executing the query and then reopen it, which will restore the deleted logical operator.
2.
Which option can you use to convert a table block into a chart in Web Intelligence Rich Client?
Correct Answer
A. Right-click the table block and select "Turn To"
Explanation
In Web Intelligence Rich Client, to convert a table block into a chart, you can right-click the table block and select "Turn To". This option allows you to transform the table block into a chart format.
3.
Which method should you use to group query filters together to form one AND statement?
Correct Answer
A. Drag the queries together
Explanation
To group query filters together to form one AND statement, you should drag the queries together. This allows you to combine multiple filters into a single logical statement, ensuring that all conditions must be met for the query to return results. By dragging the queries together, you are effectively grouping them and indicating that they should be treated as a single unit in the query.
4.
Where is a Web Intelligence variable stored?
Correct Answer
B. In the document
Explanation
A Web Intelligence variable is stored in the document. This means that the variable is saved within the specific Web Intelligence document where it is created and can be accessed and used within that document only. It is not stored in the cell, Metadata Cube, or the Central Management Server (CMS).
5.
Which two break properties can you use when setting Break Priority? (Choose two.)
Correct Answer(s)
B. Vertical Breaks
D. Horizontal Breaks
Explanation
Break properties are used to control the layout and organization of data in a report. When setting Break Priority, two break properties that can be used are Vertical Breaks and Horizontal Breaks. Vertical Breaks allow for grouping and organizing data vertically, typically by a specific field or category. Horizontal Breaks, on the other hand, group and organize data horizontally, often by time periods or intervals. By using these two break properties, the report can be structured in a way that effectively presents and summarizes the data based on the desired grouping and organization.
6.
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?
Correct Answer
C. Measure
Explanation
To aggregate the number of cars sold by region in a report, you should use a "Measure" object. A Measure is used to perform calculations and aggregate data, such as summing up the number of cars sold. It allows you to apply mathematical operations to the data and provide meaningful insights by summarizing the information. Therefore, using a Measure object would be the appropriate choice in this scenario.
7.
Which three calculations can you use in a measure object in Web Intelligence? (Choose three.)
Correct Answer(s)
A. Min
B. Max
C. Count
Explanation
In Web Intelligence, a measure object is used to perform calculations on data. The three calculations that can be used in a measure object are Min, Max, and Count. The Min calculation returns the smallest value in a set of data, the Max calculation returns the largest value, and the Count calculation returns the number of values in a set of data. These calculations are commonly used to analyze and summarize data in reports or visualizations.
8.
Which two panels can you use to purge data from a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose two.)
Correct Answer(s)
A. Query
B. Report
9.
Which three elements are parts of a query filter? (Choose three.)
Correct Answer(s)
B. Object
C. Operator
D. Operand
Explanation
The three elements that are parts of a query filter are Object, Operator, and Operand. The Object refers to the attribute or field that is being filtered, the Operator defines the comparison or condition to be applied, and the Operand is the value or criteria that is used for the comparison. These three elements work together to specify the conditions that must be met in order for a query to return the desired results.
10.
Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?
Correct Answer
D. Dimension - Dimension
Explanation
When using Multi Queries in a Web Intelligence document, you can merge objects of the same type, specifically Dimension - Dimension. This means that you can merge two dimensions together to create a combined result. Merging other object types such as Dimension - Detail, Measure - Measure, or Dimension - Measure is not possible in this scenario.
11.
Which tab should you use to change the page orientation of a report?
Correct Answer
D. Select the report page; in Report Manager, select the "Properties" tab and select the "Page Orientation"
12.
Which message appears when you select "Use query drill" while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?
Correct Answer
B. The Scope of Analysis is not empty.
Explanation
When you select "Use query drill" while the Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report, the message that appears is "The Scope of Analysis is not empty." This means that there is already a defined scope for analysis in the report, and selecting the "Use query drill" option will allow you to drill down further within that scope to analyze the data in more detail.
13.
Which three types of local data files can you use to create a BusinessObjects Web Intelligence XI 3.0 document (WID)? (Choose three.)
Correct Answer(s)
A. TXT
C. CSV
D. XLS
Explanation
You can use TXT, CSV, and XLS files to create a BusinessObjects Web Intelligence XI 3.0 document. These file types are commonly used for storing and organizing data, and can be easily imported into the Web Intelligence tool for analysis and reporting purposes. XML files, on the other hand, are not mentioned as an option in the answer and therefore cannot be used to create a WID document.
14.
Which two operators are available when using wildcards in a query filter? (Choose two.)
Correct Answer(s)
B. Matches Pattern
D. Different from Pattern
Explanation
The two operators available when using wildcards in a query filter are "Matches Pattern" and "Different from Pattern". The "Matches Pattern" operator is used to search for values that match a specific pattern, while the "Different from Pattern" operator is used to search for values that do not match a specific pattern. These operators allow for more flexible and precise filtering of query results.
15.
What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?
Correct Answer
B. A new section is created.
Explanation
When you drop a dimension into a blank part of a report that contains two blocks without the ALT key selected, a new section is created. This means that the dimension will be added as a separate section in the report, allowing for further analysis and organization of the data.
16.
Which two options should you take before you finish creating a variable in Web Intelligence? (Choose two.)
Correct Answer(s)
A. Save
D. Validate
Explanation
Before finishing creating a variable in Web Intelligence, it is important to save the variable to ensure that any changes made are not lost. Additionally, validating the variable is necessary to check for any errors or inconsistencies in the formula or logic used. Therefore, the correct options to take before finishing creating a variable in Web Intelligence are to save and validate.
17.
Which panel should you use to view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID)?
Correct Answer
D. Interactive
Explanation
To view a Document Summary of a BusinessObjects Web Intelligence XI 3.0 document (WID), you should use the Interactive panel. This panel allows users to interact with the document and access various features and functionalities. It provides a comprehensive view of the document's summary, including key information such as data sources, variables, filters, and other document properties. The Interactive panel is designed to enhance the user experience and make it easier to navigate and analyze the document effectively.
18.
Which two statements are true about the AND operator? (Choose two.)
Correct Answer(s)
B. Used when all conditions are met by two filters
C. Used when all conditions are met by more than two filters
Explanation
The AND operator is used when all conditions are met by two filters and when all conditions are met by more than two filters. This means that both conditions must be true for the AND operator to return a true result. It is not used when any condition is met by two filters or when only one condition is met by any of the filters.
19.
Your document displays all data in black. Which dialog box should you use to configure the colors of your document data?
Correct Answer
A. Document Palette
Explanation
Antwort ist nicht genau bekannt. Kann eigentlich nur A oder B sein. Ich habe mit für A entschieden.
20.
Which three options are valid Page Layout Options in the Properties tab of a document? (Choose three.)
Correct Answer(s)
A. Top margin
B. Left margin
C. Page orientation
Explanation
The given options are valid Page Layout Options in the Properties tab of a document. The top margin option allows the user to adjust the margin at the top of the page. The left margin option allows the user to adjust the margin on the left side of the page. The page orientation option allows the user to choose between portrait or landscape orientation for the page layout. These options are commonly found in document editing software and are essential for customizing the layout and formatting of a document.
21.
Which three layout options can you use when creating sections in a report? (Choose three.)
Correct Answer(s)
A. Relative Position
B. Start on New Page
C. Keep Blocks Together
Explanation
When creating sections in a report, there are three layout options that can be used. The first option is "Relative Position", which allows the sections to be positioned relative to each other. The second option is "Start on New Page", which ensures that each section starts on a new page. The third option is "Keep Blocks Together", which prevents any blocks within a section from being split across multiple pages. These three options provide flexibility in organizing and presenting the content in a report.
22.
Which three can you use to start the Web Intelligence Rich Client from? (Choose three.)
Correct Answer(s)
A. InfoView
B. Command Line
C. Start > All Programs
Explanation
You can start the Web Intelligence Rich Client from InfoView, Command Line, and Start > All Programs. InfoView is a web-based portal that allows users to access and interact with Web Intelligence documents. The Command Line option allows users to launch the Rich Client using specific commands and parameters. Start > All Programs is a common method to access and launch applications on a Windows operating system. Central Management Console is not a valid option to start the Web Intelligence Rich Client.
23.
Which method can you use to build a custom sort?
Correct Answer
D. Select a column; on the toolbar, click the "Apply Sort" button and select "Custom Sort"
Explanation
To build a custom sort, you can select a column in the table and then click the "Apply Sort" button on the toolbar. From there, you can select the option for "Custom Sort". This method allows you to define specific sorting criteria and order for the data in the selected column.
24.
Which three options are default page number cells? (Choose three.)
Correct Answer(s)
A. Page Number
B. Total Number of Pages
C. Page Number / Total Pages
Explanation
The three default page number cells are "Page Number," "Total Number of Pages," and "Page Number / Total Pages." These options allow users to easily insert and display page numbers in a document. "Page Number" shows the current page number, "Total Number of Pages" displays the total number of pages in the document, and "Page Number / Total Pages" shows the current page number and the total number of pages in the document together.
25.
Which three are drill options? (Choose three.)
Correct Answer(s)
A. Hide drill toolbar
B. Show drill filters
D. Synchronize drill on report blocks
Explanation
The question asks for three drill options. The options "Hide drill toolbar," "Show drill filters," and "Synchronize drill on report blocks" are all drill options because they provide different functionalities related to drilling in a report. "Hide drill toolbar" allows the user to hide the toolbar that contains drill options, "Show drill filters" allows the user to see the filters applied during drilling, and "Synchronize drill on report blocks" ensures that drilling actions are synchronized across different report blocks.
26.
How many blocks can you create in a Web Intelligence document (WID)?
Correct Answer
E. Unlimited
Explanation
There is no limit to the number of blocks that can be created in a Web Intelligence document. This means that users can create as many blocks as needed to organize and present their data effectively.
27.
Where can you set the default universe when using Web Intelligence within InfoView?
Correct Answer
D. InfoView Preferences
Explanation
In Web Intelligence within InfoView, the default universe can be set in InfoView Preferences. This means that when creating reports or queries, the selected universe will be the default one unless specified otherwise. By setting the default universe in InfoView Preferences, it allows for a more streamlined and efficient workflow as users do not have to manually select the universe each time they create a new report or query.
28.
Where do you set the "Optional prompt" option in Web Intelligence Rich Client?
Correct Answer
A. Query Panel
Explanation
In Web Intelligence Rich Client, the "Optional prompt" option is set in the Query Panel. This panel allows users to create and modify queries for their reports. By setting the "Optional prompt" option in the Query Panel, users can define prompts that are not mandatory for the report execution. This means that users have the choice to enter values for these prompts or leave them blank, without affecting the report results.
29.
Which two statements are correct about hierarchies in Web Intelligence? (Choose two.)
Correct Answer(s)
C. They can be chosen using a custom Scope of Analysis.
D. They are used to define the drill path in the Scope of Analysis.
Explanation
Hierarchies in Web Intelligence can be chosen using a custom Scope of Analysis, allowing users to select specific hierarchies for analysis. Additionally, hierarchies are used to define the drill path in the Scope of Analysis, enabling users to navigate and drill down into data based on the defined hierarchy structure.
30.
Which two Web Intelligence Rich Client authentication methods enable you to export Web Intelligence documents (WID) to the Central Management Server (CMS)? (Choose two.)
Correct Answer(s)
B. LDAP
D. Enterprise
Explanation
LDAP and Enterprise are the two Web Intelligence Rich Client authentication methods that enable the export of Web Intelligence documents (WID) to the Central Management Server (CMS). LDAP (Lightweight Directory Access Protocol) is a protocol used to access and manage directory information, including user authentication. Enterprise authentication method allows users to authenticate using their enterprise credentials, such as Active Directory or SAP authentication. Both of these methods provide the necessary authentication for exporting WID to the CMS.
31.
What is the default behavior when creating a report from two queries from the same universe?
Correct Answer
B. Dimension objects are automatically merged.
Explanation
When creating a report from two queries from the same universe, the default behavior is that the dimension objects are automatically merged. This means that if both queries have the same dimension, it will be merged into a single dimension in the report. This allows for easy comparison and analysis of data from both queries.
32.
You create a document with data from multiple data providers. Which two tasks can you perform to include all data from all providers in the same report block? (Choose two.)
Correct Answer(s)
A. Synchronize the data providers.
B. Manually merge all dimensions.
Explanation
To include all data from multiple data providers in the same report block, you can perform two tasks. Firstly, you need to synchronize the data providers, which ensures that the data from all providers is aligned and can be combined effectively. Secondly, you need to manually merge all dimensions, which involves combining the dimensions from each data provider into a single dimension in the report block. By synchronizing the data providers and merging the dimensions, you can include all the data from all providers in the same report block.
33.
Which method should you use to activate "Interactive Viewing"?
Correct Answer
B. Preferences in InfoView
Explanation
To activate "Interactive Viewing," you should use the method of accessing Preferences in InfoView. This suggests that within the InfoView interface, there is a specific section or option labeled "Preferences" where you can enable the "Interactive Viewing" feature.
34.
Which method can you use to change the object qualification of an object within Web Intelligence Rich Client?
Correct Answer
A. In the Query panel, select the qualification.
Explanation
To change the object qualification of an object within Web Intelligence Rich Client, you can select the qualification in the Query panel. This means that you need to navigate to the Query panel and choose the desired qualification for the object in question.
35.
Where are formulas stored when created in Web Intelligence?
Correct Answer
B. On the report page
Explanation
When formulas are created in Web Intelligence, they are stored on the report page. This means that the formulas are saved within the specific report document where they were created. They are not stored in the universe, the Central Management Server (CMS) database, or the metadata of the Cube. The report page serves as the container for all the formulas and allows users to access and use them within the context of the report.
36.
Which three object types can you use in a Web Intelligence universe query? (Choose three.)
Correct Answer(s)
B. Detail
C. Measure
D. Dimension
Explanation
In a Web Intelligence universe query, you can use three object types: Detail, Measure, and Dimension. Detail objects provide specific information about a data point, Measure objects perform calculations on data, and Dimension objects provide context or grouping for data analysis. These three object types allow users to retrieve and analyze data effectively in a Web Intelligence universe query.
37.
What is the maximum number of sub-alerts that an alerter can contain?
Correct Answer
B. 8
Explanation
The maximum number of sub-alerts that an alerter can contain is 8.
38.
Which two options can you change when using Quick Display Mode? (Choose two.)
Correct Answer(s)
C. Vertical Records Per Page
D. Horizontal Records Per Page
Explanation
When using Quick Display Mode, you have the option to change the number of Vertical Records Per Page and Horizontal Records Per Page. This allows you to customize the display of query results based on your preferences and requirements. By adjusting these settings, you can control the number of records displayed vertically and horizontally on each page, providing a more efficient and organized view of the data.
39.
Which three methods can you use to apply a section in the Web Intelligence Rich Client? (Choose three.)
Correct Answer(s)
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".
Explanation
To apply a section in the Web Intelligence Rich Client, you can use the following three methods:
1. Drag the column to be sectioned outside the block.
2. Select the column, then select the Reporting Menu Option, and choose "Set As Section".
3. Right-click on the column you want to create a section on, and from the drop-down menu, select "Set As Section". These methods allow you to easily organize and categorize data within your report for better analysis and presentation.
40.
Which two options are valid options when you save a Web Intelligence document (WID) in the Web Intelligence Rich Client? (Choose two.)
Correct Answer(s)
A. Save As
D. Save to My Computer As
Explanation
When saving a Web Intelligence document (WID) in the Web Intelligence Rich Client, two valid options are "Save As" and "Save to My Computer As". The "Save As" option allows the user to save the document with a different name or in a different location. The "Save to My Computer As" option enables the user to save the document directly to their computer. These options provide flexibility in managing and organizing the saved WID files.
41.
Which two locations can you use to set the drill options? (Choose two.)
Correct Answer(s)
C. Preferences in InfoView
E. Tools/Options in Web Intelligence Rich Client
Explanation
You can set the drill options in Preferences in InfoView and Tools/Options in Web Intelligence Rich Client. These locations provide settings and options for customizing the drill behavior and functionality in the respective platforms.
42.
Which three rules apply when you manually synchronize queries? (Choose three.)
Correct Answer(s)
A. Dimension value formats must be the same.
B. Dimensions with different names can be merged.
D. Dimensions from multiple data sources can be merged.
Explanation
When manually synchronizing queries, there are three rules that apply. First, the dimension value formats must be the same, meaning that the values representing the dimensions should be in the same format across all queries. Second, dimensions with different names can be merged, allowing for consolidation and alignment of data. Lastly, dimensions from multiple data sources can be merged, enabling the combination of data from different sources into a single query.
43.
Where should you configure the regional settings of a Web Intelligence document (WID) within InfoView?
Correct Answer
D. InfoView Preferences
Explanation
In InfoView, the regional settings of a Web Intelligence document can be configured in the InfoView Preferences. This allows the user to set the desired regional settings for their specific needs, such as language, date format, currency, and number format. By configuring these settings in InfoView Preferences, the user ensures that the Web Intelligence document will be displayed according to their preferred regional settings.
44.
Which two settings can you configure for the Sample option in the Properties tab of the Web Intelligence Query panel? (Choose two.)
Correct Answer(s)
A. You can enable the "Fixed" option.
D. You can specify a "Sample Result" set.
Explanation
In the Properties tab of the Web Intelligence Query panel, there are two settings that can be configured for the Sample option. The first setting is enabling the "Fixed" option, which allows the user to fix the sample result set so that it remains the same even if the underlying data changes. The second setting is specifying a "Sample Result" set, which allows the user to define the specific data subset they want to retrieve from the query.
45.
Which two personal folders are available by default to Web Intelligence users? (Choose two.)
Correct Answer(s)
A. Inbox
B. My Favorites
Explanation
By default, Web Intelligence users have access to two personal folders: Inbox and My Favorites. The Inbox folder is where users receive and store incoming messages and documents. My Favorites is a folder where users can save and organize their frequently accessed reports or documents for quick and easy access. These two folders provide users with a convenient way to manage their personal files and ensure efficient workflow within the Web Intelligence platform.
46.
Which two are benefits of using breaks? (Choose two.)
Correct Answer(s)
B. Makes the table block easier to read
D. Enables the use of subtotals in one block
Explanation
"Using breaks" = Benutzung von Umbrüchen
47.
Which method should you use to see report filters?
Correct Answer
B. On the toolbar, click the "Show/Hide Filter Pane" button
Explanation
To see report filters, you should click the "Show/Hide Filter Pane" button on the toolbar. This button allows you to display or hide the filter pane, which contains all the report filters. By clicking this button, you can easily access and view the report filters.
48.
Which three statements are true about alerters? (Choose three.)
Correct Answer(s)
B. You can apply multiple alerters to one block.
C. You can apply the same alerter to multiple blocks.
D. You can control the order in which alerters are applied.
Explanation
Alerters can be applied to charts, multiple alerters can be applied to one block, the same alerter can be applied to multiple blocks, and the order in which alerters are applied can be controlled.
49.
Which two methods can you use to define document properties? (Choose two.)
Correct Answer(s)
B. Right-click the report tab, select "Document Properties" and enter the required information.
C. Right-click a blank space on the report page, select "Document Properties" and enter the required information.
Explanation
To define document properties, you can use two methods: right-clicking the report tab and selecting "Document Properties" and entering the required information, and right-clicking a blank space on the report page, selecting "Document Properties" and entering the required information. These methods allow you to access the document properties and input the necessary details for the report.
50.
Which three are prerequisites for combining data from multiple data providers? (Choose three.)
Correct Answer(s)
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.
Explanation
To combine data from multiple data providers, there must be two or more queries in the document, ensuring that data is being pulled from different sources. Additionally, both data providers must have the same dimension values, allowing for consistent comparisons and analysis. Lastly, the data values from each linked dimension must have a common format to ensure accurate and meaningful integration of the data.