SAP Business Warehouse C_TBW60_74 Certification Dumps

1. What can you do before a transaction data load to improve the performance of the data load?

2. What are the properties of a standard InfoCube? There are 2 correct answers to this question.

3. Which of the following activities can you perform with the Metadata Repository?

4. You want to get the following information:
. Duration of data loads
. Report runtimes
. Details about how SAP BW InfoProviders, InfoObjects, InforSources, source systems and aggregates are used.
What can you use to get this information?

5. Your customer wants to analyze sales document transactional data at a calendar day level.
Which InfoProvider does SAP recommend that they use to load this type of data?

6. What are benefits of the Enterprise Data Warehouse (EDW) layers? There are 2 correct answers to this question.

7. What must you create to use data transfer process (DTP) error handling? Please choose the correct answer.

8. What happens when you compress the data of an InfoCube?

9. Which of the following initial tasks should you perform when designing an SAP BW data model? There are 2 correct answers to this question.

10. Which of the following settings can you make for error handling in the data transfer process? There are 2 correct answers to this question.

11. Your customer wants to store material data (infoObject OMATERIAL) and material proposed data (infoObject ZMAT_PROP).
Both infoObjects should be based on the same material master data.

12. Your customer wants to model their SAP BW system according to best practices. You propose using a layered scalable architecture (LSA).
Which of the following steps must you perform? There are 2 correct answers to this question.

13. What can you define in a currency translation type in SAP BW? There are 2 correct answers to this question.

14. Which of the following infoproviders do you use to model the operational data store layer in SAPBW? There are 2 correct answers to this question.

15. For which of the following reports must you use non-cumulative key figures?

16. In a customer hierarchy, customers are organized in regions and regions are assigned to different regional managers. One region has to be assigned to two regional managers.
How do you model the hierarchy?

17. What does SAP recommend you do to improve the overall reporting performance of a standard InfoCube in SAP BW 7.4? There are 3 correct answers to this question.

18. Which SAP BW InfoProviders can serve as data targets? There are 2 correct answers to this question.

19. Which of the following layers are part of an architected data mart layer? There are 3 correct answers to this question.

20. Which InfoProvider type do you typically use for the Virtualization layer in an Enterprise Data Warehouse architecture?