Practice Question Answers and Explanations
- Correct answer: D
In the SAP HANA database (see Figure 12.3). The SAP LT Replication Server (SLT) is only used for the sidecar scenario. You still need to install SAP HANA Live, even if we do not have a sidecar scenario, so this is obviously wrong. We have ABAP code in the SAP ERP application server, not SAP HANA calculation views. Reporting tools have nothing to do with SAP HANA. They can use SAP HANA views, but they cannot be run in the reporting layer.
- Correct answer: A
Most SAP HANA Live views use the SQL engine. See the last bullet point after Figure 12.5.
- Correct answer: B
You can extend reuse and query views with the SAP HANA Live Extension Assistant. You cannot extend query views with a union node or your own custom views.
- Correct answer: A
Operational reporting moving back to the OLTP (operational) system. See the Background Information section.
- Correct answers: A, B, E
Data warehouse features include consolidation, data governance, and a full transactional history. Please note that the question did not specify that this is an SAP BW on SAP HANA system. It asked about a generic data warehouse. Having both OLTP and OLAP in one system is only available for SAP HANA real-time reporting. For a full list of data warehouse features, refer to Figure 12.2.
- Correct answer: D
The SAP HANA Live Browser can help generate files for SLT replication. SAP HANA Live Extension Assistant is used for modifying SAP HANA Live views. The Authorization Assistant helps with creating users and roles for SAP HANA Live. The SAP HANA studio does not have this functionality See the SAP HANA Live Browser section for more information.
- Correct answer: A
This is actually a “bad” question. It is clear from this chapter that you should not create custom query views by directly modifying SAP-delivered query views. However, the question asked if you can do it. Technically, it’s possible—but you will lose all your hard work during the next update of the SAP HANA Live content.
- Correct answer: B
When you upgrade the SAP HANA Live content, there is no option for you to keep your modifications. All changes to SAP-delivered content will be lost. This is different than the process in ABAP systems, which do ask if you want to save your modifications.
This question was very similar to the previous question. In the certification exam you will not find one question providing the answer to another. The SAP team ensures that this does not happen.
- Correct answers: B, C
SAP HANA Live consists of hundreds of predeveloped views, as well as some web-based tools. SAP HANA Live is not a new data warehouse, as we clearly specified that it will not replace SAP BW. With SAP HANA we do not store pre-calculated aggregates in cubes. This is only done in old non-SAP HANA data warehouses. See the Architecture section.
- Correct answers: A, C
An operational system is the transactional (OLTP) system. See the Background Information section.
- Correct answer: B
SAP HANA Live does not replace SAP BW. Only the operational reporting portion moves back from the data warehouse to the transactional system.
- Correct answer: B
You cannot view the metadata of SAP HANA Live views within the business user version of the SAP HANA Live Browser. This version is meant for nontechnical users. See the SAP HANA Live Browser for Business Users section.
- Correct answer: C
The SAP HANA Live views are in the /sap/hba subpackage. Figure 12.6 shows the SAP HANA Live content in SAP HANA studio.
- Correct answer: B
Most of the views in SAP HANA Live are calculation views. See Figure 12.5 in the SAP HANA Live Views section.
- Correct answers: B, D
Query views and value help views can be called by applications and reports (see Figure 12.4). Reuse views and private views may not be called directly.