You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider.
What must you do first?
- A . Set The CompositeProvider Can Be Added to Another CompositeProvider flag.
- B . Assign consumption properties to the new SAP HANA calculation view.
- C . Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider.
- D . Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema.
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
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
For which business requirements do you suggest an SAP BW/4HANA modeling focus rather than an SAP HANA modeling focus? Note: There are 2 correct answers to this question.
- A . Report on a harmonized set of master data.
- B . Load snapshots or deltas on a periodic basis.
- C . Use existing HANA content models.
- D . Leverage SQL in-house knowledge.
Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object
(advanced)? Note: There are 3 correct answers to this question.
- A . Extraction mode
- B . Error handling
- C . Activation handling
- D . Data tiering
- E . Semantic groups
Which of the following methods supports the SAP HANA data virtualization approach with OBDC technology?
- A . SAP HANA smart data access
- B . SAP HANA smart data integration
- C . SAP Landscape Transformation Replication Server
- D . SAP Data Services
Which of the following are strengths of SAP S/4HANA embedded analytics? Note: There are 2 correct answers to this question.
- A . Operational data is accessed in real time.
- B . Redundant data is reduced.
- C . Cross-system consistency is generated.
- D . Historical data for strategic decisions is stored.
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
How do you model plant-specific attributes for the characteristic material?
- A . Compound the material and the plant.
- B . Define navigation attributes for the characteristic material.
- C . Define time-dependent attributes for the characteristic material.
- D . Join the material and the plant.
How do you model plant-specific attributes for the characteristic material?
- A . Compound the material and the plant.
- B . Define navigation attributes for the characteristic material.
- C . Define time-dependent attributes for the characteristic material.
- D . Join the material and the plant.
How do you model plant-specific attributes for the characteristic material?
- A . Compound the material and the plant.
- B . Define navigation attributes for the characteristic material.
- C . Define time-dependent attributes for the characteristic material.
- D . Join the material and the plant.
How do you model plant-specific attributes for the characteristic material?
- A . Compound the material and the plant.
- B . Define navigation attributes for the characteristic material.
- C . Define time-dependent attributes for the characteristic material.
- D . Join the material and the plant.
How do you model plant-specific attributes for the characteristic material?
- A . Compound the material and the plant.
- B . Define navigation attributes for the characteristic material.
- C . Define time-dependent attributes for the characteristic material.
- D . Join the material and the plant.
What happens if a query with time-dependent attributes is executed but NO query key date is set?
- A . The current date is used as key date.
- B . The system displays only NON-time-dependent attributes.
- C . The valid from date of the attribute is used as key date.
- D . The system displays an error message.
Which of the following use cases is classified as operational reporting?
- A . Year-to-date comparison reports containing prior and actual year numbers
- B . Evaluation of trends over several years
- C . Reporting requirements with monthly data refreshes
- D . Near-real-time access to original transactional values
What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question.
- A . InfoAreas
- B . Key figures
- C . InfoProviders
- D . Transformations
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
Which SAP tool do you suggest to create a pixel-precise formatted report?
- A . SAP Lumira, discovery edition
- B . SAP Analysis for OLAP
- C . SAP Crystal Reports for Enterprise
- D . SAP Analytics Cloud
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).
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).
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).
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).
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).
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).
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).
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).
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).
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).
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).
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).
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).
You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter.
Which offset do you need to retrieve the corresponding quarter of the previous year?
- A . -12
- B . -4
- C . -1
- D . -3
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.
You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced).
Which of the following Eclipse perspectives do you use?
- A . JavaScript perspective
- B . BW modeling perspective
- C . ABAP perspective
- D . SAP HANA modeler perspective
You load a DataStore object (advanced) every night. Where can you delete the request you loaded two nights ago without deleting the last request?
- A . From a DataStore object (advanced) based on the model template InfoCube if the request is NOT v u activated.
- B . From a DataStore object (advanced) based on the model template InfoCube if the request is activated.
- C . From a DataStore object (advanced) based on the model template Standard DataStore object if the request is activated and you execute a full load.
- D . From a DataStore object (advanced) based on the model template Standard DataStore object if the request is activated.
Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.
- A . SAP HANA models as part providers in CompositeProviders
- B . ABAP Managed Database Procedures in an SAP BW/4HANA transformation
- C . Query settings fo read near-line storage data
- D . Activation of a DataStore object (advanced)
- E . Global transfer routines for master data harmonization
For which of the following revenue reporting requirements do you create restricted key figures?
- A . Convert revenue into a number without currency.
- B . Identify the top five countries by revenue for each month.
- C . Determine the average revenue per customer.
- D . Compare this year’s planned revenue with last year’s actual revenue.
You want to validate your SAP HANA data model.
What must you ensure to use the data preview functionality?
- A . The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS.
- B . You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.
- C . The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.
- D . Your content package is assigned with sufficient repository privileges to the SYS REPO user.
For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.
- A . CompositeProvider
- B . Open ODS views
- C . DataStore object (advanced) of type standard DataStore object
- D . DataStore object (advanced) of type InfoCube