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.
What can you do when you use process chains? Note: There are 2 correct answers to this question.
A. Trigger delta merge.
B. Activate requests in DataStore objects (advanced).
C. Generate transformations.
D. Activate data transfer processes (DTPs).
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
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.
Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question.
A. SAP BW DataSource
B. Characteristic \
C. Virtual table using SAP HANA smart data access
D. Transformation
E. InfoSource
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
Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?
A. Suspend Replication and Resume Replication
B. Stop Replication and Resume Replication
C. Suspend Replication and Start Replication
D. Stop Replication and Start Replication
Which advantages does the SAP Lumira template for generic analysis provide? Note: There are 2 correct answers to this question.
A. You can create a bookmark to a navigation state and link it on any Web page.
B. You can use Visual Basic for Applications to improve the design.
C. You can compare two DataSources in one report.
D. You can use it for any BW query or SAP HANA calculation view.
Which reporting object do you use to combine data from different SAP BW InfoProviders?
A. BW query
B. Analysis workbook
C. DataProvider
D. Analysis view
You need to determine the number of customers in each country that have revenue in 2018. What is the reference InfoObject in an exception aggregation?
A. Counter
B. Customer
C. Country
D. Year
Which variables types allow filter values to be determined based on the user's authorizations? Note: There are 2 correct answers to this question.
A. Characteristic value variable
B. Formula variable
C. Hierarchy node variable
D. Hierarchy variable
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.
Your customer is using a pure SAP HANA native data warehouse approach. Which tools should the
customer install?
Note: There are 2 correct answers to this question.
A. SAP solutions for enterprise information management
B. BW Modeling Tools
C. SAP Information Steward
D. Process Chain Monitoring app
Why do you recommend the virtual data mart layer? Note: There are 2 correct answers to this question.
A. To build an interface for queries and reports
B. To combine different InfoProviders using Join operations or Union operations
C. To combine centrally managed data with local files
D. To build corporate memory for reconstructions
When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.
A. The hierarchical structure will be time-dependent.
B. The structure will contain formulas.
C. The structure will depend on the order of the row characteristics.
D. The structure exists in the source system.
E. The query data will be restricted to a hierarchy node.