In which sequence can you create a reusable key figure structure? Note: There are 2 correct answers to this question.
A. 1. Create a new structure in the context menu of a calculated key figure. 2. Save the structure as a global structure.
B. 1. Apply filters to a key figure structure in SAP Analysis for Microsoft Office. 2. Save the structure as a global structure.
C. 1. Create a new structure in the context menu of an InfoProvider. 2. Add key figures, selections, and formulas.
D. 1. Create a new structure with key figures, selections, and formulas in a que 2. Save the structure as a global structure.
Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question.
A. Open Operational Data Store
B. Native SAP HANA data mart
C. Virtual data mart
D. Source system
Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data
category assigned?
Note: There are 2 correct answers to this question.
A. Join serveral tables.
B. Define text joins.
C. Persist master data.
D. Aggregate measures.
Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.
A. The table will be integrated into a native SAP HANA calculation view.
B. Aggregation and fast search is required for query execution.
C. When the table is accessed, all columns of a single record are processed.
D. The values in the columns are different. Therefore, data compression would NOT have much effect.
You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?
A. Condition
B. Calculated key figure
C. Restricted key figure
D. Exception
You need to integrate data from several SAP systems and non-SAP systems to support real-time analytics. Why do you recommend the SAP Landscape Transformation (SLT) Replication Server for real-time data replication into SAP HANA?
A. The SLT Replication Server provides flexible multisystem support to manage data replication from SAP and non-SAP source systems.
B. The SLT Replication Server provides log reader adapters for SAP and non-SAP sources.
C. The SLT Replication Server installed on a productive SAP BW/4HANA system improves the data transfer process.
D. Replication Server installation and configuration is always identical for SAP and non-SAP source systems.
You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?
A. Inner join with Dynamic Join properties
B. Referential join with Temporal Join properties
C. Inner join with Temporal Join properties
D. Referential join with Dynamic Join properties
Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question.
A. BW query
B. Open ODS view
C. CompositeProvider
D. Semantic group
You loaded a 5 MB table from a source system to SAP BW/4HAN
A. How do you explain that the size of the table is reduced to 1 MB?
B. The target is defined as column store and a delta merge job was executed.
C. The target is defined as row store and a delta merge job was executed.
D. The target is defined as row store without delta merge execution.
E. The target is defined as coiumn store without delta merge execution.
Which SAP HANA objects are automatically generated if you set the External SAP HANA Calculation View
flag for an SAP BW/4HANA object?
Note: There are 2 correct answers to this question.
A. SAP HANA attribute views
B. SAP HANA calculation views
C. SAP HANA privileges
D. SAP HANA analytic views