1. 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?

2. Which reporting object do you use to combine data from different SAP BW InfoProviders ?

3. Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question.

4. 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.

5. 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.

6. Which of the following methods supports the SAP HANA data virtualization approach with OBDC technology?

7. Which of the following are strengths of SAP S/4HANA embedded analytics? Note: There are 2 correct answers to this question.

8. 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?

9. How do you model plant-specific attributes for the characteristic material?

10. Save the structure as a global structure.

11. What happens if a query with time-dependent attributes is executed but NO query key date is set?

12. Which of the following use cases is classified as operational reporting?

13. What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question.

14. Which sources types can you select when you create an Open ODS view? Note: There are 3 correct answers to this question.

15. Which SAP tool do you suggest to create a pixel-precise formatted report?

16. What can you do when you use process chains? Note: There are 2 correct answers to this question.

17. Replicate the DataSource .

18. 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?

19. When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.

20. 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?

21. You load a DataStore object (advanced) every night. Where can you delete the request you loaded two nights ago without deleting the last request?

22. Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.

23. For which of the following revenue reporting requirements do you create restricted key figures?

24. You want to validate your SAP HANA data model.

What must you ensure to use the data preview functionality?

25. For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.