Which definition best describes a "Bookmark"?

• A. A URL which links to a predefined navigation state of a BI Web Application.
• B. A pointer used to highlight data by color codes on a BEx Analyzer report.
• C. A Microsoft Excel VBA link to a predefined navigation state of a BEx Analyzer report.
• D. A pointer used to highlight data by color codes on a BI Web Application.

Regarding web analysis, which of the following statements are true? (Choose three)

• A. You can navigate to a web-based output from a BEx Analyzer view of the query result.
• B. From the BEx Query Designer, you can change the contents of an Excel workbook.
• C. One or more queries can feed a single Microsoft Excel workbook or a single Web Application.
• D. From a web-based presentation of the query results, you can generate a Microsoft Excel workbook output.

Regarding currency translation, which of the following statements are true? (Choose two)

• A. Translating currency at query execution time helps improve query response time for the user.
• B. Translating currency during query execution provides for maximum flexibility in the choice of target currency.
• C. Translating currency as data is loaded using transformations can improve query performance by avoiding currency translation at query execution time.
• D. Translating currency at data load time is best since the user will never want to use different currency exchange rates.

In your planning project you have a basic InfoCube containing the actual data and a Real Time InfoCube containing the plan data. You want to use actual and plan data at the same time in your Integrated Planning scenario. Which of the following statements are correct? (Choose two)

• A. You can create an aggregation level on the Real Time InfoCube and combine it with the actual InfoCube in a MultiProvider. On the MultiProvider you can create a plan query that shows actual and plan data.
• B. You can include the actual InfoCube and the plan InfoCube in a MultiProvider, create an aggregation level on the MultiProvider, and create a distribution function that distributes plan data according to the actual data.
• C. Since only Real Time InfoCubes can be used in Integrated Planning, you must use a Data Transfer Process to move your actual data to the Real Time InfoCube. Then you plan on the Real Time InfoCube.
• D. You can create an aggregation level on the Real Time InfoCube and combine it with the actual InfoCube in a MultiProvider. On the MultiProvider you can create a planning function that copies the actual data to the plan InfoCube.

Which of the following statements about the size of a dimension is true?

• A. If a dimension has almost as many entries as the fact table, it and all of its characteristics must be categorized as a line item dimension.
• B. The relative number of entries in a dimension in relation to the fact table is the only factor that influences the performance of the system in the future.
• C. The absolute number of entries in a dimension should be as small as possible.