01. What is the difference between WARM and COLD data in SAP BW powered by SAP HANA?
There are 3 correct answers to this question.
a) WARM data can be made available for BW analysis optionally, while COLD data is never available.
b) WARM data can be changed with no restrictions, while COLD Data cannot be changed.
c) The WARM tier requires SAP HANA, while the COLD tier does not require SAP HANA.
d) WARM data supports all core BW processes, while COLD data is meant for backup and audit purposes only.
e) WARM Data is managed on the SAP HANA platform, while COLD data is managed outside of it.
02. Which in-memory-optimized features are offered by SAP BW powered by SAP HANA?
There are 3 correct answers to this question.
a) Transformations with ABAP routines
b) Key figure aggregations in `BWA only InfoCubes`
c) Transformations with ABAP managed database procedures (AMDP)
d) Data management in DataStore objects (advanced)
e) OLAP calculations in BW queries
03. In SAP Landscape Transformation, what can you define in the Replication Configuration transaction (LTRS)?
There are 3 correct answers to this question.
a) Filter for the source database trigger
b) Partitioning properties for the target table
c) The source system connection
d) Number of data transfer jobs
e) Table structure changes
04. Which of the following objects can be used as a source for an Open ODS view?
There are 3 correct answers to this question.
a) SAP HANA Decision Table
b) DataStore object (advanced)
c) SAP BW DataSource
d) SAP HANA Virtual Table
e) CompositeProvider
05. Which objects can you use as a direct source within an SAP HANA analysis process (HAP)?
There are 2 correct answers to this question.
a) SAP BW CompositeProvider
b) SAP HANA table
c) SAP HANA Calculation View
d) SAP BW InfoSource
06. Your customer runs SAP BW powered by SAP HANA and would like to build an SAP BW Query on top of an existing native SAP HANA Calculation View. The query should make use of a master data hierarchy that is already available in SAP BW.
What is the recommended approach for this scenario?
Please choose the correct answer.
a) Create an Analytical Index and associate only the relevant field of the SAP HANA Calculation View with the corresponding SAP BW InfoObject.
b) Create a CompositeProvider and associate the relevant field of the SAP HANA Calculation View with the corresponding SAP BW InfoObject.
c) Create an external SAP HANA view for the InfoObject and combine this with the existing SAP HANA Calculation View.
d) Create a VirtualProvider and associate all fields of the SAP HANA Calculation View with SAP BW InfoObjects.
07. What is the function of a private view in the virtual data model (VDM) of SAP S/4HANA Embedded Analytics?
Please choose the correct answer.
a) To consume interface views and create BW Queries on top of them.
b) To provide a direct interface to an analytical SAP BusinessObjects application.
c) To provide the low-redundancy model directly on the physical database tables.
d) To expose the business data of SAP S/4HANA systems for smart business cockpits.
08. Your SAP Business Warehouse (BW) has been migrated to SAP BW powered by SAP HANA successfully. It is your task as application developer to optimize the system and adapt it to SAP HANA as soon as possible.
Which options does the BW Migration Cockpit (report ZBW_HANA_MIGRATION_COCKPIT) provide you to for executing this duty?
There are 3 correct answers to this question.
a) Switch the SAP BW tables to SAP HANA-optimized column store format.
b) Convert MultiProviders to CompositeProviders.
c) Generate an SAP HANA-optimized SQL DDL for database objects.
d) Find any transformations that are no longer required and potentially retire InfoProviders.
e) Convert InfoCubes into the SAP HANA-optimized version.
09. Which of the following BW objects support the automatic generation of external SAP HANA views?
There are 3 correct answers to this question.
a) Open ODS views
b) Advanced DataStore objects
c) InfoCubes
d) MultiProviders
e) BW Queries
10. What happens when the “Trigger Delta Merge” process variant is executed for a given data target in a process chain?
Please choose the correct answer.
a) The delta between the new data and the already loaded data is calculated in the data target.
b) Data is transferred from the delta store to the main store of the data target.
c) The before and after images of the delta queue are merged and sent to the data target.
d) Only data from the delta queue is extracted and merged into the data target.