SAP Certified Application Associate – Business Intelligence with SAP Netweaver 7.0
Questions
1. Which of the following statements is correct regarding the BEx Broadcaster and external sources of data?
Please choose the correct answer.
| a) | O | You can broadcast external, non – SAP data sources directly as long as they are read through the staging BAPI. | | b) | O | The external data sources must be multi-dimensional sources. | | c) | O | The external data sources must be mapped through a VirtualProvider. | | d) | O | External data sources are read through the Java connectors XMLA or ODBO. | |
2. Which of the following statements regarding exception aggregation are correct?
There are 2 correct answers to this question. Select which of the following answers are correct.
| a) | O | Exception aggregation is a feature that can be used in the definition of calculated key figures . | | b) | O | Exception aggregation is used to improve the response time of the query results. | | c) | O | The result of an exception aggregation can be used in another exception aggregation. | | d) | O | Exception aggregations are useful for highlighting important query results using color. | |
3. The cell editor...
There are 2 correct answers to this question. Select which of the following answers are correct.
| a) | O | ...is always available to make cell-specific definitions in the query definition. | | b) | O | ...is available to make cell-specific definitions in the query definition when two structures make up the definition. | | c) | O | ...allows you to define cells that have no direct reference to the associated structural components. | | d) | O | ...allows you to determine the format of a cell in the BEx Report Designer. | |
4. The key date of a query...
There are 2 correct answers to this question. Select which of the following answers are correct.
| a) | O | …used for restricting the time characteristics contained in a query. | | b) | O | ...is a decisive factor for the display of time-dependent texts and attributes, independent of the selected transaction data. | | c) | O | ...can be determined flexibly at the report runtime by using a variable | | d) | O | ...can also enable you to display the progression of attribute values in the selected time period using a variable that represents a time interval. | |
5. Display attributes...
There are 2 correct answers to this question. Select which of the following answers are correct.
| a) | O | ...primarily serve as supplemental information for the carrying characteristic | | b) | O | ...can be used for navigating in a report. | | c) | O | ...can be used to sort in a report. | | d) | O | ...can be used in the query definition to filter individual values of the attribute. | | e) | O | ...can be used as navigation attributes in the query definition. | |
6. A Pre-Query is used...
Please choose the correct answer.
| a) | O | ...to pre-calculate the query result, so that the report is displayed more quickly at runtime. | | b) | O | ...to fill a characteristic value variable used in the result set query with the pre-query values via the replacement path. | | c) | O | ...to pre-calculate the results set for the Chart web item in order to determine if the chosen chart type can be displayed. | |
7. Which BI objects are essential for extracting and loading data from a source system into an InfoCube when using the new data flow technology in SAP NetWeaver 7.0 BI?
There are 3 correct answers to this question. Select which of the following answers are correct.
| a) | O | Transfer Rule | | b) | O | DataSource | | c) | O | Transformation | | d) | O | InfoSource | | e) | O | Data Transfer Process | |
8. What is the content of a fact table?
Please choose the correct answer.
| a) | O | The key figures for a combination of characteristic SID values of the dimensions are stored in the fact table. | | b) | O | Changes to master data tables are only possible if new dimension keys are created in the fact table. | | c) | O | Both cumulative values and also key figures for non-cumulative values can be contained in the fact table. | |
9. UDC (Universal Data Connect) enhances SAP NetWeaver BI by supporting integration and connectivity to a wide range of data sources. Which of the following statements are true statements regarding UDC?
There are 2 correct answers to this question. Select which of the following answers are correct.
| a) | O | UDC integration with JDBC (Java Database Connection) only supports persistent data handling: data that is physically stored on BW. | | b) | O | UDC integration with JDBC (Java Database Connection) supports transient data handling: direct access to data that is stored in the source system. | | c) | O | Creation of UDC DataSources takes place in the Data Warehousing Workbench of SAP NetWeaver BI. | | d) | O | InfoPackages are scheduled for UDC DataSources even though the BI Java Connectors push data to the PSA tables. | |
10. Which of the following interfaces are used to connect SAP NetWeaver BI to external OLTP systems (from the BI view)?
There are 2 correct answers to this question. Select which of the following answers are correct.
| a) | O | Service API | | b) | O | UD Connect (JDBC Connector) | | c) | O | UD Connect (ODBC Connector) | | d) | O | DB Connect | |
Solutions
| 1 a) Incorrect | 2 a) Correct | 3 a) Incorrect | 4 a) Incorrect | 5 a) Correct | | 1 b) Incorrect | 2 b) Incorrect | 3 b) Correct | 4 b) Correct | 5 b) Incorrect | | 1 c) Incorrect | 2 c) Correct | 3 c) Correct | 4 c) Correct | 5 c) Correct | | 1 d) Correct | 2 d) Incorrect | 3 d) Incorrect | 4 d) Incorrect | 5 d) Incorrect |
|
|
|
| 5 e) Incorrect | |
| 6 a) Incorrect | 7 a) Incorrect | 8 a) Correct | 9 a) Incorrect | 10 a) Incorrect | | 6 b) Correct | 7 b) Correct | 8 b) Incorrect | 9 b) Correct | 10 b) Correct | | 6 c) Incorrect | 7 c) Correct | 8 c) Incorrect | 9 c) Correct | 10 c) Incorrect |
| 7 d) Incorrect |
| 9 d) Incorrect | 10 d) Correct |
| 7 e) Correct |
|
|
| |